Block Items and Visibility in Stock in Hand Report

Business Central/NAV User Forum
1

Hi

I am using Ms Dynamics Nav 2209 R2 with LS Retial. It has been observed that my item card has items with wrong costing method setup and has transactions relating to it.

I am thinking to do negative adjustments to my current stock in the item card and block the item and then create new item card with correct costing method ( FIFO to AVERAGE Costing).

I want to know how can I avoid the blocked stock not to appear in the stock in hand report and also the same not to apprear in my LS Retail POS.

In anticipation of help. Thanks in advance

2

I don’t know which dataitem you are using for report but if you are using Item Table You need to set filter for blocked item .It will take care in both classic as well as RTC report.

3

Hi Amol

Thanks for your response.

Kindly can you help me where can I put these filters in reports for example Inventory Valuation Report?

Thanks

4

Go to Inventory valuation report Design Mode

Click on First dataitem i.e Item

Press Shift+F4

Click on DataItemTableview → Click on Table Filter and following

Blocked Filter No

Press OK

Save the report and check.

5

Hi Amol

I did the following :

Inventory valuation report Design Mode

Clicked on First dataitem i.e Item

Pressed Shift+F4

Click on DataItemTableview → Click on Table Filter but at this level I am confused the Table Filter area is blank should I fill in anything??

Thanks

6

You need to press F6 at Table Filter

then add

Blocked under Field

No Under Value

Press Ok

Save

7

Hi Sujith,

Did you ever find a solution to your problem? If you did, would you mind sharing it with us and if any of the posted answers helped you on the way, then please verify them.

Thank you.