Wrong GL posting item by warehouse

[Former Member]

I have a few invoices that posted incorrectly to the GL throughout the month.

We have the selection in Company details set to manage item cost by warehouse.

This setting did not change throughout the month.

I have 1 invoice that 1/2 the items posted correctly, 1/2 did not.

I have another invoice that all the sales dollars posted correctly but the cost from the delivery ticket did not.

We have 1 segment in the GL accounts for warehouse.

I have found 6 invoice/delivery postings to be incorrect out of about 150 transactions. I cannot find a common issue.

Any suggestions on how I might track the problem?

As always, your help is greatly appreciated.

[Former Member · Accepted solution]

Hi!

1. Have u booked GRPO before A/P invoice ?

2. Is there any Price Difference between GRPO unitprice and A/P invoice ?

3. Did the Tax Amount is 100% Non-Deductable ?

4. What is the Additional Acc involved in the Invoice Transaction. - Check this with your appropriate Warehouse/ItemGroup

5. is that a Price Difference Account ?

Check it for all 6 invoices .

[Former Member · Accepted solution]

1. yes, GRPO booked before AP

2. no price difference

3. no tax involved

4. additional account. In all inv groups; the sales accout is 41000-10-10-000; all cost 51000-10-10-000

In all warehouse except one we call "DROP" the sales and cost accts are the same as groups.

In the warehouse we call "DROP" (not flagged as a drop warehouse) the accounts are 41000-10-30-000 / 51000-10-30-000

where it should be -30 it is remaining -10.

5. it is not the price difference account. in both group & warehouse the price differece account is 54000-00-00-000

Thank you for your assistance. I'll keep looking for a commonality.

[Former Member · Accepted solution]

Hi!

Check the G/L Account by for the Particular item which posted to 10 instead 30.

[zal_parchem2 · Accepted solution]

Hello again Kathy...

Maybe another try:

1. Are you talking AR Sales Invoices only or AP Invoices only or a mixture thereof?

2. You say you have the COMPANY settings set to Manage Items by Warehouse. But do you also have the "Set GL Accounts" set at "Warehouse" on the Inventory Data Tab found on the Item Masters Data Window?

3. Is it only in the DROP warehouse where these differences are appearing?

4. Did you check the GL accounts for the particular item and item groups? (that was my initial suggestion above).

5. You can also see exactly what accounts are being used for an item by changing the "Set GL Accounts" on the Item Master Data Window to "Item Level" (or "Item Group" or "Warehouse") and then displaying the exact accounts you are talking about by using the Form Settings Icon. You can then see the GL Accounts associated with each warehouse at the ITEM level. Have you tried that?

There has got to be a reason for these to occur; SAP B1 is too tight and the system does not do a haphazard selection of a GL Account (there are too many levels invoived in GL assignment for transactions).

Good luck and let us know what you find - Zal

[zal_parchem2]

hello Kathy - hmmm - this sounds like maybe the items might have a different GL number?

Small Tip - You can use the Form Settings on the Item Master Data Window and then add the fields of "Inventory Account" and others to see if the GL accounts display differently than what you have in the Item Group and Warehouse GL settings...

Just an idea - hope it helps...

Zal