Change AR invoice due date

[Former Member]

I have a transaction that a user accidentally posted with a doc date and due date of 2007. I don't care about the docdate so much, but I need to update the due date to be 2009. What table(s) and fields do I need to update in sql to do this? I need my aging to put this doc into the right aging bucket.

[Former Member · Accepted solution]

If you try to update table directly, you are risking to loose SAP support. That is clear mentioned in the support scope. Why not cancel the wrong invoice and post a correct one?

Thanks,

Gordon

[Former Member · Accepted solution]

The customer just paid off the invoice, but in order to print an accurate historical aging and tie out for the Aug month end I need the due date to be changed. I don't like changing data in the db either, but I don't see a way to do this in the front end now that its paid off and bank rec is done.

[Former Member · Accepted solution]

Even if you could change the tables directly, there is no way that you could keep database consistency. That is much more valuable for a report. You have to find a way from front end. It is not true that no way to do it from front. The invoice can be canceled and reconciliation can by restored.

[Former Member · Accepted solution]

That's what I thought, but was hoping it might be a quick fix in a single table. Thanks G.