"Open" Item Ledger Entries

SmokeScreenSmokeScreen Member Posts: 27
We posted some Negative Adjustments (the whse. mgr. did) and now when Sales is reserving inventory they can reserve against ILE's that should have been closed with the negative adjustment. I have found that the negative adjustment ILE is "Open". So my quantity on hand is correct at 0 however I have 8 ILEs and 1 negative adj for 8. How do I apply the neg. adjustment against the remaining inventory to clear this out and allow for proper reservations?

Comments

  • KowaKowa Member Posts: 925
    There is a "Applies-to Entry" field in the item journal line where you can select a positive item ledger entry which remaining quantity you want to reduce. When the remaining quantity is 0 the item ledger entry is closed.
    Kai Kowalewski
  • SmokeScreenSmokeScreen Member Posts: 27
    Okay. But I have an "open" transfer (positive ledger entry) and a negative adjust "open" both for qty. 10 and -10 resp. full WMS warehouse... reservations are looking at the received transfer and ignoring the negative adjust. So I have 0 actual units, but open ledger entries.

    I suppose my question is how do I close these entries to each other?
  • SavatageSavatage Member Posts: 7,142
    I don't know if this is exactly the correct answer but I guess you COULD...

    make two more entries in the Item Journal for 10 & -10 and this time apply these to the open entries.

    Yes it's two more entries but it will all balance to zero in the end.
    And you can put a little note in the description about why you needed to do this.
Sign In or Register to comment.