When you are implementing Business Central with Advanced Warehousing, or otherwise trying to load inventory for Business Central with Advanced Warehousing it can be tricky. This can be handled with a Config. Package but it is not very straight forward. I will simplify the process.
- Create a Config Package for Table 7311.
- Change the Field Order using the "Move Up" and "Move Down" buttons (match the placement in the attached Excel example).
- Export to Excel from the Config. Pack to get your template and fill in your data.
- Import from Excel and Apply the Config. package.
- Go to the Warehouse Journal and Post.
- Go to the Item Journal and run the "Calculate Warehouse Adjustment" function and Post.
The issue I run into if you do not change the Field Order is that you cannot do the "Calculate Warehouse Adjustment" in the Item Journal, nothing happens. Changing the Field Order fixes this issue.
Enjoy!
[View:/cfs-file/__key/communityserver-discussions-components-files/758/7311-_2D00_-Config.-Package-Fields.xlsx]
