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

Parents

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

Reply

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

Children

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

Sage 100

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

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING