web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) How to create a report...

Microsoft Dynamics NAV (Archived)

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

(0) Share

Report

Report

Posted on by KaryaNavTech

239

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

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

KaryaNavTech 239 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

I Gusti Made Ari 3,600 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
KC1 5 on at

Like (0)

Report

Sorry but could you simplify this please.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans