Inventory costs and not created G/L entries ?

mdPartnerNL

My customer noticed that after posting some corrections in the inventory journals no GL Entries were created for the Costs.

I checked in the inventory settings and noticed:
- Expected Cost Posting to G/L = OFF

I switched it to ON and confirmed updating the entries.


If I do some corrections in the inventory journal, GL entries are created too. So it seams ok but all earlier value entries are not updated (when it was OFF). The field "Expected Cost Posted to G/L" in the value entries are still zero and no GL entries are created. Anyone know what to do next?

bbrown

Switching that field to ON should have triggered a process that inserted records into table 5811 "Post Value Entry to G/L". Now run Report 1002 "Post Inventory Cost to G/L" to post them to GL.

golfer

Switching ON the Expected Cost Posting means you are now posting to G/L also when receiving/shipping on Interim Inventory Accounts, not only when invoicing the transactions. Or did you perhaps mean you switch ON the Automatic Cost Posting?

mdPartnerNL

bbrown wrote:

Switching that field to ON should have triggered a process that inserted records into table 5811 "Post Value Entry to G/L". Now run Report 1002 "Post Inventory Cost to G/L" to post them to GL.

Yes, just did this but no GL entries are created. Really strange. So if I navigate to the Item register (Physical inventory) and navigate on a document no. I see:
- Item Ledger Entry, 8
- Value Entry, 8
- Phys. Inventory Ledger Entry, 18

but no "G/L Entry" ??

Im helping out this customer because the previous partner stopped but how to fix this..

bbrown

Did you run the "Post Inventory Cost to G/L" report?

mdPartnerNL

Just found the problem by comparing codeunit 22 to a original database.

It was an upgrade problem.


IF ValueEntry.Inventoriable THEN
PostInventoryToGL(ValueEntry); ValueEntry.INSERT;

UpdateAdjmtProp(ValueEntry,ItemLedgEntry."Posting Date");

InsertItemReg(0,0,ValueEntry."Entry No.",0);
InsertPostValueEntryToGL(ValueEntry);
IF Item."Item Tracking Code" <> '' THEN BEGIN
TempValueEntryRelation.INIT;
TempValueEntryRelation."Value Entry No." := ValueEntry."Entry No.";
TempValueEntryRelation.INSERT;
END;

Some old customized code prevented the red part from running.

Those missing GL entries must be created by doing:

PostInventoryToGL(ValueEntry);
InsertPostValueEntryToGL(ValueEntry);

Alex_Chow

Glad you found the error. Was going to chime in to say that expected cost posting checkbox does not apply to your problem.