Predicted Costs
The Predicted Cost here is the estimated amount associated with each charge (item) that is used for a particular consignment. The Predicted Cost is represented in the local currency within the Advance Landed Cost extension in Business Central. The Predicted cost is calculated when the Consignment document is created based on the Consignment Template used. In this extension, this feature can be used in the Purchase Orders and for Transfer Orders.
The following are the facts about the Predicted Cost in the Advance Landed Cost extension.
In the Consignment document, you may refer to the following Costs in the header.
Total Cost (Items) Specifies the costs related to the Purchased items in the consignment, using the expected cost amount if the expected cost posting is turned on for received items and the actual cost for invoiced items.
Total Costs (Charge Item) Specifies the total costs related to Item charges in the consignment, using the expected cost amount if the expected cost posting is turned on for received items and the actual cost for invoiced items.
Consignment Lines – Per Consignments
In this tab, the following fields need to be considered. In this scenario, the Predicted amounts are calculated based on the Per Consignment Template.
Total Template Amount: This is a total value derived for a Charge Item line relevant to all corresponding Line-Item in the Purchase Order / Transfer Order. The calculation is based on the Unit Cost and the Assignment Method used in the Consignment Template.
Total Predicted Amount: This is the total value of the Predicted Landed Cost Amount for all the Item lines in the Purchase Order / Transfer Order. This can be the same as that of the Total template amount. It may differ if you edit the Unit Cost (LCY) in the Charge Item Line.
Consignment Lines – Per Item
In this scenario, the Predicted amounts are calculated based on the Particular Items / Category of Items.
Total Template Amount: This value is derived for a Charge Item line from the corresponding Line-Item Quantity in the Purchase Order / Transfer Order. The calculation is based on the Unit Cost and the Assignment Method used in the Consignment Template.
Total Predicted Amount( LCY): This value is the Predicted Landed Cost Amount for a Charge Item line from the corresponding item quantity in the Purchase Order / Transfer Order. This can be the same as that of the Total template amount. It may differ if you edit the Unit Cost (LCY) in the Charge Item Line.
Value Entries
The Value entries page in the Consignment provide the detailed Item Cost lines, related to the specific consignment. The Value entry lines can be explained as follows.
Purchase Receipt Lines: Identified by Item Ledger Entry Type Purchase and Document Type Purchase Receipt. The number of lines depends on the number of line items received. This can be the cost amount Expected or Cost Amount Actual based on the Direct Cost of the items received.
Transfer Receipt Lines: Identified by Item Ledger Entry Type Transfer and Document Type Transfer Receipt. The number of lines depends on the number of line items received at the Transfer To Location.
Charge Item Lines Predicted Cost: The lines are identified by Item Ledger Entry Type Purchase and Document Type Blank. The number of lines depends on the number of line items received and many Item Charges. These lines represent the Predicted landed cost. The amount can be debit and credit. When the actual landed costs are posted through the Vendor invoices, the Charge Item Lines Predicted Cost lines are reversed.
Charge Item Lines Actual Cost: The lines are identified by Item Ledger Entry Type Purchase and Document Type Purchase Invoice. The number of lines depends on the number of line items received and many Item Charges. These lines represent the actual landed cost. These lines are posted when the actual landed costs are posted through the Vendor invoices.