Sage 100

V2015 Std - client accidentally set up AR customer as a national account and invoices appear in the national account customer in AR. Client just figured out that this was a mistake and wants to move the open invoices back to the customer's AR account (not the national one). Is this possible? TIA

Could you change all of the records in ALL of the Invoice tables with correct Customer Number?

$0 cash receipt twice? Sent from my cell phone. Please forgive any misspellings.

Somehow @MichelleTaylor, I don't like the way you say ""ALL

Well @JeffSchwenk there's just several and you don't want to miss any, but it can be done.

I recently had to do manual data edit for a client who mistakenly merged a handful of customers (...oops!), so I have a handy list of transaction tables I had to edit with customer number updates. (Your list may be bigger than mine): AR_SalesTax, AR_InvoiceHistoryHeader, AR_OpenInvoice, AR_OpenInvoiceTaxSummary, AR_TransactionPaymentHistory, AR_CashReceiptsHistory, IM_ItemTransactionHistory, RA_CustomerInvoiceSearch, SO / history tables... and any summary tables based on sales data.