Sage 100

I have a client with about 750 Balance Forward Customers that need to be converted to Open Item. Does anyone have a good method to do this? There are 4 files involved and three require key changes. The only solution I see currently is to export all 4 files, edit in excel, reinitialize the files and import. Does this seem reasonable? Does anyone know of a utility?

I wish there was a utility! I had a client where we did this and it was a real headache. I'm not sure which 4 files you are referring to but as I remember, we had a problem with the invoice type in AR Open Invoice. Regular invoices are type IN and balance forward are BF and so we had to change that field. We also had issues applying payments to invoices because the client uses Retail Pro and all payments transfer into Sage as credit memos.

It would be nice. The four files mentioned in Sage's instructions are AR_Customer, AR_OpenInvoice, AR_TransactionPaymentHistory and AR_AlternateInvoice. After modification for all 4 for each customer you are changing, they ask that you also Rebuild Application Support files. There are documents on the KBs that outline the details. The one attached is an older one that covers both 4.05 back and 4.1 forward. They ran all the steps together so i highlighted the file names to help me separate the tasks. I hope to try the export/edit in Excel/import routine when I get a chance.

@JohnBroadfoot Another thought would be to close your period so that all invoices are combined into one balance forward total. then do a cash receipts import to pay them all. Next, VI the BF flag to open in the customer master. The final step is another VI import in AR (or SO) invoices entry to set the amounts up in AR again. Be careful in all of this to not have any GL impact. A little laborious but by using the data entry files for the VI, you avoid weird things that occur when importing directly to the tables.