It is possible to update the Container Item quantities in bulk using the Edit in Excel option that is available from the Details section of the "Landed Cost Container Detail" screen, as shown below. This is useful for a scenario where you may get information from the Shipping Agent or Carrier, from a Mates Receipt or Bill of Lading, that states that the Items loaded into a Container and being transported to you are not as you originally expected in relation to the Purchase Order document.
The Excel file contains the Item lines assigned to the current Container, within any filters set on the Filters FastTab of the screen.
When you open the Excel file you will be able to update the following highlighted columns in order to update the Container Quantities and also to confirm what behaviour should apply to each Item.
| Landed Cost Container Qty. | The quantity of the Item that is actually in the Container. This can only be reduced, not increased above the Purchase Line Quantity. |
| Landed Cost Container Qty. Update Behaviour | The behaviour to apply when the new quantity is processed. Set this to Reduce to reduce the Purchase Line Quantity, or Move to move the balance to a new line. Lines left blank are not processed. |
| Exclude from Fixed Cost | Specifies whether the line is excluded from container fixed cost apportionment. |
The Landed Cost Container Qty. Update Behaviour attribute allows you to control whether you wish to simply reduce the Purchase Item Line to the specified Landed Cost Container Qty. or whether you wish to move the balance (the difference between the current Purchase Item Line Quantity and the specified Landed Cost Container Qty.) to a new Purchase Order Line at the end of the Purchase Order that will not be linked to the current Container, as detailed here.
Once you have updated the Items that you wish to update you must press the Publish option that is shown in the Microsoft Excel Spreadsheet. This will write the information back into Business Central (an example of which is highlighted below) and you will then need to action the updates from the "Landed Cost Container Detail" screen, using the Validate Landed Cost Container Qty. option, available from the menu of the Details section.
The Validate Landed Cost Container Qty. option processes every line in the Details section that has a Landed Cost Container Qty. Update Behaviour set and a quantity still outstanding. Once a line has been processed its Landed Cost Container Qty. Update Behaviour is cleared.
Note: to stop each quantity change from being processed as soon as it is entered, enable Bypass Auto Update Container Qty. Lines on the "Landed Cost Setup" screen. Quantities cannot be updated whilst a "Warehouse Receipt" exists for the Container.