5,080
We recently changed our Inventory accounts and rolled them down through the Item Class...but when we are receieving POs it is still posting to the old account??
GP 2010
Do I need to run check links??
Suggestions on where to look for these old accounts?
Tami
*This post is locked for comments
Hi Tami,
I'm going to have to respectfully disagree with my colleagues and agree with you. While it's never a good idea to change things from the 'back end' if I were in your position I would do it.
I would change the INVINDX field to the account number I wanted.
Kind regards,
Leslie
Once a PO is created, the accounts associated with the item at that point are assigned to the PO. You have several options.
1. Use SQL to change the account indexes in the PO header and line records (NOT recommended unless you know exactly what you are doing)
2. Close/Cancel existing POs and enter new ones. (Not a pleasant thought if you have lots of them)
3. Allow the postings to move forward as is and re-class the amounts through journal entries. This is the easiest plan unless some POs will be open for months or years.
You might consider a hybrid of 2 & 3, closing and recreating any long term POs and working through the short term ones.
BTW, this also occurs with Sales Orders!!
Another thing to consider...when you rolled down the account number changes, no GL entries were created. This means that all the debits to the old Inventory Asset accounts are still sitting in the old account number. However, Credits for new sales will be taken from the new account. Journal entries are needed to reconcile these differences as well.
You need a copy of our Information Flow and Posting. The new version with 80 additional pages ships today. Visit our web site and order a copy (If you purchased one recently, you will be receiving a special upgrade offer in a couple of days)
All open POs have the old account...and when we receive them it is posting to the wrong account. I am talking 200 POs with 1500 lines..........can I not just run a script on the POP10110 PO Line table to change the account?/
Econnect cannot up date??
Tami
Hi Tami,
The receiving account is set on the Purchasing Item Detail Entry window for POs that existed at the time you rolled the account down. If there was no account number on the above window, then the account will pull from the Item. If no inventory account exists for the item, it will pull from the Company Posting account default. If nothing is entered in the company posting account default, then the receiving account will be blank and you'll have to fill it in.
Kind regards,
Leslie
Do you mean existing receiving transactions ?
Hey there Mahmoud, Thanks for the answer....but these accounts are not rolling down to the receivings entry...so all open PO lines have the old accounts??
is there not a way to update that...check links didnt work btw.
Tami
I don't believe you would have a problem with GL Accounts inheritance to the items associated with the class as long as you rolled down the changes made on a class. Accounts associated with an item on the Receiving Transaction Entry are derived mainly from the Item Accounts window and Posting Account Window.
To ensure that these accounts in the classes are rolled down correctly, go a certain class and delete the accounts, then save these changes. One more time, go to the account and fill out the correct account numbers and save. Saving the changes will ensure that GL Accounts are rolled down correctly.
Once the accounts are rolled down, go to a specific item associated with a class you changed and check the Accounts Window as a "Quality Check". Now, you should be able to see these accounts on the Receiving Transaction Entry.
As for the check links, there is no hard at all with doing it. But it may take some time.
Hope this helps,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (