Stock Posting does not tally with Journal Entry

[Former Member]

Hi Mentors,

I currently trying to see the cause of a particular issue with the JE being created by Stock Posting.

After scavenging the forums, I came across SAP Note 1525960.

Symptom
On creating Inventory Posting in locked Posting Period, system gives error message 'Period is
locked for new data [Message 131-107]'. Keep the window open, go to Posting Periods to
change the Period Status to 'Unlocked', and then click on 'Reconcile' again. Inventory Posting
is successfully added.
The Transaction Value in the Inventory Audit Report is correct. However the Debit / Credit
amounts in the Journal Entry of Inventory Posting are doubled.

The note was created in 2010, filed under SAP Business One 2007. I tried to replicate it, and it holds true for our system, which is currently 2004B.

When I tried to explain the SAP note to our accountant, she said that she did not encounter the error message, since she was the one controlling the period.

So my question is, if there any other factors that could influence the change in the posting of the JE such that the variance being posted in the JE is more than the actual amount(as verified against "Inventory Posting List" and OINM)?

Some facts about our Finance department's practices.

They enter the "Stock Posting" a month later.

E.G. Stock Posting for Oct2011 Stock Variance

System Date: Nov 16, 2011

Stock Posting - Posting Date: Oct 31, 2011

Thanks in advance!

Sean

[Former Member]

Hi Sean,

You may also check Negative Inventory Adjustment to find where come out of the variances.

Thanks,

Gordon

[Former Member]

Hi Sir Gordon,

I've checked for the "Negative Inventory Adj. Acct" in the GL Account determination.

I think 2004B does not have this.

Also, I've checked our "Document Settings", we have the "Block Below Negative Quantity" checked.

Thanks for you guidance,

Sean

[Former Member]

Even if you selected "Block Below Negative Quantity", system may still need that account. Check all data field in OINM to see if your have the fields related to Negative Inventory account.

[Former Member]

Hi Sir Gordon,

I already checked using your suggested query:

SELECT * from oinm
 WHERE NegInvAdjs != 0

found in this [thread|].

Unfortunately, 2004B does not have the column "NegInvAdjs". The query failed to execute.

Thank you for the guidance,

Sean

[Former Member]

Hi Sean,

What document date is been registered while posting the stock posting ?

BR

Samir Gandhi

[Former Member]

Hi Samir,

The DocDate in the database is Oct 31, 2011. Which is the Stock Posting "Posting Date".

Thanks,

Sean

[Former Member]

Hi,

Post a Message to SAP Support center