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

How can I print statements for Customers showing both the Nett and Gross figures?

Hi,

Two Questions - What version of sage are you using? & Are you at all familiar with the Sage Report Designer which you may have used to put logo's or extra information on your reports?

You would need to modify the Statement Layout you usually use (In my case this would be STATODA4.layout) And you would need to add to that the two fields you wish to add to the statement for each item displayed. In your case this would be "AUDIT_SPLIT.FOREIGN_NET_AMOUNT" & "AUDIT_SPLIT.FOREIGN_GROSS_AMOUNT" and optionally "AUDIT_SPLIT.FOREIGN_TAX_AMOUNT" However i'm sure that it will still display the full invoice/credit, Net/Gross figures even if you have received a part payment - so it would allways detail the full amounts and you would still need a column for the balance (as it currently displays) to allow for this.

This does come a little unstuck.

If you receive a payment on account or a partial payment of an item, then how do you apportion the payment?

If you allocate the payment leaving part of an item outstanding, you are going to have to calculate the VAT element of the items in order to work out the nett.

This is not small job. I have done this for someone a long time ago and it was not easy.