We setup some new Inventory Items and forgot to set the OM Accts. This caused Invoice Entries to post the Misc account. Is there a way to correct the account numbers in AcctHist and ARTrans?
Thanks in advance.
*This post is locked for comments
Announcements
We setup some new Inventory Items and forgot to set the OM Accts. This caused Invoice Entries to post the Misc account. Is there a way to correct the account numbers in AcctHist and ARTrans?
Thanks in advance.
*This post is locked for comments
I would recommend using a third party software called 'KEYCHANGE' by vendor Nexvue to do this. This will change the account numbers for you in ARTRAN, GLTRAN and ACCTHIST tables. It will do the update and merge for you, if you are changing to an account that already exists. I am assuming the subaccounts are correct and only the account needs to be changed. I am also assuming that the Misc account is isolated to these invoice entry postings and not used for any other purpose and the GLTRAN, ARTRAN and ACCTHIST have only these entries and they total up correctly.
Community Member
136
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
REUser
8