Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Search found 4626 matches

by brucedenney
07 Jun 2024, 11:30
Forum: Sage 50 Report Designer
Topic: Conditional format....limitations?
Replies: 5
Views: 14707

Re: Conditional format....limitations?

No You can use all the attributes exposed eg suppress print. Background colour is one of the options, not sure what your issue is? I thought you were wanting a border setting. ive guessed the synatx to add the border colour condition: The way to do that is to draw a box around the item set it as ...
by brucedenney
07 Jun 2024, 11:02
Forum: Sage 50 Report Designer
Topic: Conditional format....limitations?
Replies: 5
Views: 14707

Re: Conditional format....limitations?

The border is not an option.

The available options are shown in the wizard.
Untitled.png
However, you could add a text box around the subject and then suppress printing with a conditional format to get the result you are looking for.
by brucedenney
07 Jun 2024, 09:43
Forum: Sage 50 UK version General Help
Topic: Sage 50 UK ODBC driver for data imports by .net desktop application
Replies: 3
Views: 7445

Re: Sage 50 UK ODBC driver for data imports by .net desktop application

I don't use the SDK it is expensive, I use a 3rd party tool to write my integrations for others. The ODBC drivers are slow, they use a comma as a separator or something like that, which makes some SQL ambiguous. It is what the report designer uses and is functional for many if not most purposes. You ...
by brucedenney
06 Jun 2024, 10:02
Forum: Sage 50 UK version General Help
Topic: Sage 50 UK ODBC driver for data imports by .net desktop application
Replies: 3
Views: 7445

Re: Sage 50 UK ODBC driver for data imports by .net desktop application

Your mileage may vary.

It depends on what you are doing, how big the database is and so on.

You should try it an see.

ODBC is slow.
by brucedenney
20 May 2024, 15:52
Forum: Sage 50 Report Designer
Topic: Conditionally format decimal places.
Replies: 2
Views: 7460

Re: Conditionally format decimal places.

Hi Decimal places can not be set from a conditional format, however... You can create 2 fields one with 2 decimal places and one with none, you can then set one to be suppressed from printing. You then use conditional formatting to make the supressed on print if there is a match with the desired ...
by brucedenney
17 May 2024, 14:11
Forum: Sage 50 Report Designer
Topic: ODBC output versus Dage Report Output
Replies: 1
Views: 6528

Re: ODBC output versus Dage Report Output

The sage report designer, extracts data form sage using the ODBC drivers, so performance should be comparable. The drivers are slow. What you do with PowerQuery may be complex and slow things down even more. A popular solution, where data does not have to be up to the moment, is to cache the data in ...
by brucedenney
24 Apr 2024, 09:57
Forum: Sage 50 UK version General Help
Topic: Sage 50cloud bank accounts have disappeared
Replies: 1
Views: 10247

Re: Sage 50cloud bank accounts have disappeared

If you have an error or more then the problem is almost certainly the data error. The way the sage database works is as a linked list, each transaction points to the previous and the next. When you get errors it is normally one of these that has broken. Data repairs work by going through the ...
by brucedenney
18 Apr 2024, 11:11
Forum: Sage 50 Report Designer
Topic: Report with BOM
Replies: 6
Views: 12675

Re: Report with BOM

You do not want to be using a sub report. The problem you have is that it is adding up the Qty_Order for all the lines in the details section (where the BOM is printed) You only want to add it up when the Sop_Item changes. To do this select the QTY_ORDER expression in the Page footer (I would ...
by brucedenney
15 Apr 2024, 09:46
Forum: Sage 50 Report Designer
Topic: Report with BOM
Replies: 6
Views: 12675

Re: Report with BOM

You do not want to use a sub report.

Just to be clear you want the total quantity of items on the order (excluding BOM components).
by brucedenney
14 Apr 2024, 09:16
Forum: Sage 50 Report Designer
Topic: Report with BOM
Replies: 6
Views: 12675

Re: Report with BOM

Please attach your report so we can see what you have done.
by brucedenney
14 Apr 2024, 09:15
Forum: Sage 50 UK version General Help
Topic: Import plus update
Replies: 6
Views: 9650

Re: Import plus update

Looks like that c:\skyewright path is the server path and it is a classic install.

Do a classic install to that directory and it should be good.
by brucedenney
12 Apr 2024, 15:22
Forum: Sage 50 UK version General Help
Topic: Import plus update
Replies: 6
Views: 9650

Re: Import plus update

You have updated a workstation without updating the server first or have install as a standard install when it is server install, or possibly you might have a classic install.

What directories are under c:\skyewright?
by brucedenney
05 Apr 2024, 10:32
Forum: Sage 50 UK version General Help
Topic: For Ex Revaluation Transactions
Replies: 9
Views: 8782

Re: For Ex Revaluation Transactions

You will need to delete the revalued invoices/Credits then re-enter them and rematch them but on the correct date.

Deleting the revalued transaction also deletes the revaluation transaction.