Stock Replenishment Report template

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Thanks Mahesh for the solution, it worked.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Could you verify the solution?

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report
Copy link

Link copied!

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

Item.calcfields(Inventory);

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

currreport.skip;

Was this reply helpful? Yes No