Amount (LCY) field in Detailed Cust. Ledger Table

jadetunji

How do I exclude VAT from the Amount (LCY) field in both the Cust. Ledger Entry and Detailed Cust. Ledger tables? Need to extract Amount (LCY) Excl VAT using a simple calculation via a reporting tool into MS Excel.
Thanks for your assistance.

David_Cox

If I am right you can not do it from the Customer Ledger, as the customer owes the Gross Amount, you will have to find the VAT amount from the G/L Entries, or the VAT Ledger Entries, by posting date and document number, it is quite a bit of work though and you could have duplicate document numbers and posting date, where someone has posted a journal!