Stock Replenishment Report template

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I am designing a Stock Replenishment in Nav 2013 using SQL Server 2012 Report Builder. I want to write a code, for if the Inventory Qty. for an Item is less than the Minimum Stock Qty. the record line is to be displayed, else the record line show not be displayed.

Please help.

*This post is locked for comments

All responses (4)

Answers (1)

Suggested answer

keoma 32,675 on at

Like (0)

Report

RE: Stock Replenishment Report template

write in the code - trigger Item-OnAfterGetRecord - following:

Item.calcfields(Inventory);

if Item.Inventory >= Item."Minimum Stock Qty." then

currreport.skip;
mmv 11,465 on at

Like (0)

Report

RE: Stock Replenishment Report template

Hi,

Could you verify the solution?
Community Member Microsoft Employee on at

Like (1)

Report

RE: Stock Replenishment Report template

Thanks Mahesh for the solution, it worked.
Verified answer

mmv 11,465 on at

Like (0)

Report

RE: Stock Replenishment Report template

Hi,

On the report Layout, for that line, in the Properties -> Visibility, you may write the expression Fields!InventoryQty.Value >= Fields!MinimumStockQty.Value

In the above InventoryQty and MinimumStockQty are the values defined in the DataItem