Sage 100

Customer recently started using National Acct Bill To's in AR. has been working for about two months now. They want to pull sales data for the past six months now via Bill to. So I am trying to populate AR History header with the Bill to information. My VI import fails with the error message below. Can any one decipher it? I am importing Invoice #, sequence #, assigning a division number and importing the bill to code. Thoughts?

How are you tracking Customer Sales History in AR Setup, by Bill To or Sold To? Sounds like the primary key is Sold to, hence the error. Also, not sure why you're importing into AR Invoice History, which should already have that info if feature was enabled.

We started populating the bill to fields about two months ago. I thought it would be a slam dunk to go back to the beginning of the year filling in the blanks so that you could run a history report based on one selection parameter instead of keying in 30 customer numbers.

Sounds like you're configured to track sales by Sold To, so your import would need the Sold To customer info in addition to Bill To. Invoice # by itself is insufficient to identify record, as same invoice # can be used with different customer codes.

So you are saying if I add the sold to number to the import, my chances of success are much higher?

Yes.

The key to the Invoice History file is strictly the Invoice and the HeaderSeq, so if the Sold To helps, it's not because it helped identify the record. I was able to do an import in 2016 using just the invoice number, hard-coding the HeaderSeq, and importing in the Bill To. I didn't even have the link setup for one of my lines and it still worked.

Actually, haven't had to circle back for the response but adding the customer number to the import did not help. Will try hard coding the HeaderSeq next.

Error: ""The Child data source is not on file"" when importing BIllToDivison and BilltoCustomer into AR_InvoiceHistoryHeader Products Sage 100 Description Error: ""The Child data source is not on file"" when importing BIllToDivison and BilltoCustomer into AR_InvoiceHistoryHeader via Visual Integrator for Sage 100 Resolution This issue was resolved in the following Sage 100 versions: Sage 2015 Product Update 5 Sage 2016 Product Update 2 See related Articles below to download the appropriate Product Update Related resources Download Sage 100 2015 Product Update 5 Download Sage 100 2016.3 Download Sage 100 2016 Product Update 2 Category Data and database Import, export Entitlement Open Defect ID 105676 for Sage 100 2016 105627 for Sage 100 2015

Thanks @MarkKotyla - Will take a look at what v2015 PU they are on.