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

You can go as late as the version of sage you use supports.

31/12/2999 would be good

What are the groupings in the structure?

Sorts only work within the structure of your report.

To set the default criteria in any report. Open the report in the report designer. Got to Report>Criteria Screenshot 2022-11-07 105533.jpg Select the range you want to alter the default for and press modify. Screenshot 2022-11-07 105643.jpg Now change the Status from Enabled to Preset and press ok I...

Keep up to date with what is happening with tls by following this.

viewtopic.php?t=4311

Extract it from your stock transactions.

There is no way around this issue to my knowledge.

Sounds like you are trying to do something without all the information you need, ie the historical cost prices. You could always use the historical prices off purchase orders as a guide. Build a query that gets you the pop date, stockcode and price Then you can lookup the stock code and the date of ...

If you wish to calculate invoice profitability using the stock transactions, then you need to use the cost price off the stock transaction for that invoice / sales order rather than the average/last cost price. If the stock transaction history has been cleared you will not be able to do this as the ...

The sample file is already on your system, however for your convenience I attach it here.

The first account ref is "Account Ref" which is invalid as it has lowercase letters and a space in it.

Can you attach the file you are attempting to import

The error message says Looks like you have an invalid account reference.

is the product code valid?

see https://gb-kb.sage.com/portal/app/portl ... 7112331782

The same way you would if it was 1 product.