Views Reply Votes
Milan Manevski
Milan
 3
Changing effective date on posted invoice
55
4
10
Posted: May 05, 2020   
Votes
Tomaz Ranzinger
Tomaz
 121
Replied 

Every data is possible to change with update. In your case you have to update effective date in tables ar_mstr, tx2d_det, gltr_hist, glt_det and ih_hist. 

10
Replied: May 06, 2020
Votes
Milan Manevski
Milan
 3
Replied 

Thank you very much Tomaz!

00
Replied: May 06, 2020
Votes
Phill Norrey
Phill
 1348
Replied 

Although what Tomaz says is technically correct, I would advise against it.  You are altering stored data without any form of audit, and remember that this now means that the data in the system no longer matches the data printed on the invoice.  What happens if you change it to a dtae prior to the goods being shipped?  You are just opening yourself up to auditing.  My first question would be why do you want to make the change?

10
Replied: May 06, 2020
Votes
Milan Manevski
Milan
 3
Replied 

Phill thank you very much for your reply. I tottaly understand your concern.

The thing is Invoice post has been done 3 days after Invoice print, so Invoice number took part in Invoice number sequence at Invoice print date, but effective date for that Inovice number is Invoice post date.

But we will keep it like this.

Thanks

00
Replied: May 07, 2020
Forums
All
Forum Help
Help Using Forums