Sage 100

Client had an error SO journal update last week. Thought we had it fixed (finally completed, invoice totals in AR looked OK, etc). HOWEVER, a bunch of the invoices show 0 lines in Invoice History Inquiry. Now if you pull up the last good one in the AR_InvoiceHistoryDetail file, it shows OK, invoice 0339379. Click the next arrow and you should go to 0339380, right? NOOOOOO - the next one shows as 0339333, line 6. But if you then page back a ways you can find 0339333 starting with line 1, and looking fine. Rebuild the file, still the same. Now in the good old days, you could sometimes see on keyed files where the key at the top would not be the same as the value in the field 1 below it, and you could make changes. However, in this file there is no key. I am totally stumped as to what to do.

What's the header sequence? I recall seeing this in a hung update where a user kept hitting ""yes"" to ""retry update"" before calling us. Found multiples of the invoice with difference header sequences.

Header seq is 0 on all. Header file looks fine. The issue is that as you scroll through the Detail file, it jumps back to a prior invoice.

Oh, and here's more - Crystal isn't reading it the same way.

Is the header sequence in the AR_History detail okay?

Yes. I'm working with an MD right now who had a suggestion to add a UDF to the file and let it do it's ""rebuild"" thing - haven't tried it yet, but interesting idea. I'll let you all know if it did anything worthwhile.

OK, so adding a UDF to the file and letting it rebuild actually fixed this screwed up file. Now there are about 20 invoices missing their lines all together, but they were before the rebuild, too. Yay, a new arrow in my quiver...