Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Using Visual integrator to export invoices, the tax amount field is always empty.

Posted By talbs781 over 5 years ago

I am not sure why when I run the VI export job, the tax amount from SO_InvoiceDetail appears to be 0 in the exported result file. All other values are being exported correctly. I have also check ed manually in the sales orders and invoices that the tax amount is there.

I appreciate any help or suggestions!

Top Replies

BigLouie over 5 years ago +1

The information is in two other tables. SO_InvoiceTaxSummary and SO_InvoiceTaxDetail

0 BigLouie over 5 years ago

The information is in two other tables. SO_InvoiceTaxSummary and SO_InvoiceTaxDetail
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 talbs781 over 5 years ago in reply to BigLouie

Those tables are not accessible from the export job. The main table I am using is SO_InvoiceDetail and I am using some fields from SO_InvoiceHeader as well, but do not see those tables. Do I need to use one of those tables as the primary table to export from? Thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Alnoor over 5 years ago

It sounds like you are choosing TaxAmt field from SO_InvoiceDetail group. I'm guessing that's not the field you want anyway. If you go back to Configuration tab and choose Display Read Only Fields for Export then click back on Data tab, on the Available Fields if you go down the the SO_InvoiceHeader group and expand it, within there if you just keep pressing S you will find SalesTaxAmt. I'm guessing this is what you want. Hope that helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Using Visual integrator to export invoices, the tax amount field is always empty.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING