SBX - Search With Button

SBX - Forum Post Title

How to create a report to show the Item availability by setting location filter on request page ?

Microsoft Dynamics NAV Forum

NAV Techie asked a question on 14 Mar 2019 7:59 AM

Question Status

Suggested Answer

How to create a report to show the Item availability by setting location filter on request page ?

Hi experts i have created a report which will give the details about reorder point, maximum inventory etc. which is available in item master But i just want to run the report based on "LOCATION" filter. Is there any way to get this.

Example: (on req page)

No. : 10000..20000

Location : Red

Reply
NAV Techie responded on 18 Mar 2019 1:58 AM

no reply???????????? :'(

Reply
I Gusti Made Ari Permadi responded on 18 Mar 2019 3:08 AM
My Badges
Suggested Answer

Pulled out "Location Filter" field as ReqFilterFields on  DataItem properties

Item - Onaftergetrecord , add following code

Item.CALCFIELDS("Inventory");

this inventory field is filtered by the location filter which is current stock based on your location filter.

Reply
I Gusti Made Ari Permadi responded on 18 Mar 2019 3:08 AM
My Badges
Suggested Answer

Pulled out "Location Filter" field as ReqFilterFields on  DataItem properties

Item - Onaftergetrecord , add following code

Item.CALCFIELDS("Inventory");

this inventory field is filtered by the location filter which is current stock based on your location filter.

Reply

SBX - Two Col Forum

SBX - Migrated JS