Sage 100

Sage BOI app that has been running fine for YEARS suddenly in the last two days returns "invoice out of balance" error for every invoice.  Sage 100 2020.1 Standard.  AR invoice import still works fine, and I have aided code to verify that the invoice amount and sum of the lines do in fact match.

Any ideas what the real error might be?

Phil

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------

review the activity log and see if anyone changed any AP setup options..

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

@Doug Higgs - good idea but not the solution​

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------

Original Message:
Sent: 12-16-2022 15:22
From: Doug Higgs
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

review the activity log and see if anyone changed any AP setup options..

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Change in source data?  Something like sort order could easily affect things.
...or maybe a GL account is inactive / a line being rejected.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 12-16-2022 15:45
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

@Doug Higgs - good idea but not the solution​

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------


Original Message:
Sent: 12-16-2022 15:22
From: Doug Higgs
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

review the activity log and see if anyone changed any AP setup options..

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

Another thing to watch for are Sage tax calculations (assuming it is a taxable invoice).  We often have to import AP invoice taxes as line data instead of using Tax tables, due to inconsistent rounding. 
You could try to not set the invoice total... and let Sage calculate that automatically, but you might not get an exact match with calculated tax amounts.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 12-16-2022 16:18
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Change in source data?  Something like sort order could easily affect things.
...or maybe a GL account is inactive / a line being rejected.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 12-16-2022 15:45
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

@Doug Higgs - good idea but not the solution​

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.


Original Message:
Sent: 12-16-2022 15:22
From: Doug Higgs
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

review the activity log and see if anyone changed any AP setup options..

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

