Physical Inventory Order Recording Import
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.
You can import the recording lines from the inventory recording page. The import can create new lines as well as update existing lines.
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.
|Add||Only adding new lines. If existing lines are found with the same identifiers, then the import gets cancelled.|
|Update||Only updating existing lines in Business Central. If the line in the file does not exist in Business Central then the import gets cancelled.|
|Update/Add||You 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.|
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.
|Yes||Allow duplicate lines with the same identifiers|
|No||Do not allow duplicate lines with the same identifiers|
The combination of the below fields are used to uniquely identify recording lines.
|Unit of Measure Code|