Epilogue - #EggOnFace...Sometimes looking for the solution the techie way ma not the best. I finally threw in the towel and had client call Sage. Turns out there was a KB (51522) for this exact issue. I still feel the corrupt record/field was hidden somewhere (sort file) and not in the InvoiceHeader table as it would appear.
Client happy, I am puzzled, time to move on!!!
------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------
Original Message:
Sent: 11-17-2021 13:40
From: Randy Marion
Subject: AR Sales Journal update - Sage 100 v2020
How about the Division table?
--
Randy Marion * Software Systems Engineer *
Original Message:
Sent: 11/17/2021 1:38:00 PM
From: Jeff Schwenk
Subject: RE: AR Sales Journal update - Sage 100 v2020
@Doug Higgs - I did export each table to Excel. Everything looked copacetic. Could something be hidden by the Excel query?.
------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------
Original Message:
Sent: 11-17-2021 13:29
From: Doug Higgs
Subject: AR Sales Journal update - Sage 100 v2020
or a quick Crystal report with invoice#, division, and customer#. See if all of the fields are populated correctly.
------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
Original Message:
Sent: 11-17-2021 13:27
From: Jeff Schwenk
Subject: AR Sales Journal update - Sage 100 v2020
Not a solution I want to pursue at this point. Way to many invoices entered manually at this point. I might have to create a VI if it comes to that. Dare I say time to punt to Sage for resolution???
------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
Original Message:
Sent: 11-17-2021 13:05
From: Randy Marion
Subject: AR Sales Journal update - Sage 100 v2020
I hate these kind of problems ... I would suggest, 1) backup your data, 2) then delete the invoices one by one and see when the problem goes away (maybe copy everything to demo company?) Once you identify the culprit, then you can plan your next steps .... Obviously, if you have a ton of invoices in the tables, this loses its attractiveness....
--
Randy Marion * Software Systems Engineer *
Original Message:
Sent: 11/17/2021 12:59:00 PM
From: Jeff Schwenk
Subject: RE: AR Sales Journal update - Sage 100 v2020
Good thought but zippo.
------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
Original Message:
Sent: 11-17-2021 12:49
From: Kevin Moyes
Subject: AR Sales Journal update - Sage 100 v2020
Anything in AR_InvoiceRestart?
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 11-17-2021 12:45
From: Jeff Schwenk
Subject: AR Sales Journal update - Sage 100 v2020
That was my first thought, but didn't see it. Looked via DFDM and dumped header table to Excel. Nothing glaring. No blank records. Compared the customer # in the header to the customer table (via a vlookup formula). All matched
------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
Original Message:
Sent: 11-17-2021 12:30
From: Beth Bowers
Subject: AR Sales Journal update - Sage 100 v2020
No Header with a blank customer?
------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Tennessee Software Solutions
269-445-1625