Skip to Content
0
Former Member
Apr 19, 2010 at 05:26 AM

Value in JE & Total in document mismatch in Stock Transfer

72 Views

Dear Experts,

We do face the following scenario that is a concern in our day to day business.

Settings: SAP B1 2007B, PL11.

Item Groups Valuation Method: FIFO (All items valued on FIFO)

Manage Item Cost per Warehouse: True (ticked)

Allow Stock Release Without Item Cost: True (ticked)

Serial Numbers / Batches: Not Used

With these settings, when we put an Inventory/Stock Transfer Entry, there is a value displayed in the Info Price column as per the pricelist selected; and the Item Cost field is initially blank.

However once we post the document, the item cost field is updated with value, different from the info price and the journal corresponding to the document has a value which equals Qty * item cost and this is different from the total displayed on the document which equals Qty * Price.

But as this document needs to be submitted to the Sales Tax department, we needs the transaction to posted with the same value as it appears on the document. Also how can we know the item cost before posting the document.

Please Advise.