Change the value of "Remaining Quantity" and "Open" in Item Ledger Entry

Business Central/NAV Developers Forum
1

Dear All:

System use “Applied-to Item Ledger Entry” field to post a correction Item Ledger Entry. However, which “Item Ledger Entry” can be applied to is decided to the “Remaining Quantitiy” and “Open”.

Evan the item ledger entry is closed, you still can input the “Entry No.” manually (Not use the assist button to select). But it will cause the remaining quantity become negative value and affect the cost calculation.

Now, due to some reason, I want to customize system when user force applied to a Item Ledger Entry which is closed, program will change the “Remaining Quantity” from zero to enough quantity to let the value will not become negative after applied, and will not affect the average cost calculation.

In system principle, the inbound and outboud transcation have relationship in “Item Application Entry” and they should be always matched.

I just want to know, if I do this, what the risk is? (In Cost? or in something?), I had used some simple case to test, it seems correct (After ACIE). But I still worry about maybe it already hide serious question just not be arised yet.

Please give me some advice and suggestion, thanks a lot.

2

I had a pretty hard time understanding your post, but I’ll try to address the issues you raised one by one.

If you apply to a closed Item Ledger Entry, you are trying to exploit a bug and mis-using the application. The results from an application like that woudn’t make sense.

When using “Applies-to” field in general, the cost on the outbound entry is forwarded from teh cost of the inbound entry. When using the “Applies-From” field, the impact on cost depends on your costing method. In an average costing enviroment, the applies-from entries are excluded form the average cost calculation, and instead, use the cost associated with inbound entry.