Posting Accounts

(0) Share

Report

Posted on by Tami Farrelly

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Posting Accounts

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

Was this reply helpful? Yes No
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

RE: Posting Accounts

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)

Was this reply helpful? Yes No
Tami Farrelly 5,080 on at

Like (0)

Report

RE: Posting Accounts

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

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Posting Accounts

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

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Posting Accounts

Do you mean existing receiving transactions ?

Was this reply helpful? Yes No
Tami Farrelly 5,080 on at

Like (0)

Report

RE: Posting Accounts

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

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Posting Accounts

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,

Was this reply helpful? Yes No