WMS: Warehouse item setup not showing picking location

(0) Share

Report

Posted on by user5555

7,437

Hi,

We have WMS I and we want to activate locations so that we do have to keep a separate Excel where the items are in located in stock. We do not have pallets, no fork lifts, etc and also no bulk locations. Actually the simplest way would to connect the item to a picking location. I think next very simple situation would already be sufficient for us:

Adding a field to the table InventTable.wMSPickingLocation which would look up the picking location. But I guess the next table InventItemLocation is ment for this purpose and thus preferred over coding an own solution (if present in WMS I since WMS II is out of scope); InventItemLocation.wMSPickingLocation, InventItemLocation.WMSLocationIdDefaultIssue = "", InventItemLocation.WMSLocationIdDefaultReceipt = "";
InventItemLocation.inventDimId = "AllBlank";
InventItemLocation.useWMSOrder = InventInventLocationNoYes::InventLocation;
InventItemLocation.pickingLocationRefillMin = 0.00;
InventItemLocation.PickingLocationMaxQty = 0.00;
InventItemLocation.useEmptyPalletLocation = InventInventLocationNo::InventLocation;
Adding the wMSPickingLocation to the packing slips of AR and PO would allow us to collect and store the items.

Our partner did not set up InventItemLocation so all items are now to an item dimension group not having the location. I created a new dimension group with an active location, but the wmslocationid does not show up as it should according to code:

void setWMSLocationIdEnabled(InventDimGroupId inventDimGroupId)
{
    NoYes                   locationActive;
    InventDimSearch         dimSearch = inventDimFormSetup.dimSearch();
    ;
    dimSearch.find(inventDimGroupId, fieldnum(InventDim, wmsLocationId));
    locationActive = dimSearch.dimActive();

if (!inventDim.InventLocationId)
locationActive = false;

    inventItemLocation_ds.object(fieldnum(InventItemLocation, wmsPickingLocation)).allowEdit(locationActive);
    inventItemLocation_ds.object(fieldnum(InventItemLocation, wmsLocationIdDefaultIssue)).allowEdit(locationActive);
    inventItemLocation_ds.object(fieldnum(InventItemLocation, wmsLocationIdDefaultReceipt)).allowEdit(locationActive);

}

What do I need to get the warehouse item setup to work? And is this simple warehouse solution possible with AX?

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Community Member on at

Like (0)

Report

Hi, you have to have an AllBlank record along with however many locations you want to assign to that item. I would recommend using standard import for this.

Was this reply helpful? Yes No
user5555 7,437 on at

Like (0)

Report

[quote user="Bob Bobby"]
Hi, you have to have an AllBlank record along with however many locations you want to assign to that item. I would recommend using standard import for this.

[/quote]

Hi Bobby,

I do not fully understand what you mean. How do I add such record for customizing? Or do you mean coding a 1:N relationship since an item could be in more than 1 place?

J.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Check I/M > Setup > Warehouse Breakdown > Locations
If you have entries in that table, then you can either manually assign the locations to each item or you can import inventItemLocation table.
I believe this is what you are asking???

Was this reply helpful? Yes No
user5555 7,437 on at

Like (0)

Report

Hi Bobby,

I have inventitemlocation and I have locations. However, the form does not allow me to specify the picking location. So the field WMSPickingLocation is empty. I would expect that I could select a location there so that item and location are married by using the GUI (not through import file since I see that as a workaround, opening the form would put WMSPickinglocation = empty by accident).

Then I can put that field on my packing slip reports and purchase order reports so that I have a simple warehouse location functionality without having the hassle of transferring orders etc. Just unpack the box, count the items, post the packing slip (PS), print the PS, attach the original packing slip behind and then move the items to the WMSPickinglocation based on the printed packing slip. Same for order picking: no picking list, just modify the packing slip by adding the WMSPickinglocation on it and then print it, collect the items at the locations on the printed packing slip, then check them, pack them and attach the (automatic) printed label on top of it..ready.

