Skip to main content

Physical Inventory Order Recording Import

Business Value

Physical inventory orders provide a structured process for recording physical inventory counts in Business Central. The standard functionality allows you to export and import the recordings in a fixed format. If you prefer to use a custom template in an Excel format, you can now use Excel Importer to import the recordings.

A possible scenario where this might be useful is when you have a third party managing your inventory in a specific location. If the third party performs a stock count and provides you with a file, you could import this file as a recording.

Feature Details

You can import the recording lines from the inventory recording page. The import can create new lines as well as update existing lines.

note

Physical inventory orders do not allow you to add inventory that has item tracking and requires an expiration date. This specifically relates to scenarios where the lot or serial has never been recorded in Business Central. If this scenario applies to you, you can use the Physical Inventory Journals instead. Physical inventory orders will support adjustments to lots with expiration dates - as long as the lot has previously been posted in Business Central.

Settings

Update Method

This setting aims to allow you to specify your intent so that you do not get unexpected results. For example, if your intention is only to add new recording lines, the import will ensure that the lines in the file do not already exist in Business Central.

Setting ValuePurpose
AddOnly adding new lines. If existing lines are found with the same identifiers, then the import gets cancelled.
UpdateOnly updating existing lines in Business Central. If the line in the file does not exist in Business Central then the import gets cancelled.
Update/AddYou will be adding new lines as well as updating existing prices. You may require this setting if you expect to find inventory for which the was no expected quantity.

Allow Duplicates

The default value for this setting is No. You would not want duplicate lines with the same identifiers in most cases. If you do encounter a scenario where this is required, then you can change this setting to Yes.

Setting ValuePurpose
YesAllow duplicate lines with the same identifiers
NoDo not allow duplicate lines with the same identifiers

Identifiers

The combination of the below fields are used to uniquely identify recording lines.

Field
Item No.
Location Code
Variant Code
Bin Code
Unit of Measure Code

Example Template

Physical Inventory Order Import