(Goods Issue) Document Totals Do Not Tally With Journal Entry Totals

[Former Member]

Version: SAP 8.8 PL 20

The document total of some Goods Issue documents do not tally with the totals in the Journal Entry. This does not happen in the previous version. After we upgraded, we found some goods issue documents having this behavior. Is this a bug? Or is this a setting in the configurations?

[Former Member · Accepted solution]

Hi there,

I've made some testing and found these:

a) In the Goods issuance window:

Total (column) = Price List (drop down list) X Quantity (column)

b) In the Journal entry window:

Quantity (column) X Item cost (you can see this in the inventory tab of the item master data)

Probably the Total (column) is for presentation. The system only post only the cost reflected in the item master data.

Edited by: Sappho on Apr 5, 2011 4:18 PM

[Former Member · Accepted solution]

If this is the case, how can I set the pricelist for my inventory items to COST instead of other pricelists?

[Former Member · Accepted solution]

You cannot set to cost, the closest is last evaluated, as long as you are following processes to keep this up to date.

The inventory values from movements (all documents) are stored in s separate table - OINM for 2007, but this may be different for 8.8. This is where the stock audit reports are generated from.

To match the GL with the subsidiary ledger, you need to run the stock audit report by posting date.

[Former Member · Accepted solution]

The drop down list for price list selection is for simulation/ presentation of the value of goods under the selected price list. In goods issuance, the system creates journal entry on the cost computed based on the inventory valuation method. You can find it in the item master data if that item is not fast moving. Note that the system continuously updates the item cost especially when valuation chosen is weighted average. Hope this explains.

-Sappho

[Former Member]

Hi,

The 'Total' column in the Goods Issue shows the information price based on the Price List you select. It has nothing to do with the actual posting value, which is actually based on the Item Cost.

I hope this helps.

Regards,

Nat

[Former Member]

Does this mean that you cannot match the OIGE.DocTotal to the JDT1.Debit-Credit Values? How would the SL tally with your GL if this will be the case?

[Former Member]

Yes, those two are not necessarily the same. As I mentioned before, the 'Total' column represents an info price only. However I don't understand what you mean by 'SL tally with your GL', as the Goods Issue document is not a sales document, therefore would not be part of the Sales Ledger.

[Former Member]

What I meant with SL is the Subsidiary Ledger and GL as the General Ledger. In the Goods Issue transaction, we normally issue out goods at COST. We don't even fill out the Business Partner info. The info in the document should tie up with entries; otherwise, you'll have imbalanced figures and tracing would be very difficult. We don't have this discrepancies while we were still in SAP 2005 version.

Yes, I got your point that totals in the document do not tally with the Journal Entries; but the question is WHY? Why do we have to integrate the journal entries if the amounts would not tie up? From all other systems I've encountered, document totals should somehow tally with the Journal Entries.

Like for instance, sales, if your sales document do not tally with your entries; how are you going to reconcile the difference?