Sage 100

Customer wants me to create a VI export for which I need the SO_InvoiceHeader, SO_InvoiceDetail and SO_InvoiceTracking. they need the tracking numbers on an item line field. I can't seem to get these 3 tables into the tables choices for VI export. Anybody know how to get this done other than using MS Access?

I've done this in Crystal. Then use something like Saberlogic Logicity to schedule the export or create a Task to launch export manually.

Thanks. Would have been so easy to do in VI if possible

Excel query would probably work also. You can set date parameters that would drive the refresh.

When shipping do they identify which package and item is in? in other words, is the PackageTrackingByItem table being populated? A query linking the sales orde to this table would provide the tracking by item.

I had a similar request, but decided to use AR_InvoiceHistoryHeader and AR_InvoiceHistoryTracking instead. Using data entry files becomes problematic if user fails to generate export prior to updating, or generates file then cancels/edits shipment. Ended up creating a Crystal report with parameter to only export that days invoices ({AR_InvoiceHistoryHeader.DateUpdated} = CurrentDate), then scheduled it to run daily.

I think I've done the same as Mark suggests for the reasons that he points out.