Sage 100

Supposedly there is a bug fix for a Customer Renumber issue. As you see below, it says it's in Product Update 2 for 2014. WHERE IN THE *EXPLETIVE DELETED* is Product Update 2???????? All I can find is product update 1. And this fix below is dated 4/22, so it's not like they just put it out. Delete and Change Customers changes the customer number for most invoices within AR Invoice History Inquiry instead of just the customer selected during the utility Disclaimer Backup Warning Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage Business Partner, network administrator, or Sage Customer Support Analyst. Resolved with the following updates: Product Update 2 for Sage 100 ERP 2014 (5.10.2.0) Product Update 5 for Sage 100 ERP 2013 (5.00.5.0)

I may be mistaken, but I thought that bug was fixed in 2013 PU 5 and 2014 PU 1. I don't think 2014 PU 2 has been published yet. You should be able to verify this by using Sage Advisor and ""check for updates

Looks like it is still broken to me, and another Customer Renumber issue that was supposed to be fixed doesn't appear to be, either.

What a surprise.

I had a similar question about PU2 having seen it mentioned in an article or two. At the time someone mentioned using Sage Advisor to pull it down. I tried that and have only been able to get PU 1. I'm not sure what the delay is on Sage's part. I guess all that planning for the technical content for Summit maybe.

@BethBowers, @JohnBroadfoot, others, how did you end up resolving this? Simply restore from backup? Since a full day of work has passed for my client, I'm considering using VI to fix the Customer #'s in A/R Invoice History, but I'm a little hesitant because I'm unsure of anything else that may have been negatively impacted.

I did not actually have this error - mine was that it only changed the customer numbers of ACTIVE orders in the Sales Order History file. I just happened to see this fix while looking for help on my error.

We have decided to restore, which luckily we can use a copy the client happened to have made inside Sage 100 yesterday evening prior to renumbering, so they only have to rebuild one day and not two. And although the Invoice History file has all these wrong Customer #'s for 80k invoices, the invoices contain the correct Customer Name, so I was considering performing an Excel VLOOKUP against the customer file to obtain the correct customer #'s. However, we determined that a good amount of the 11,600 customers have the exact same customer name so therefore we'd have to manually address lots of invoices to determine the proper Customer #'s. Plus there's also the possibility that it's not just Invoice History that's negatively impacted.

Another option would be to use the invoice history in the backup company the customer made last night to export the the invoice number and customer number. Then, use Vi to change the customer number in the damaged invoice history header. Damage could still be elsewhere.