I have some items in a open state, would like to know what does this mean? And what I have to do to remove state?
appreciate an answer in Spanish, thank you very much
*This post is locked for comments
Hello Mar Silva Tejeda,
I apologize for responding in English and not in Spanish, but I am located in the U.S. and am not a bi-lingual communicator. As Mohana states, the Item Ledger Entries (ILE) are Open if the Remaining Quantity is not zero, which implies that further applications will be created in the Item Application Entries (Table 339) related to the Item Quantity on the Open ILE.
The clarification I wanted to make is that if the Quantity on the ILE is showing Remaining Quantity of Positive Quantity (Inbound Entries in Table 339), for example it is an ILE for Purchase or Positive Adjustment, then this is just a "layer" of inventory that is available to be applied against. When Sales, negative Adjustments (otherwise known as Outbound Entries in Table 339) are posted, the system will apply the ILE quantity against these open positive (Inbound) entries based on Costing Method.
If the entry that is Open with Remaining Quantity is showing Negative Quantity, then this is an indication that the Item has been posted into negative inventory status. If that is the case, then a Positive Adjustment or Purchase would need to be posted for the Open Outbound Entry to be applied against the entry.
I wanted to add one point that causes confusion. Many examples I have seen with this area is that a company user accidentally posts a large Shipment Quantity resulting in Negative Quantity on the Item by mistake. They then process the Undo Shipment to reverse the quantity posting. The result of the entry is that both ILE will show as Open with Remaining Quantity of equal quantity. The question is then - why didn't the system apply and close the entries as offset against each other?
The reason is that the Undo Shipment is linked to the original Shipment for Costing purposes..The Undo Shipment Positive Quantity will be adjusted to match the same cost as the original shipment Negative Quantity is adjusted to when the Adjust Cost Item Entries process is run. Because of this "Exact Cost Reversing", the system cannot apply the Shipment Negative to the linked/related Undo Quantity Positive. Otherwise, the interdependency of cost could result in Adjust Cost Item Entries looping. So, the system is designed to leave both entries open.
To correct this data, a user would have to post a Positive Adjustment with the correct Unit Cost and then post a Negative Adjustment for equal quantity so that the two open related Shipment and Undo Shipment ILE can be correctly applied and closed.
I hope this provides some additional information and detail.
Best Regards
Tom
This field shows whether the entry has been fully applied to.
A check mark in the field means that the entry has not yet been fully applied to. If this is the case, you can see the quantity that must still be applied to in the Remaining Quantity field.
The field can be updated by a subsequent application.
The status field is in Item Ledger Entry
"Open State"? Do you mean active and you want to deactivate them?
If so Check the "Blocked" check box on the item card
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (