Sunday, May 15, 2022

Synchronize tracking dimensions on intercompany sales and purchase order lines in Microsoft Dynamics 365 SCM

Feature name: Synchronize tracking dimensions on intercompany sales and purchase order lines

Feature description:
This feature lets you control whether the serial and batch number tracking dimensions are synchronized across intercompany sales and purchase order lines. It adds new settings to both the "Purchase order policies" and "Sales order policies" tabs of the "Intercompany" setup page for customers and vendors. It also updates the names of a few related, nearby settings for clarity. If you are using advanced warehouse management (WMS), then be aware that this feature will only synchronize batch and serial numbers when those dimensions are above location in the target destination reservation hierarchy.


Before this feature was introduced, only tracking dimensions defined on the inventory transactions were synchronized across intercompany chain. There were 2 parameters that controlled that: "Batch number on inventory transactions" on the Purchase order policies and Sales order policies.


With the new feature, you can define tracking dimensions on the purchase order line/sales order line directly and it will be also synchronized across intercompany chain. 

Once you activate this feature, a new parameter "Batch number on order lines" will be displayed:

If Batch number on order lines parameter on the Purchase order policies tab is activated, tracking dimensions defined on the purchase order line will be synchronized to the sales order line. 

If Batch number on order lines parameter on the Sales order policies tab is activated, tracking dimensions defined on the sales order line will be synchronized to the purchase order line. 

That's it!


Tuesday, April 19, 2022

Always copy item description to purchase order purchasing policy parameter in Microsoft Dynamics 365 for Supply Chain Management

In this blog post I would like to provide the comparison table of the behavior with/without Always copy item description to purchase order purchasing policy parameter being enabled for the non-item line. 

Comparison table for the 2 settings that affects Product name and Text fields on the Purchase order page for the category line:

  • Include both name & description (path: Procurement & Sourcing > Setup> Form Setup > General)
  • Always copy item description to purchase order (path: Purchasing policies > Purchase order creation and consolidation rule > Item description transfer tab)

The configuration for the last can be found here:

When you create Purchase order line manually or through the purchase requisition process, there are 2 fields available on the purchase order line, Product name and Text fields. The logic for these fields depends on the Include both name & description parameter and Always copy item description to purchase order. 
In this scenario we are going to review non-item related line and the logic for the Product name and Text fields.

To sum up: For category items, when purchase order is being created from the purchase requisition, Product name and Text get defaulted from the Purchase requisition item description if "Always copy item description to purchase order" parameter is activated. Otherwise, it will take into consideration Include both name & description and behavior for the Product name and Text may vary. 

That's it!

Sunday, April 17, 2022

Intercompany percent functionality in Microsoft Dynamics 365 Supply Chain Management

Purpose: The aim of the Intercompany percent functionality is to address the scenario when the unit price on the IC sales order is used as equal to the cost price, and the vendor does not receive any profit margin. To compensate for the loss of profit margin, the vendor can add a charge to get a percentage of the Net amount from the original sales order line.

Business scenario: 

The Intercompany vendor sells the items to the distribution company by using the cost price as a unit price. Instead of a margin, the vendor adds a miscellaneous charge as a percent of the unit price on the Original sales order.

Example:

The unit price on the Original sales order in DEMF is $300.00 U.S. Dollars (USD). The cost price for the item in USMF is $125.00 USD. Therefore, the sales price on the Intercompany sales order is set equal to the cost $125.00. This sales price is synchronized as the purchase price to the Intercompany purchase order in DEMF.
If a miscellaneous charge on the sales order line of the Intercompany sales order is set to Intercompany percent in the Category field, and the charge value of 10 is set up, 10 percent of the unit price of the Original sales order is added. In this example, this is 10 percent off  $300.00 or $30.00.

Walkthrough: 

Setting Unit price equal to cost price
  • Open USMF > Sales and marketing > Customers > All customers and select an Intercompany customer. 
  • Select General and then Intercompany on the Action Pane. 
  • Select Sales order policies. 
  • Select the Unit price equal to cost price parameter to use the cost price instead of trade agreements or the defined sales price on the item.  
  • If the "Unit price equal to cost price" parameter is selected, you can select the Initiate original customer invoice posting parameter. This means that if the posting of the invoice on the Intercompany sales order is stopped because of an error, the invoice on the Original sales order is posted anyway.

