Delivery schedules Functionalities in Dynamics 365 for sales, purchase and Quotations

Delivery schedules allow you to track order line quantity when you are using multiple deliveries for a single sales order, sales quotation, or purchase order.

Use a delivery schedule when the total quantity on an order or quotation line must be delivered in multiple shipments. Individual shipments are represented by delivery lines. Two or more delivery lines make up one delivery schedule. The delivery lines can have different delivery dates, quantities, modes of delivery, and storage dimensions, such as site and warehouse.

Total order (original order line)	600
Requested delivery schedule	100 per Month
Requested time frame for delivery	6 month, on the first day of each month

For Example: 

Create a new sales order

In this scenario, the customer requests delivery of 600 in batches of 100 over a period of six weeks.To keep track of the delivery requirements, you create a delivery schedule. 

On the delivery schedule page, you create six separate delivery lines. Each delivery line contains 100 and indicates the delivery date for those 100. In this case, each line is offset on the first of the week for six consecutive weeks.

When you create a delivery schedule, the type of the original order line is automatically changed to Order line with multiple deliveries. A line of this type is referred to as a commercial line and is marked by an icon. The delivery line is marked by a different icon. If you change a quantity on a delivery line, the commercial line is updated to the total quantity of the delivery schedule. If a trade agreement has defined a total discount for the order, the delivery schedule ensures that your order is eligible for the total order discount, even when the order is split into separate deliveries.

Orders that have a delivery schedule are processed against the delivery lines. Processing includes the posting of packing slips, product receipts, and invoicing.

Document printouts of orders and quotations that have a delivery schedule show only the delivery lines. They don’t show the original lines (commercial lines).

Happy DAXing

Tarak

Consignment inventory functionality in dynamics 365

Consignment stock is often used in Lean manufacturing implementations, With the addition of the “owner” inventory tracking dimension, Consignment inventory can now be set up and tracked from requirement to receipt, then on to use and finally payment.  Only inventory quantities and transactions are tracked in Dynamics 365; no financial impact is recorded to general ledger until ownership is transferred.  Consignment is now an activity on the Procurement and Sourcing Area Page where Replenishment Orders and Inventory Ownership can be managed.

So, let’s walk through this new functionality, and note that this is only available for Dynamics 365 for Operations – it’s not available for Dynamics AX 2012.

  

Inventory owners. Inventory management > Setup > Inventory owners:

Here, we are setting up a link between our vendor and the Owner inventory dimension, and defining the default dimension which represents our own inventory.

Tracking dimension group. Product and information management > Setup > Dimension and variant groups > Tracking dimension group:

We’ve created a new Dimension group with the ‘Owner’ dimension active – in the current version you can’t enable batch or serial tracking (well you can on this form, but you get an error when you try to create an item with this Tracking dimension group).

Inventory ownership change journal. Inventory management > Setup > Journal names > Inventory:

Apart from the new Journal type, and of course we can define a default Ownership change journal name:

Next I’m creating a new Consignment stock warehouse. This isn’t strictly part of the process, but it’s the way I’ve seen this process being managed in practice. Inventory management > Setup > Inventory breakdown > Warehouses:

Note. Don’t be tempted to use the warehouse Vendor account on your Consignment warehouse. That field is related to the sub-contract production process (where you want to deliver to your sub-contract vendor), so it defaults the warehouse delivery address. In this context, you’d have products going around in circles.

Now we can setup a new item, and assign that Tracking dimension group. Note that only standard cost, and moving average inventory cost models are supported:

I’ve chosen Standard cost, so I’ll activate the standard cost for my released product.

Now we’re ready to create a Consignment replenishment order. Procurement and sourcing > Consignment > Consignment replenishment orders:

Create a new Consignment order, Click new, give proper vendor, site & warehouse details

Add line items for consignment orders

the inventory transaction status of this consignment order reference as a Consignment replenishment order and receipt status is order

now let’s receive our consignment inventory. Procurement and sourcing > Consignment > Consignment replenishment orders > Receive > Product receipt:

After posting the Product receipt the inventory transaction and on hand inventory will be updated.

Note that there are no ledger postings related to the Consignment replenishment order product receipt:

Before we consume this inventory, we need to create an Inventory ownership change journal. Inventory management > Journal entries > Items > Inventory ownership change or Procurement and sourcing > Consignment > Inventory ownership change:

Click New and open the new window form

Create a line, and fill the ‘From’ Site, Warehouse, Location and Owner

Post the journal, system generates the automatic purchase order will be created

 Click OK

The purchase order status is received and the Purchase order header shows an Origin of ‘Consignment’ (and the purchase order line quantity can’t be changed on the Purchase order):

Will look into Inventory transactions status 

The Inventory ownership change journal has consumed some of our consignment inventory and we have a purchase order product receipt (with the normal ledger postings).

So now we can transfer this inventory and consume it on a production order, and we can post a purchase order invoice on the purchase order.

There are some  restrictions on the consignment inventory. You can’t issue the consignment inventory to a transfer order, and you can’t issue the consignment inventory to a production order – you have to posted the ownership change first. But you can count the inventory (up and down), and transfer the consignment inventory using a transfer journal. There’s also a rather neat function to automatically populate the Inventory ownership change journal from production order components.