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

You do a stock journal

https://www.makingithappen.co.uk/sage-5 ... asect2.htm

To calculate the available stock from the stock transactions. On inwards transactions take the QTY_USED away from the QUANTITY that came in, this will tell you how much of that batch is left add them all up and you know how many you should have. Imagine this scenario:- We buy 100,000 of Product A We ...

In the Stock Transaction table QUANTITY is the quantity that were received in a delivery, there is another field called QTY_USED. To reconcile the 2 you need to add up the QUANTITY and take away the QTY_USED this will leave you with the quantity that is still in stock. This reconciliation process is ...

You can't do that in sage report designer. You need to do it as multiple queries and then combine them together. I would do it in Excel and have 3 queries One would get the stock code and cost price. Another would get the invoices and Items. The third would grab the payment info. You could do this ...

You can't link to items in 2 places the invoice items link repeats all the rest for each invoice item.

Why are you linking to the invoice item?

Does anyone know why.

I have managed to work around it by using a third party tool to do the allocation, but am I missing something?

I have come across this before. I don't remember the exact details of what I did to fix it. I think the issue is that Sage is automatically combining invoices that have the same account ref. I think I may have had to change the labels on the criteria for the report... I don't have time today to go ...

That is normal, when you have not done VAT returns, not Paid Invoices, not done Bank recs or already run the year end.

Sage have never bothered to get MAPI working with Thunderbird, as far as I knew it worked once a long long time ago but not for at least a decade or 2 My initial thought is that you may have updated Thunderbird by accident and that is what has broken things. Try going back to an earlier version. For ...

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