Sage 100

I have a distribution client that posted a batch of about 50 invoices with several hundred inventory lines with a December 2014 posting date. Sage suggests credit memos with the bad transaction date to back everything out and then repost the invoices with the correct transaction date. My first thought is that one should be able to export the necessary data and then import back as both a set of credit memos in December 2014 and again as a set of invoices on the correct posting date. Does this sound like an appropriate approach? Any suggestions or warnings? Has anyone done something like this before? Thanks

had that scenario this morning - but they don't use inventory and they import their invoices daily from another system. So I just opened the import file, switched the signs, imported as negative which created adjustments (but I was going into AR Invoice entry, not SO), posted with the bad date and then reimported with the good date. The idea is the same with SO Invoice entry, just a bit more complicated - if the system will recoginize the same invoice # and customer (like in AR invoice entry) and just create the negative adjustments rather than creating new credit memos that apply to the original invoice that might be easier

I would think it could work. As always try in a test company first........

Worth a try. I'd pull out invoices paid via cc though.

I don't think you can use the same invoice number in SO. You'd have to do a CM. It doesn't correct the date on the original one but it will back everything out of Dec. 2014. Much easier in AR.

Thanks for all the feedback. There were 106 invoices. I have a preliminary export from history running now. Yes on test company always. Fortunately, there were no CC transactions. First import will be credit memos on the bad date. If I manage to make this work and have anything worth sharing, I will post it.

Found that a bunch of the lines were Serial Items which added another layer. The client decided to put a team on it and they reversed and re-entered the invoices manually.