Microsoft Dynamics 365 Landed Cost – Part 1

Spread the love

Landed cost concepts and terminologies:

Concepts

Voyage:

Voyage involves a distinct movement from an outbound location to the final inbound warehouse location through a series of specific destinations over a set period of time. After a voyage has been created, you can add purchase orders and order lines to a single container or multiple containers, and then the associated costs will be accurately allocated to the item line.

Cost

After it’s been created, a voyage can automatically have costs added to it. Various cost options and cost bases are available in the Landed cost module. You can define each cost for different levels of a voyage and then assign them to an item level by using assigned rules that support quantity, volume, weight, amount, and defined volumetric divisors. These estimated costs help to accurately represent the total cost of a voyage.

Then, landed cost will do a preliminary posting/accrual of the estimated landed costs to ensure that an accurate cost calculation is provided at the time of voyage creation. When these automatic expenses are billed, the predicted costs will be reversed and replaced with the actual costs, as determined by cost invoices.

Actual costs are estimated costs that are reversed and reported at the time of cost invoicing using clearing accounts that are designated for each type of cost (for example, duty, freight, and insurance). These postings follow the posting behaviour that is connected with the item, and they update inventory postings automatically. All posting types for inventory model groups are supported. Purchase price variance accounts are used to record the discrepancies between estimated and actual costs for moving average and standard cost postings.

 

 

Landed cost terminologies

Key concepts for Landed cost are as follows:

 

 

 

Landed cost parameters

Navigation: Landed cost > Setup > Landed cost parameters

The first section in the landed cost parameters page is the General tab, which contains the following Fast Tabs:

General

General

Below is the screenshot of General tab. After this screenshot we will understand the concepts of each setting:

Let’s understand the settings from above screenshot:

Use shipping rate: Determines which default shipping rate that you want to use for your voyages. Most companies have a predetermined shipping rate that’s used for a specific period to estimate the cost of items that are priced in multiple currencies.

Exchange rate type: Determines which exchange rate is used in multicurrency calculations for a voyage and their associated costs. 

Click on view details and go to the Exchange rate to see the currency exchange rate for this legal entity:

Here you can see that exchange rate type is “Average”:

Update purchase order quantity: Determines what happens when a user attempts to change the quantity on a purchase order line that is part of a voyage. Below are the options: 

Automatically update number of cartons – Determines how the cartons on a voyage are displayed.

If this toggle is set to Yes, all cartons will be combined and displayed at the voyage and container level.

If this toggle is set to No, the number of cartons is initially set to 0 (zero) and will require that a user manually adjusts them as needed.

 

Costing

Below is the screenshot of Costing tab. After this screenshot we will understand the concepts of each setting:

Posting specification – Determines how the value adjustment will appear in the ledger. Use the dropdown menu to select one of the following options:

 

Use purchase order invoice – Determines if you want to use the same number as the purchase order invoice for cost accrual transactions.

Allow zero costs – Determines if you want to allow zero costs to be part of the voyage.

 

Adjustment posting date – When you post a voyage cost invoice to accounts payable, the settlements table (inventory adjustments) is updated as well. The adjustment posting date determines which default date will appear on the Select voyage costs page in the invoice journal:

Transaction date – The posting or journal date.

Purchase order invoice date – The financial posting date of the item (purchase order) invoice.

Selected date – The user specifies the posting date. If the Selected date field is clear, the user will receive an error message when posting the cost invoice.

 

Block manual posting to clearing account – Determines which transactions are posted to clearing accounts.

Use cost type charge accrual account – Determines if the charge accrual account will be used to accrue costs as an expense.

Post adjustments as variance – Determines how the variances between estimated costs and actual costs are handled.

Validation

All the fields are self explanatory and there are 3 options available in each dropdown for selection:

 

Default

In default fast tab, there is a selection of journal types for each journal. These are self explanatory:

 



Related posts

Microsoft Dynamics 365 Retail & Commerce -Loyalty Programs Setup

by Mahmood Ul Hassan admin
3 months ago

Introducing Copilot for Microsoft Dynamics 365 Finance and Operations

by Mahmood Ul Hassan admin
3 months ago

Microsoft Dynamics 365 Landed Cost – Part 3

by Mahmood Ul Hassan admin
5 months ago
Exit mobile version