How to correct wrong date on AR invoice?

Using Sage 100, I entered an invoice as July 6, 2022, but it should have been June 22, 2022, using Invoice Data Entry, and then I applied the case using Cash Receipt Entry.  I entered the cash received on the correct date of June 22, 2022, so now my June end of Month shows Negative AR, as the invoice was paid in June but posted in July.  How do I fix this?

  • 0

    My first advice is to let it go because it will be fine in July.  You could attempt to adjust things around, but I've found that the programmers who created the AR/AP Trial Balance reports assume that the invoice happens first and the payment happens after, and once you have it that way, no amount of adjusting will make a difference.  If this is year end and you HAVE to have it correct, then you can TRY to unpay the invoice on 6/22 and adjust the invoice to 0 on July 7.  Then create a new invoice number (it can be similar - like if the current is 0012345, make this one 12345#, etc) and do everything correctly.