Item Ledger Entry not created on Shipping a Sales Order

davoness

I have a client who have begun experiencing a problem when Shipping/Invoicing sales orders. They are running v3.10A C/SIDE. We have not modified the sales line table, or sales posting.

In the last month they have noticed a problem with Sales figures from their Item Ledger not matching the G/L. I have tracked the discrepancies down to a number of Invoices for Items where there have been not any Item Ledger Entries or Value Entries created.

On the posted shipments/invoices the Quantity field is filled in correctly, but the Quantity (Base) field is set to zero. The only common theme I can find with the invoices is that they are part shipments/invoices (ie. some lines/qty from the order is posted on one Shipment/Invoice, then the rest later).

I have tried everything I can think of to replicate but I cannot make it happen in their test system. As there are no mods I'm sure its a standard Navision problem, but the version is no longer supported.

Has anyone come across this problem and know what causes it or know of a hotfix for it?

Thanks
Dave

Alex_Chow

Is the Automatic Cost Posting turned on?
Does the sales orders have items on them?

davoness

Yes there are Items on the Orders.
Yes automatic cost posting is switched on, however even if this was off it would still be a problem as the Item Ledger Entry should be created by posting the Shipment regardless.

ara3n

looks like a customization.
Turn on codecoverage and see if it's CU 22 and see where it exists.

I usually filter on //

and see where customization occurred.

davoness

Just to add a little more information, I have tracked the problem to the updating of the Qty. To Ship (Base) and Qty. To Invoice (Base) after posting.

I have found an order where the problem has occurred once and the situation is:

The order has 4 lines, all for Items all Qty 1, the UOM on all lines is the Item's base UOM.
Qty To Ship and Qty to Invoice were set to 1 on the first two lines and zero the second two lines and it posted correctly.
The 3rd line was then posted by setting Qty To Ship & Qty To Invoice to 1 and posting. This failed to create an ILE. The Quantity (Base) field on both the Invoice and Shipment are 0, even thought the Quantity field is 1.
The order is still in the system. The 4th line has Quantity of 1, Qty. To Ship of 1, Qty to Invoice of 1 but Qty. To Ship (Base) of 0 & Qty. To Invoice (Base) of 0.

The problem must be in setting the Qty To Ship & Invoice fields back to the Quantity when a line has not been shipped is not updating the Base fields for some reason.

Dave

davoness

This client has nearly zero customisations, only a field or two added here and there. Codeunits 22 and 80 have not been touched, nor have tables 36 & 37

ara3n

I suggest to check knowledgebase, and suggest to upgrade.

Alex_Chow

davoness wrote:

This client has nearly zero customisations, only a field or two added here and there. Codeunits 22 and 80 have not been touched, nor have tables 36 & 37

Have you tried to duplicate the problem on a standard 3.10A Cronus database? If you are not able to duplicate the problem, then it's a problem with customization.