VAT entry

I have built a report that looks at the spend per Vendor for a period and I'm pretty happy with the way it works.
I take the Invoice or Credit memo no from the Vendor Ledger Entry Table and the posting date and amount.

However the amount is the amount including VAT and I would like to split this out between Base amount and VAT amount. I know that the VAT entry table holds this data but when I browse my database this table is not visible or available to me. Anyone know why? or is there another way of splitting out the amount to see the VAT amount?

Running Jet Essentials 2012 R2 on Dynamics NAV 2009


Please sign in to leave a comment.