GL Account Missing when Posting Up GRPO

[Former Member]

The scenario happen like this:

1) Customer creating a PO with 3 items.

2) One of the item that my client created needed to change warehouse, so they make an amendment through clicking into the Item master data, and change the warehouse from WSE 01 to HQ.

3) Then in the PO, they deleted the item line, added new row and selected the same item code again, update.

4) Then they copy the PO to GRPO.

5) Then they have the procedure to update the serial number for the machine.

6) After that, when they want to post the GRPO, it has an error message showing: G/L Account is missing [Goods Receipt PO - Rows - Warehouse Code][line:3] [Message 131-46]

Any idea on this issue?

[Former Member]

Hi Michal,

I think you have not update the G/L for warehouse HQ. However you are maintaing G/L setting as per warehouse wise.

Regards,

Datta Kharat

[Former Member]

Yes, its per warehouse wise, and i notice the client GL setting is empty in the negative inventory adjustment acct. So i will advise client to add an GL account here, then try to post the GRPO again. Update you all again once the client reply. Thanks.

[Former Member]

Hi Michael,

Before you give suggestions to the clients, please search the forum for Negative Inventories as there are many threads discussing this and only then provide any solutions.You can also check the online help under the article 'G/L Account Determination: Inventory Tab'. There are various aspects related to the financials, so discuss the same with the accounts department as well.

Thanks,

Joseph

[Former Member]

Noted, and sorry to update you all, the G/L method set by Item Group.

[Former Member]

Hi Michael,

Is your inventory negative?? Are the required accounts mapped in GL determination? Are you using any freight in the document? If yes, please check the freight set up to see if the accounts are defined .

Thanks,

Joseph

Edited by: Joseph Antony on Apr 20, 2010 12:03 PM

[Former Member]

Yes, the Warehouse 01 do have a -1 available item.

[Former Member]

Hi Michael,

Please check the accounts mapped item group that you have assigned to the item. If only the negative inventory accounts is missing, then you have to map it.

Thanks,

Joseph

[Former Member]

That's a total of 5 accounts not mapped:

1)Negative Inventory Adjustment Account

2)Purchase Returns Account

3)Goods Clearing Account

4)Expense Clearing Account

5)Expense Offset Account

Regards,

Michael Chen

[Former Member]

Hi Michael,

Are you using any freight in the document? If yes, you need to map the expense clearing accounts. Else, map the negative inventory account in test db and see if you could add the document.

Thanks,

Joseph

[Former Member]

Problems solved, thanks. client didn't input the inventory account in the warehouse accounting section.

[Former Member]

Hi Micheal.......

You need to set all the mandatory settings required for the transaction documents.

You need to set the GL account determination. You need to set the Warehouse account GL

You need to set the Item Group account GL.

You need to set the Freight accounts.

You need to set the tax accounts.

You need to set the landed cost account......... Etc........

Regards,

Rahul

[Former Member]

Hi!

Is that happening only when you delete and add a new item ?

Have you mapped Allocation Acc, Inventory Acc, Freight Acc ? based on the GL Method

[Former Member]

Hi Michael,

What is your GL method set by?

Please check the GL Determination and make sure that all the accounts required are mapped.

Thanks,

Joseph