Answered

Items Page Filter

(0) Share

Report

Posted on by Jarod

Hi. I have a question. Is it possible to add a field to the Items List from another table?. For instance: I am retrieving the stock from the column "Remaining Quantity" (Item Ledger Entry ) and I want to be able to add a field or fields for each location I have ( I just have 5 locations ) and being able to filter by these fields. Is it possible?. I have searched but I can't find a way to do it. Thanks in advance.

Categories:

Inventory and warehouse management

Development / Customization / SDK

All responses (5)

Answers (1)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Items Page Filter

Jarod,

You can ask your Partner to add the fields to the Page, with a filtering ability. You could also consider a Jet Report to do the same thing, via Excel, real time.

Hope this helps.

Thanks,

Steve
Jarod 10 on at

Like (0)

Report

RE: Items Page Filter

Thanks for the reply. I have come up with something like this. Having the available items display for each location. I'm geting this info from the Item Ledger Entry. I am using the location filter and it works fine, however I would like by the time I click on the stock, I want it to take me to the stock by location of that specific item, like when you click in the item available by location. I have try table relation but I don't know which table those values are stored. Thanks a lot for your help.
Verified answer

YUN ZHU 69,510 Super User 2024 Season 2 on at

Like (0)

Report

RE: Items Page Filter

Hi, I think you can try Location Filter in Limit totals.

Or try Items by Location in Item list.

Hope this helps.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 32,744 Moderator on at

Like (0)

Report

RE: Items Page Filter

If you want to see the qty. on hand for 5 different location you can customize a lookup function that lets you display the qty for each location when you execute the lookup function.

Adding a field for each location is also possible but can have a performance impact because the inventory will be calculated every time you pull up the item list.

The advantage of the lookup is that the code behind it will only be executed when requested.
Suggested answer

Nitin Verma 21,023 Moderator on at

Like (0)

Report

RE: Items Page Filter

Hi Jord,

You can use the "Location filter" field by providing the desire location code on Item list page, it will give the total inventory of that particular location.

Thanks.