on 06-15-2016 3:22 AM
Dear Experts- Does anyone know what table and field the taxable amount is stored for AR invoices? Thanks! Serena
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.