cancel
Showing results for 
Search instead for 
Did you mean: 

Taxable Amount

Former Member
0 Kudos

Dear Experts- Does anyone know what table and field the taxable amount is stored for AR invoices?  Thanks!  Serena

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member227598
Active Contributor
0 Kudos

Hi Serena,

For Header Tax Amount Table  & Fields name are in OINV & T0.[VatSumSy], T0.[VatSum]

For Row Level Tax Amount Table  & Feilds name are in INV1 & T1.[VatSumSy]

For your reference please check the below query

.

SELECT T0.[VatSumSy],  T0.[VatSum], T1.[VatSumSy] FROM [dbo].[OINV]  T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.[DocNum] = [%0]

Rgds,

Kamlesh Naware

Former Member
0 Kudos

Thanks so much Kamlesh.  This query gives me the tax total.  What I'm trying to get is the taxable total.  For example, if an invoice has 2 lines, one for $42 and the other line for $5, only the $42 line is taxed.  I'm trying to return the $42 in one field calling it taxable amount and the $47 calling it invoice total.  Also, there are documents that have freight that can be taxable or non taxable and I need to include these amounts in the correct column.

Thanks!

Serena