Form Personalization to update Cancelled Inv date

[nass_kp]

Has any one done FORM PERSONALIZATION to update the Cancelled Invoice distribution line accounting date.

Whenever we cancel an invoice it defaults the accounting date for those reversed lines to system date and we can't update those dates.

Sometimes due to this invoices are trf to previous period whereas the cancelled invoices are trf to next period.

If anyone has done form personalization to solve this issue, please HELP.......??

[hiszaki]

Hi nass_kp

You can update the cancel date via database by open help menu then choose diagnostic then examine the field & change the value but this solution is not standard but it's work & we had use it in out organization.

Be inform that you must do this with DBA & don't use it for each cancel transaction.

Hope I can help you
Hisham Zaki

[nass_kp]

Yes first I successfully did that. But that doesn't update the date in the accounting table and headers table and so if we look at the VIEW ACCOUNTING - it still shows the old system date.