Sage 100

Has anyone run into a situation where you are merging AP vendors and those vendors both happen to have invoice with the same invoice number. While this sounds odd I can think of at least one instance where it could happen such as when a customer users the date for certain invoices from vendors that don't already have a number.

Here's the email a customer just sent me and I'm wondering if anyone has ever tested: 

Greetings Wayne,

 

In Sage100, we are working on cleaning up our duplicate vendors by merging them together using the Modules>Account Payable>Utilities>Delete and Change Vendors program.

 

I was curious, is it possible to merge two vendors that have the same exact Invoice Number posted to their accounts or would this cause problems?

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

Wayne - I thought this was interesting, so I tried it... Sage 100 Advanced 2016 - duplicate open invoices are merged as well and become a single invoice with a balance the sum of the duplicates...  Looks a little weird in Transactions, but seems correct ...

------------------------------
Randy Marion
------------------------------

Thanks, Randy. I guess that makes sense. I'm not sure if the vendor would understand what happened but I guess you have to pick a way to deal with these duplications.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

Original Message:
Sent: 10-08-2019 11:15
From: Randy Marion
Subject: Merge two AP Vendors when both have the same AP open invoice number

Wayne - I thought this was interesting, so I tried it... Sage 100 Advanced 2016 - duplicate open invoices are merged as well and become a single invoice with a balance the sum of the duplicates...  Looks a little weird in Transactions, but seems correct ...

------------------------------
Randy Marion
------------------------------

Wayne - After thinking about it, I think merging of like invoices is probably the best of a lot of bad options ... at least data is not lost and at worst the duplicates are doubled and will need to be adjusted.

------------------------------
Randy Marion
------------------------------

Original Message:
Sent: 10-09-2019 08:57
From: Wayne Schulz
Subject: Merge two AP Vendors when both have the same AP open invoice number

Thanks, Randy. I guess that makes sense. I'm not sure if the vendor would understand what happened but I guess you have to pick a way to deal with these duplications.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------


Original Message:
Sent: 10-08-2019 11:15
From: Randy Marion
Subject: Merge two AP Vendors when both have the same AP open invoice number

Wayne - I thought this was interesting, so I tried it... Sage 100 Advanced 2016 - duplicate open invoices are merged as well and become a single invoice with a balance the sum of the duplicates...  Looks a little weird in Transactions, but seems correct ...

------------------------------
Randy Marion