SageForum for UK versions of Sage 50- Help and support.

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).

Please attach your report so we can see what you have done.

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.

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?

Here are the instructions.

https://www.makingithappen.co.uk/CI/upgrade.htm

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.

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 ...

I think you would need to redate the reval transaction by editing the transaction.

The solution is to match the transactions on the same date, then you don't get the revaluation happening on a different date.

"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 ...

Yes anyone with the url can see it.

You can take steps to obfuscate it, but it is a poor solution.

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...

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.

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...

If you are using the payment tab on the invoice to record receipt then yes, as all the data you need is the AMOUNT_PAID and you have that. Otherwise it is linking to the SI header, where you can access the OUTSTANDING amount You need to think about edge cases like part payment and how to deal with t...