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
- - - - - - - - - - - - - - - - - - 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
- 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 ...
- 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.
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.
The available options are shown in the wizard.
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.
- 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 ...
- 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.
It depends on what you are doing, how big the database is and so on.
You should try it an see.
ODBC is slow.
- 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 ...
- 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 ...
- 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 ...
- 24 Apr 2024, 09:50
- Forum: Sage 50 UK version General Help
- Topic: Pressing number 8 crashes sage / SBDDESKTOP.EXE
- Replies: 1
- Views: 6691
Re: Pressing number 8 crashes sage / SBDDESKTOP.EXE
Delete the user and recreate
- 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 ...
- 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).
Just to be clear you want the total quantity of items on the order (excluding BOM components).
- 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.
- 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.
Do a classic install to that directory and it should be good.
- 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?
What directories are under c:\skyewright?
- 12 Apr 2024, 11:28
- Forum: Sage 50 UK version General Help
- Topic: Import plus update
- Replies: 6
- Views: 9650
- 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.
Deleting the revalued transaction also deletes the revaluation transaction.