Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Cannot Remove Item From a Controlled Warehouse

Posted on by Microsoft Employee

MARKIT is one of our controlled warehouse locations. This 1 item (FS1EFX0  BKS-L) with a quantity of 1 should not be in this location. We are trying to make an adjustment to remove this item from this location.
Following is the error message we receive.

Adjustment Bin must be No in Bin Location
Code="MARKIT",Code='ADJ-01-RUS'.

*This post is locked for comments

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Cannot Remove Item From a Controlled Warehouse

    Hi,

    Check on "Location" table if your location have "Adjust Bin Code" field compiled (with Bin code), if yes you have fowfields = TRUE on table "Bin"; is not possible to create warehouse entries if this flag is = TRUE.

    Problem is in this check (correct check)

    7311 "Warehouse Journal Line" field 28 "To Bin Code"

    To Bin Code - OnValidate()

    IF NOT PhysInvtEntered THEN

     TESTFIELD("Phys. Inventory",FALSE);

    IF CurrFieldNo = FIELDNO("To Bin Code") THEN

     IF "To Bin Code" <> xRec."To Bin Code" THEN

       CheckBin("Location Code","To Bin Code",TRUE);

    GetBin("Location Code","To Bin Code");

    Bin.CALCFIELDS("Adjustment Bin");

    // ***

    Bin.TESTFIELD("Adjustment Bin",FALSE);  --> this line chek if the flag is FALSE, if TRUE you get the error

    // ***

    IF "To Bin Code" <> '' THEN

     "To Zone Code" := Bin."Zone Code";

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot Remove Item From a Controlled Warehouse

    Hi Roberto,

    Thanks for your quick reply. Cannot quite figure-out how to do this yet ): (I am very new to NAV). If you can provide few additional instruction how to accomplish the task, that would be greatly appreciated.

    Thanks you.

    Oswald

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Cannot Remove Item From a Controlled Warehouse

    hi,

    i think that you have "adjustment bin" flag on table "bin" with TRUE value (on location\bin record); if you have TRUE you can't use bin on warehouse journal.

    Check if you have a correct synchronization between warehouse and Inventory by running the "Calculate Warehouse Adjustment function" from an item journal; you need to set FALSE flag on Bin table to post warehouse entries.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans