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
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.
Thanks for your response.
Kindly can you help me where can I put these filters in reports for example Inventory Valuation Report?
Go to Inventory valuation report Design Mode
Click on First dataitem i.e Item
Click on DataItemTableview → Click on Table Filter and following
Blocked Filter No
Save the report and check.
I did the following :
Inventory valuation report Design Mode
Clicked on First dataitem i.e Item
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??
You need to press F6 at Table Filter
Blocked under Field
No Under Value
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.