Hi, 1.In the item ledger/Value entry I find there is a difference between Adjusted cost and Cost Posted to GL. Even after running batch jobs Adj cost item entries and cost posted to GL. 2.As a result when we run the inventory valuation report for the item it shows a negative value in the cost posted to G/L. 3.In certain other cases items are reflecting with adjusted cost as 0 but cost posted gl as a negative value. Can anyone help me on this regard… Tks in advance Ramanan
Have You invoiced all purchases? Inventory value is based on invoicing, so if You invoice You customers and do not post You purchase invoices You’ll end up with a negative value
Yes I have posted the purchase invoices but how come this kind or difference appear. Posting Date| Item Ledger |Entry Type |Entry Type |Document No. |Amount |Valued Quantity| Adjusted Cost| Cost Posted to G/L 7/8/2002| Purchase| Direct Cost| PRINV-020005| 7,394.04| 1,500 | 7,394.04 | ??? | 7/22/2002| Sale| Direct Cost| INV-020236| |-62,837.85| -13,560 |-66,842.12| -85,566.57 first is the a purchase invoice where cost posted to gl is nil and insecond case the sales posted invoice where adj cost is diff from cost posted to G/L
For the first line, If you do a Purchase Invoice and have Automatic Cost Posting off (Inv. Setup), then no costs will be posted until you run the Inventory periodic activity to Post the Costs. It seems that if you do the same thing on a Purchase Order, it will post the Costs regardless of the flag. For the second part, the Adj. Cost is set by the Adjust Cost inventory periodic activity and the Cost Posted to G/L is set by the Post Costs to G/L periodic activity. Running this activity should Post the difference and hence the fields will be equal again. It looks like both lines can be fixed by running the Post Cost activity. You may still have a negative value posted to inventory if the remaining 12,010 from the sale are not applied to another Item Ledger Entry. Chris.