Source does not appear to have changed (it's XML, so hard to be sure(, and gong through the program line by line in Visual Studio all the values seem correct.
Only one GL account used and it is active.
All invoices set to not taxable.
Commented out the line that sets the invoice total and still get the same error

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------

Original Message:
Sent: 12-16-2022 16:40
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Another thing to watch for are Sage tax calculations (assuming it is a taxable invoice).  We often have to import AP invoice taxes as line data instead of using Tax tables, due to inconsistent rounding.
You could try to not set the invoice total... and let Sage calculate that automatically, but you might not get an exact match with calculated tax amounts.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 12-16-2022 16:18
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Change in source data?  Something like sort order could easily affect things.
...or maybe a GL account is inactive / a line being rejected.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 15:45
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

@Doug Higgs - good idea but not the solution​

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.


Original Message:
Sent: 12-16-2022 15:22
From: Doug Higgs
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

review the activity log and see if anyone changed any AP setup options..

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

Decimal precision issue either in the program or source data?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Original Message:
Sent: 12-16-2022 16:55
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Source does not appear to have changed (it's XML, so hard to be sure(, and gong through the program line by line in Visual Studio all the values seem correct.
Only one GL account used and it is active.
All invoices set to not taxable.
Commented out the line that sets the invoice total and still get the same error

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------


Original Message:
Sent: 12-16-2022 16:40
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Another thing to watch for are Sage tax calculations (assuming it is a taxable invoice).  We often have to import AP invoice taxes as line data instead of using Tax tables, due to inconsistent rounding.
You could try to not set the invoice total... and let Sage calculate that automatically, but you might not get an exact match with calculated tax amounts.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 16:18
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Change in source data?  Something like sort order could easily affect things.
...or maybe a GL account is inactive / a line being rejected.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 15:45
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

@Doug Higgs - good idea but not the solution​

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.


Original Message:
Sent: 12-16-2022 15:22
From: Doug Higgs
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

review the activity log and see if anyone changed any AP setup options..

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

Sequential identical data lines?  I've seen that interpreted as an update vs add (in VI).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 12-16-2022 16:55
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Source does not appear to have changed (it's XML, so hard to be sure(, and gong through the program line by line in Visual Studio all the values seem correct.
Only one GL account used and it is active.
All invoices set to not taxable.
Commented out the line that sets the invoice total and still get the same error

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------


Original Message:
Sent: 12-16-2022 16:40
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Another thing to watch for are Sage tax calculations (assuming it is a taxable invoice).  We often have to import AP invoice taxes as line data instead of using Tax tables, due to inconsistent rounding.
You could try to not set the invoice total... and let Sage calculate that automatically, but you might not get an exact match with calculated tax amounts.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 16:18
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Change in source data?  Something like sort order could easily affect things.
...or maybe a GL account is inactive / a line being rejected.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 15:45
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

@Doug Higgs - good idea but not the solution​

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.


Original Message:
Sent: 12-16-2022 15:22
From: Doug Higgs
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

review the activity log and see if anyone changed any AP setup options..

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

...you've checked the data entry tables for orphaned data?  Does it think you're importing additional lines to invoices that already exist?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 12-16-2022 17:34
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Sequential identical data lines?  I've seen that interpreted as an update vs add (in VI).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 12-16-2022 16:55
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Source does not appear to have changed (it's XML, so hard to be sure(, and gong through the program line by line in Visual Studio all the values seem correct.
Only one GL account used and it is active.
All invoices set to not taxable.
Commented out the line that sets the invoice total and still get the same error

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.


Original Message:
Sent: 12-16-2022 16:40
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Another thing to watch for are Sage tax calculations (assuming it is a taxable invoice).  We often have to import AP invoice taxes as line data instead of using Tax tables, due to inconsistent rounding.
You could try to not set the invoice total... and let Sage calculate that automatically, but you might not get an exact match with calculated tax amounts.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 16:18
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Change in source data?  Something like sort order could easily affect things.
...or maybe a GL account is inactive / a line being rejected.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 15:45
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

@Doug Higgs - good idea but not the solution​

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.


Original Message:
Sent: 12-16-2022 15:22
From: Doug Higgs
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

review the activity log and see if anyone changed any AP setup options..

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

Original Message:
Sent: 12/16/2022 5:39:00 PM
From: Kevin Moyes
Subject: RE: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

...you've checked the data entry tables for orphaned data?  Does it think you're importing additional lines to invoices that already exist?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 12-16-2022 17:34
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Sequential identical data lines?  I've seen that interpreted as an update vs add (in VI).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 12-16-2022 16:55
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Source does not appear to have changed (it's XML, so hard to be sure(, and gong through the program line by line in Visual Studio all the values seem correct.
Only one GL account used and it is active.
All invoices set to not taxable.
Commented out the line that sets the invoice total and still get the same error

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.


Original Message:
Sent: 12-16-2022 16:40
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Another thing to watch for are Sage tax calculations (assuming it is a taxable invoice).  We often have to import AP invoice taxes as line data instead of using Tax tables, due to inconsistent rounding.
You could try to not set the invoice total... and let Sage calculate that automatically, but you might not get an exact match with calculated tax amounts.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 16:18
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Change in source data?  Something like sort order could easily affect things.
...or maybe a GL account is inactive / a line being rejected.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 15:45
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

@Doug Higgs - good idea but not the solution​

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.

Thanks for all the suggestions.  Something (I still don't know what, but can work around it) changed in their xml file that was causing the program to record the line detail twice.  Didn't catch it the first time because I was totaling the lies at the read phase, not the write phase.

This can be moved out of urgent.

Phil

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------

Original Message:
Sent: 12-16-2022 20:05
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

I thought about that and posted all the batches and still got the error.

Original Message:
Sent: 12/16/2022 5:39:00 PM
From: Kevin Moyes
Subject: RE: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

...you've checked the data entry tables for orphaned data?  Does it think you're importing additional lines to invoices that already exist?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 12-16-2022 17:34
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Sequential identical data lines?  I've seen that interpreted as an update vs add (in VI).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 16:55
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Source does not appear to have changed (it's XML, so hard to be sure(, and gong through the program line by line in Visual Studio all the values seem correct.
Only one GL account used and it is active.
All invoices set to not taxable.
Commented out the line that sets the invoice total and still get the same error

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.


Original Message:
Sent: 12-16-2022 16:40
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Another thing to watch for are Sage tax calculations (assuming it is a taxable invoice).  We often have to import AP invoice taxes as line data instead of using Tax tables, due to inconsistent rounding.
You could try to not set the invoice total... and let Sage calculate that automatically, but you might not get an exact match with calculated tax amounts.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 16:18
From: Kevin Moyes
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

Change in source data?  Something like sort order could easily affect things.
...or maybe a GL account is inactive / a line being rejected.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 12-16-2022 15:45
From: Phil McIntosh
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

@Doug Higgs - good idea but not the solution​

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.


Original Message:
Sent: 12-16-2022 15:22
From: Doug Higgs
Subject: BOI app importing AP invoices error "The invoice is out of balance. Do you want to delete the Invoice?"

review the activity log and see if anyone changed any AP setup options..

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles