Modifying Bin Mandatory setup on existing location

aquawater
aquawater Member Posts: 71
Hi experts,

Please help us..
Due to wrong configuration on a warehouse location, our item is not tied to any Bin.
And it was due to Bin Mandatory is set to NO in Location Card.

But we already post the opening stock for this location.
Hence when I changed the setup to YES, it will prompt me this error.
You cannot change Bin Mandatory because there are one or more open ledger entries on this location.

Please advice what should we do?
1. Could we negate the item ledger entries and re-post the entries ? How do I cancel/negate the entries ?

Thank you in advance for the help. [-o<

Answers

  • ara3n
    ara3n Member Posts: 9,258
    Do a Negative adjustment on item journal for total quantity available, and then enable bin on location card, and then do Positive adjustment with bin code. Make sure you put the same cost for positive adjustment
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • aquawater
    aquawater Member Posts: 71
    Thanks, ara3n!!
    It works. :thumbsup:
  • ara3n
    ara3n Member Posts: 9,258
    You are welcome. Please change the first post to solved
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n