Error Message Creating a Physical Inventory Journal in Microsoft Dynamics 365 Business Central: “Phys. inventory must be equal to ‘Yes’ …”

Microsoft Dynamics 365 Business CentralI helped a client implement Microsoft Dynamics 365 Business Central recently and after training while they were doing UAT, they came to me with an issue when trying to do an adjustment to book stock into the system.

They were just trying to get some stock booked into the system quickly so that they could do some testing of the sales process, so they were trying to do a journal to get the stock in. However, when they entered the item onto the journal they were receiving an error:

Physical Inventory Journal page

Phys inventory must be equal to 'Yes' in Item Journal Line: Journal Template Name=PHYS. INVE. Journal Batch Name=DEFAULT, Line No.=10000. Current value is 'No'.

This error is because they were working in the wrong inventory journal page. They were on the Physical Inventory Journal page which is used by the stock count process and where you do not manually enter the lines, but instead use the Prepare » Calculate Inventory… action to populate the lines.

Instead, they should have been using the Item Journal page which is where you enter any positive and negative adjustments. Once they were directed at the correct page, they were able to get the stock adjustment done and continue testing the sales process.

The “correct” process they should have used, was not doing an adjustment at all, but have someone raise a purchase order and process the receipt for the goods as this is the way that processing would be done post go-live. However, in this instance, they were doing unit testing of a change specific to the despatch of sales orders and the team members from purchasing weren’t available and wanted to avoid delays in testing the sales side.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Leave a Reply

Your email address will not be published. Required fields are marked *