Since WMS I has no consolidated picking (multiple oders on one document) and no optimal route for collection of items, printing the picking list is a bit of a waste: nothing more than the packing slip actually.

However, if WMSPickinglocation can be set up through Items --> Set up --> Warehouse items --> WMSPickinglocation (now disabled due to InventLocationId = empty on dimension) then I do not have to modify the AX code that hard. Just generating the warehouse setup and then adding some fields to some forms and reports.

So basically, how to enable the WMSPickinglocation field. It is controlled through WMS I and in my dev with all configutations it also does not work. I am missing something. I guess something to the dimension group setup?

J.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Have you tried using the location wizard via IM > Setup > Warehouses form > Functions button?
Its a round about way of setting these up and assigning locations to warehouses.

Was this reply helpful? Yes No
user5555 7,437 on at

Like (0)

Report

Hi,

Yes I did and I then assumed that one of these locations could be selected as the WMSPickingLocationId on Warehouse Item. Table WMSLocation is filled and based on the extended datatypes and underlying datamodel I would say that some foreign key relationship is present here. But no way how to activate the GUI for selecting a WMSLocation.

J.

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

When you open the Warehouse items form, you need to create a new row there (a default row with all inventory dimensions empty already exists there). On the new row, you need to specify a warehouse. Once you do that, you will be able to select a picking location for the item+warehouse combination (That's what the form is for).

Was this reply helpful? Yes No
user5555 7,437 on at

Like (0)

Report

Hi,

Thank you for your reply.

1. I cannot select a picking location for the first row. Did not get the picture this should be a row;

2. If I add a row for a size which is possible, then I am still not able to select a picking location after saving the record.

3. Second and third record are also negative.

J.

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

The logic for enabling the Picking Location on that form is very simple. The warehouse needs to be specified The WMS location dimension should be active on the dimension group of the item. Did you specify a warehouse on these rows? Are you certain that the item's dimension group has the location dimension set as Active? Are you certain that the security/configuration is setup correctly, so that you actually have access to this field?

Was this reply helpful? Yes No
user5555 7,437 on at

Like (0)

Report
All positive:

The warehouse needs to be specified The WMS location dimension should be active on the dimension group of the item.

Did you specify a warehouse on these rows?

Are you certain that the item's dimension group has the location dimension set as Active?

Not sure. I have the feeling I have access to everything.

Are you certain that the security/configuration is setup correctly, so that you actually have access to this field?

I say this situation is also positive since if I change code like this, the field does show up, which means somewhere else in code I get the correct credentials to access this field:

void setWMSLocationIdEnabled(InventDimGroupId inventDimGroupId)
{
    NoYes                   locationActive;
    InventDimSearch         dimSearch = inventDimFormSetup.dimSearch();
    ;
    dimSearch.find(inventDimGroupId, fieldnum(InventDim, wmsLocationId));
    locationActive = dimSearch.dimActive();

    if (!inventDim.InventLocationId)
        locationActive = true;//false;

    inventItemLocation_ds.object(fieldnum(InventItemLocation, wmsPickingLocation)).allowEdit(locationActive);
    inventItemLocation_ds.object(fieldnum(InventItemLocation, wmsLocationIdDefaultIssue)).allowEdit(locationActive);
    inventItemLocation_ds.object(fieldnum(InventItemLocation, wmsLocationIdDefaultReceipt)).allowEdit(locationActive);

}

Then the field can be edited. Like my problem with SalesPackingSlip form I would say my Dynamics AX installation is completely rubish and there is something very weird in relationship to the InventDim Setup.

Next fields are returning empty:

    dimSearch.find(inventDimGroupId, fieldnum(InventDim, wmsLocationId));
    locationActive = dimSearch.dimActive();

    if (!inventDim.InventLocationId)
        locationActive = false;

I look like for some reason the datasource is not filled with inventDim records. Is there a check I can do to see if this setup is correct?

J.

Was this reply helpful? Yes No

Community site session details

WMS: Warehouse item setup not showing picking location

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

WMS: Warehouse item setup not showing picking location

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates