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

Sorry very busy, I can't turn customers away to give free help on the forum.

Is "LIKE" a valid operator? Perhaps you could attach the layout to your post as it may be something else. As a general rule, when "debugging" reports it is useful to create an expression on the page which you can see the result of and be sure you are getting the values you expect...

I have several client who use Sage50 (UK version) all over the world.

Perhaps you could make an expression that sets the value to zero for BOM components (or the BOM, depending on which has the correct weight)

The only way to tell is to try. Sage uses common components between multiple products, the report designer in Sage 200 is the Same as in Sage 50 and I have been told this is why you can't run both on the same system. If they do not get along, then the solution may be to have a virtual machine to run...

The issue is that the stock data is repeated for every detail item (in this case the BOM) so the weight is repeated for each item on the BOM as well. You need to filter out the unwanted weights, one way would be to create a "Weight" Expression in the footer of the stock item, then add up t...

There are lots of ways to do this. An easy way would be to show the Account Opened Date on the customer screen, use a search to only show customers with a creation date greater than xx/xx/xxxx then use excel integration to send the list to excel, where you can then sort them by date, insert some lin...

You have not set a nominal code on the customer nor have you set a default.
either include a nominal code column or set a default >Settings>Customer Defaults

There is a genuine risk that you may be looking at a real HMRC email. Please see this video on the subject that will help you access if it is real or a scam https://www.youtube.com/watch?v=qNJgS5a8cMA Phone number such as 0300 200 3819 are not likely to be used by scammers because the 030xxxxxxxx nu...

It is not possible without the use of third party tools and even then it is not possible because the ACCOUNT_REF is not stored in the AUDIT_SPLIT table. I think you probably have a header record that has got detached from the split. You need to restore your last good backup or a data fix to resolve ...

You can change the sort order by clicking on the heading.
The Arrow points in whatever direction you are sorting by.
Clicking a second time reverses the sort direction.
You can sort by any heading, not just the Number.

03333 445950

It is not possible to automatically do it with Sage alone. The best I could do would be to use a keyboard stuffing script that would log in to sage, update all invoices to the ledger, then log out. This could be run on a scheduled task. Fundamentally, if an invoice has been sent, then it should not ...

I have some tools that might enable me to fix it.

If you want to give me a ring I can talk further.

Well just about any that has a date range will do

Try Agents Commission Report in the Agents Commission group.

Set the date rang eto last month, the totals at the bottom are the total for the month.