Transfer Order vs Transfer Journal Physical & Financial Costs

-

Transfer Order vs Transfer Journal Physical & Financial Costs

I have a scenario which has already been raised with Microsoft, however, perhaps someone else can advise.
Two purchase orders, a same serialized product for both and a qty of 2 for each PO.
PO 1: Qty 2 @ Unit Cost R 50.00
PO 2: Qty 2 @ Unit Cost R 60.00
Serial numbers are Registered and Product Receipts posted. The stock aging report displays all 4 serial numbers each with the appropriate Physical Cost.
Transfer order used to transfer all 4 serial numbers from warehouse M001 to M008, Shipment and Receipt posted.
If you run the stock aging report again, the Cost has been averaged and now reflects as R 55.00.
If the very same process is followed, however this time using a Transfer Journal, the appropriate Cost Price for each serial number is maintained in the opposite warehouse.
Storage dimension group at present is set up to track Physical and Financial stock at Warehouse level.
Tracking dimension group for serialized products are at present set up to track Physical and Financial stock.
Why would the Transfer order average the cost and the Transfer Journal not ??


New comment

So following the Microsoft status update skype call yesterday evening, the above is apparently a known issue with Dynamics AX 2012 R3 as well as Dynamics 365. The technicians are apparently working on a solution.
Conclusion: For a single line entry on a Transfer Order where the qty is >1 (example: 1000) and the product is serialized. The related inventory transactions retain 1 LotID for all registered serial numbers prior the Shipment & Receipt. This results in the Cost being averaged in the To Warehouse.
For comparison purposes, if say the Transfer Order Lines where created and split (example: Line No. 1, Qty 1, Serial No. 'A' ; Line No. 2, Qty 1, Serial No. 'B' ; etc) a LotID will be recognized per transfer order line and retain the actual Cost after Shipment & Receipt.
Feel free to provide your comments re the above.

Comments

Post a Comment

Popular posts from this blog

Warehouse Management System in AX 2012-Set Up & Configuration

-
Image
Warehouse Management System in AX 2012-Set Up & Configuration Hi All, As promised in my last post, I am back with WMS feature in AX 2012 R3. This is very interesting  and absolutely a new module that has been added to AX 2012 R3 whose purpose is basically to monitor and automate warehouse processes. WMS in AX is an Advanced distribution which provides complete real time and global view in the business efficiently. Warehouse Management for Microsoft Dynamics AX is an integrated warehousing solution for advanced distribution and order fulfillment that adds to the current capabilities of Microsoft Dynamics AX to support distribution companies and logistics providers. Overview of Features : You can configure inbound and outbound intelligent workflows. You can assign orders to clusters to pick from a single location, and configure profiles to control the validation and packing of items into shipping containers. You can create, implement...
Read more

Create Item/Product and Product master in Dynamics AX 2012 R2

-
Image
Create Item/Product and Product master in Dynamics AX 2012 R2 In This Article we are going to discuss how to create a product and Product master (Items). In 2012 R2, ‘ Item’  is replaced with ‘ Product’ . Item master was in Inventory Management Module, now there is a separate module for item/product creation ‘Product Information Management’. There are two types of Products in 2012 they are: 1. Product 2. Product Master 1. Product: Clearly identifiable products that do not have variations associated with them. You can think of them as standard or base products. Use the  Products list page  in the  Product information management  module to view and manage products. Manage Product: 2. Product Master: These serve as templates or models for  variants . The  variants  of a product master can be either predefined or created in sales scenarios by using a product configuration. A product master is associated with one or more ...
Read more

D365: Request for quotations (RFQ). Process RFQ overview

-
Image
D365: Request for quotations (RFQ). Process RFQ overview In this blog post I am going to review one type of procurement solicitation that is available within Microsoft dynamics 365 for Finance and Operations – Requests for quotations (RFQ). In general, RFQ is used when the company wants to receive competitive offers from several vendors for the goods they might purchase. As the result, company invite suppliers into a bidding process to bid on specific products or services, it is some kind of putting out goods to tender or requesting for proposal. And now it’s time to step up to the plate and follow the process presented below: I would like to bring to the table details on creating an RFQ, sending it to vendors, and evaluating bids returned by vendors. The first step in the RFQ process is to set up prerequisites. The following prerequisites are required for this functionality. Let’s break each setting down… Procurement and sourcing parameters for requests for ...
Read more