"Item Ledger Entry" - Entries not the same than Item Journal

Alkro

Hi, we have a problem and we can't find the source.

We have an temporary table where users fill in some data about items and quantities. Then, with a process, this lines goes to an Item Journal and Post it. In this Item Journal, we only put "Positive Adjmt." or "Sale".

This process, the idea is, user want to convert an item A to an item B, and the process must do a Sale with A and a Positive Adjt. with B.

Problem is that in any cases, when user complete a line with Item A, and -3 quantity (for example), when they post, in ILE Table, appear 3 entries, for example with:

1 -- Item A - Type: Sale - (-20 Quantity)
2 -- Item B - Type: Purchase - (-17 Quantity)
3 -- Item A - Type: Positive Adjtm. - (3 Quantity)

Strange is 1 & 2 because correct entries must be:

1 -- Item A - Type: Sale - (-3 Quantity)
2 -- Item A - Type: Positive Adjtm. - (3 Quantity)

or

1 -- Item A - Type: Sale - (-3 Quantity)
2 -- Item B - Type: Positive Adjtm. - (3 Quantity)

In C/AL code, we never put an "Purchase" Type.

Anybody knows why could be this "problem"?

BR

Rishi1109

Have you checked in Item Application Entry with the "Outbound Item Entry No." as the Entry No. of Item Ledger Entry created for Sale ?

Rishi1109

Have you checked in Item Application Entry(Table 339) with the "Outbound Item Entry No." as the Entry No. of Item Ledger Entry created for Sale ?

Alkro

Yes is created.