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 4603 matches
- 48 minutes ago
- Forum: Sage 50 Report Designer
- Topic: Report with BOM
- Replies: 5
- Views: 25
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 typica...
- 15 Apr 2024, 09:46
- Forum: Sage 50 Report Designer
- Topic: Report with BOM
- Replies: 5
- Views: 25
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: 5
- Views: 25
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: 55
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: 55
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: 55
- 05 Apr 2024, 10:32
- Forum: Sage 50 UK version General Help
- Topic: For Ex Revaluation Transactions
- Replies: 9
- Views: 106
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.
- 05 Apr 2024, 09:34
- Forum: Sage 50 UK version General Help
- Topic: On-premises Data Gateway - ODBC Connection String for Sage Line 50 v28
- Replies: 1
- Views: 37
Re: On-premises Data Gateway - ODBC Connection String for Sage Line 50 v28
This is what I use in Office VBA to build the string ConnectionString = "ODBC;DSN=SageLine50v" & DN & ";UID=" & UR & ";PWD=" & PW & ";DIR=" & DR & ";" DN is the Sage version UR is the UserName PW is the Password DR is ...
- 05 Apr 2024, 09:30
- Forum: Sage 50 UK version General Help
- Topic: For Ex Revaluation Transactions
- Replies: 9
- Views: 106
Re: For Ex Revaluation Transactions
I think you would need to redate the reval transaction by editing the transaction.
- 02 Apr 2024, 10:10
- Forum: Sage 50 UK version General Help
- Topic: For Ex Revaluation Transactions
- Replies: 9
- Views: 106
Re: For Ex Revaluation Transactions
The solution is to match the transactions on the same date, then you don't get the revaluation happening on a different date.
- 28 Mar 2024, 17:06
- Forum: Sage 50 UK version General Help
- Topic: For Ex Revaluation Transactions
- Replies: 9
- Views: 106
Re: For Ex Revaluation Transactions
"So when an Aged Creditors Report is run to 31/12/2023 it will so that there is still an outstanding amount rather than showing as completely cleared." When the transactions get matched, they are no longer outstanding so there is nothing to show on the aged report. If you have not matched ...
- 28 Mar 2024, 12:57
- Forum: Sage 50 Report Designer
- Topic: Drill downs on statement to access corresponding Invoice
- Replies: 3
- Views: 88
Re: Drill downs on statement to access corresponding Invoice
Yes anyone with the url can see it.
You can take steps to obfuscate it, but it is a poor solution.
You can take steps to obfuscate it, but it is a poor solution.
- 28 Mar 2024, 12:54
- Forum: Sage 50 UK version General Help
- Topic: For Ex Revaluation Transactions
- Replies: 9
- Views: 106
Re: For Ex Revaluation Transactions
The profit or loss on exchange happens when the bank transaction happens. So if you sel1 100EUR in Jan and pet paid 100EUR in Feb then the profit and loss transaction will happen in Feb, it can not happen on any other date. As the transaction is paid, it will have no impact on Aged Debtors/Creditors...
- 21 Mar 2024, 15:34
- Forum: Sage 50 Report Designer
- Topic: Invoice dynamic template if paid versus outstanding
- Replies: 5
- Views: 111
Re: Invoice dynamic template if paid versus outstanding
Bank feeds are available for all sorts of bank accounts, personal credit cards... they are a generic solution to all sage products, not just Sage 50
You will, however, need to check if your bank is supported.
You will, however, need to check if your bank is supported.
- 21 Mar 2024, 12:04
- Forum: Sage 50 Report Designer
- Topic: Invoice dynamic template if paid versus outstanding
- Replies: 5
- Views: 111
Re: Invoice dynamic template if paid versus outstanding
Merchant Services accounts are typically set up as separate bank accounts, so you instantly receive the money to the merchant services account then everyday a single transaction happens between the merchant services account and the main bank account transferring the value of a bunch of transaction f...