Setting Auto charge for the Intercompany percent
  • Go to USMF > Accounts receivable > Setup > Charges setup > Auto charges.
  • Change Level to Line. Note: Intercompany percent is allowed only on intercompany sales/purchase order lines.
  • Select New and fill in the required fields.

Process:

Go to DEMF > Accounts receivable > Orders > All sales orders
Create a new sales order for DE-010 customer
Create a new line for D0001 item, qty = 3 pcs, unit price = 600 euro
Select New Purchase order on the Action pane > Include > OK.
Go to the DEMF > Purchase order created and make sure that Charges have been added.
Go to the USMF > IC Sales order created and make sure that Charges have been created as well.


Note: I would like to explain what is going on with prices and how they are synchronized to the purchase order. In the presented scenario, for the intercompany customer on the Intercompany setup > Sales order policies configuration, "Price and discount search" parameter was activated. It means that when IC SO is created, the system will try to find the sales price. In this case, a valid sales trade agreement for 330 USD was found, later on this price was synchronized back to the IC PO. Since "Unit price equal to cost price" parameter is also activated, when reservation is done on the IC SO, the actual cost of the item will be identified, and unit price will be updated on the IC SO and then synchronized back to the IC PO. Keep in mind that cost identification cannot happen immediately when IC SO is created, it can happen only when inventory is reserved (manually, on through packing slip posting etc.).

In the IC SO, complete reservation and packing slip posting. Note that unit price is updated by the cost price of the item.
In the IC SO, post invoice. Once posted, check the charges. 

Misc. charge amount calculated as a percent of the Net amount of the original sales order line (in company DEMF). 
The Net amount of the Original order is 1200 EUR. If you calculate it in the currency of the IC SO (USD) it would be 1643.84 USD. You can use Totals page from the Original SO and by changing the currency you can identify the right amount and exact exchange rate. 

So, 5 % of the 1643.84 USD is 82.19 USD.
Now, proceed with IC PO posting process: Confirm, post Product receipt and Invoice the PO. 

That's it!

Monday, April 11, 2022

Prepare Microsoft Dynamics 365 Supply Chain Management environment for the demo

In this post, I would like to go through small tricks that might be useful when you configure your environment for the demo purposes.

To hide the navigation pane that is shown in Supply Chain Management, add the following text to the end of the URL in the browser's address bar: &limitednav=true.

This might be useful when you are working inside of the Teams and you want only to display information, and not let the user navigate out of the page. This will prevent the user for exiting the form.



To open the client as SCM instead of F&O, add the following text to the end of the URL in the browser's address bar: &skuName=d365_scm.


That's it!

Purchase order prices/amount parameter on the Vendor master data in the Microsoft Dynamics 365 Supply Chain Management

There is a parameter "Purchase order prices/amount" on the Vendor master data (Accounts payable > All vendors > Purchase order defaults FastTab). 


This parameter determines whether you would like to print price details on the Purchase order confirmation report. 

The illustration below shows the difference, when this parameter is enabled/disabled.


Note: The field that is initialized when Purchase order confirmation is posted, store in the VENDPURCHORDERJOUR table, AMOUNTPURCHASEORDER field. If AMOUNTPURCHASEORDER = 1, prices will be printed, if AMOUNTPURCHASEORDER = 0, not.

That's it!

Wednesday, March 23, 2022

Solved: Workflow editor is not opening in Microsoft Dynamics 365 Supply Chain Management

Recently I have tried to make an adjustment for the Purchase order workflow in Microsoft Dynamics 365 for Supply Chain Management. When I pressed Edit button, nothing has happened, workflow editor has not showed up. 

To solve this issue, I had to run the following command:

rundll32 dfshim CleanOnlineAppCache

The Contoso personas in Microsoft Dynamics 365 Supply Chain Management

When you are providing a demo for the potential customers in D365 SCM, typically you use Contoso demo data with the existing the Contoso personas. 

In some occasions, you need to create a slide talking about the personas that will be used for the demo, including pictures and their roles. 

In this blogpost, I would like to share the list of the links that I used for the recent demo and I found them useful:

This is the site where you can find the names, pictures and the job descriptions for the Contoso personas:

Microsoft Dynamics Customer Model (d365-design.azurewebsites.net)

Here you can find the list of the Contoso personas available out of the box and the security roles assigned:

How do I login to the new AX as a demo user persona? - Microsoft Dynamics 365 Blog

That's it!