Tuesday, March 1, 2011

Transfer order with misc charges

On a previous project, we discovered a way in AX 2009 to process transfer order between sites WITH MISC CHARGES such as freight. The standard transfer order function in AX doesn't provide the ability to record misc charges on transfer. But for some businesses, intracompany transfer freight could be very expensive and it must be captured for inventory cost. So, we tweaked the intercompany order function in AX a bit to serve for this intracompany transfer purpose, and it worked for us! Here is what we did.

There are frequent transfers of some heavy items between Site A and B, and freight cost must be entered into the inventory. Assume all regular parameters (e.g. site, warehouse, dimensions, etc.) are properly configured.

1. Create two special customers A and B

  • Assign a special customer group where you'll set up postings for intracompany transfers.
  • Check checkboxes for intercompany customer (Setup tab - Autocreate intercompany order, Direct delivery), if you want a sales order auto created when a PO is created or direct delivery to a real customer. 
  • Make sure you enter a default site and warehouse under the Sales Order tab. 
  • Click Setup button - External code and create an external code. Because customers and vendors are in two different tables, you have to link them through an external code. 

Customer External Code

2. Create two special vendors A and B, as the previous step. 

3. Go to Basic > Setup > AIF > End points, create and configure an intracompany transfer end point. Make sure Company under General tab is set to the current company. Put your special customers and vendors as the Constraints. 
 
4. Still on the end point form, Click Action Policies. Out of the box, you should have two policies, PurchaseRequisition and SalesOrder. 
 
Action Policies

5. Click Setup tab for each policy and configure the parameters as you wanted. Note, if you want the price editable from the derived order, you want to make sure the "Allow price edit" checkbox is checked. 

6. On each policy, click Configure button. Since this is for transfers within a company, I recommend to select Our for all mappings except Vendor, Customer and Misc Charges which should be External. Same as vendors and customers, an external code should be entered for misc charges (AR/AP - Setup - Misc charges code).

Configure value mapping

That's it for intracompany transfer order settings. Now, you can create your transfer order with misc charges from either sales or purchase order, and verify if misc charges are allocated to your inventory.

5 comments:

  1. I have doubt in Intercompany order.
    I create a SO and PO is automatically created.Now I invoice SO not PO.So SO is invoiced and PO is in OpenOrder.
    Now what my doubt is when i change warehouse for PO in PurchLine,it is not updated.shall i know why?
    thanks in advance....

    ReplyDelete
  2. Hi, sorry, I was away for a while and wasn't able to monitor my blog. I wish you already had your issue resolved. If not, can you be more specific about what happens there when you change your PO warehouse on the line? What's not updated? Warehouse on the PO line or invoice?

    ReplyDelete
  3. Hello Peng,

    We have this same issue but in DAX 2012, and as far as we know DAX 2012 doesn't have the End Point Form any more. Do you know how to get the Transfer order with misc charges in DAX2012?
    Tnxs in advance !

    Alex

    ReplyDelete
  4. Hello Peng,

    I would like to apply misc. charge on Transfer Journal (IM > Journal > Item Transaction > Transfer.
    This transfer will do between WH in the same company (not intercompany)

    Please advise.

    Thank you for your time

    ReplyDelete
  5. Transfer Amazing knowledge and I like to share this kind of information with my friends and hope they like it they why I do

    ReplyDelete