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

Sage access rights used to be really mucked up, they did different things to what they claimed but that was 5+ years ago.

I suggest you try using odbc with the demo data and setup a user in that with restricted access, if you get the same results then it is a "feature" of Sage.

Clearing the Audit Trail will reduce the number of headers and splits. However, there are quite a few gotchas along the way that can prevent things clearing, transaction chaining being the most difficult one to overcome. Try clearing it at your next year end. If you want to clear before your year ...

I suggest you contact support, it appears Sage is not operating correctly.

That windows appears not to have rendered correctly, suggests and issue with Windows

I wonder what that artefact does when you click on it (circled in Red)

The default is html but there is a drop down to select other formats, this is the same for all reports.

There is no 64 bit version of Sage until V30 Go to the vat return you want to send to excel Click on the print button in the bottom left Select the report that has the data you want to get into excel. Choose output to file Press Run Choose the format you want to save in csv/excel open the file saved ...

It is a memory error, using the 64bit version of 30.1 would, I expect resolve it.

I find export to excel to be very handy with small amounts of data, but with large amounts it is very very slow.

You might find it easier/faster to save one of the printable reports as csv/xls and open that.

If you want to keep things as they are then do nothing.

I thought you wanted to change it.

Is this in Price Lists? If so, you can import them. If you need to do a lot of changes, then using something like ImportPlus you can import the pricelists. There are a number of price lists tools other than vanilla imports, e.g. a tool that creates price lists when discounts are given to give the ...

The date on the purchase order is an 2 places.

There is one on the order and then multiple ones for each item.

Which you use depends on when the goods will be delivered. The whole order or in parts.

Note there are DUE_DATE and an DELIVERY_DATE which are easy to confuse.

You could work out the lead times by looking for GI transactions in Stock_Tran and comparing the date they were received to the date they were ordered on the PO. Not sure what you would then do with that. If you are building a model of stock requirements then, that is very dependant on the business ...

You can't convert reports, they refer to different variables in different tables.

You can use templates to apply a look and feel to all reports.

Please attach the SageDB dsn

Put a page break after on the invoice footer section.

You need to add a section for the invoice number so it can split, see this.