D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Using external item descriptions on sales orders

  • 1.  Using external item descriptions on sales orders

    Posted 13 days ago
    Does anyone know if it is possible to use an external item description to create a sales order line in AX 2012?  We have a scenario where a customer will be sending in their own item number on an order but we will also have our own internal item number.  The person entering the sales order will not necessarily know what the internal item number will be and would need to use the customers number to create the sales order line.

    We have been using the the external item description for other external documents (packing slip, invoice, etc.) but never to create the sales order line.

    I found an old post relating to AX 2009 indicating that this functionality may be a customization but I'm not sure if it was something that is possible in 2012.  We are currently running 2012 R3.

    Thanks!

    #AX2012

    ------------------------------
    Brandon King
    P Graham Dunn
    Dalton OH
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Using external item descriptions on sales orders

    TOP CONTRIBUTOR
    Posted 13 days ago
    Hi Brandon,

    I did a quick test, and external item id cannot be used to enter the Item number on a sales order line.

    If you enter an Item Id which does not exist, R3 opens the Item search dialogue. This can be configured at Sales and marketing -> Setup -> Search, but in standard, cannot be configured to search External item ids.

    Guy

    ------------------------------
    Guy Terry
    Application Consultant
    Annata
    Portsmouth
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: Using external item descriptions on sales orders

    Posted 13 days ago
    Hello Brandon,

    If I remember correctly,, you should be able to add the customer's item number in the sales external description and associated it with the customer number.  When you create a sales order to the specific customer, you use your internal item number on the sales order and the customer item number will automatically show in the text field.   If you need to show the customer's item number on the invoice, you will need to use the form setup.

    At the moment I do not have access to AX (we've moved to D365) otherwise, I would attach a print screen.

    I hope this is helpful.
    Regards,Anilda

    ------------------------------
    Anilda Pena
    Sr. IT Business Analyst
    Omniparts Automotive
    Franklin TN
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: Using external item descriptions on sales orders

    Posted 12 days ago
    Your posts suggests this is for a specific customer, if you are not using the Item Search name field for any other purpose then you could add the customers number into this field. If you type the exact searchname field into the item number field AX should substitute this for your item number.
    You would still need to use the External item number to print the number as you do now.

    Good luck...

    ------------------------------
    Duane Jenkin
    Business Analyst
    Tourism Holdings Limited
    Hamilton, New Zealand
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: Using external item descriptions on sales orders

    GOLD CONTRIBUTOR
    Posted 12 days ago
    Brandon,
    We are using 2012 R3 and customer service uses the external ID all the time, but it is customer specific. On the customer, go to Sell tab, Setup> External ID descriptions. We also using this on the flip side with our vendors and purchase orders. If you want the external ID to show on documents, go to AR> Setup> Forms> Forms setup. For PO, the setup is on the same spot under Procurement and sourcing.
    Good Luck!

    ------------------------------
    Sarah Gabriel
    Operations Business Analyst
    Kai USA Ltd
    Tualatin OR
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: Using external item descriptions on sales orders

    Posted 9 days ago
    Edited by Jonathan Howe 9 days ago
    Brandon, we had a customisation in AX2009 which did what you describe. We have just upgraded to D365 F&O and have had to redevelop the customisation as no functionality has been introduced to do this.

    Our customisation not only allows sales staff to create sales order lines by entering the customer part/item number but it also allows us to record multiple part numbers against an item for a specific customer account - this is something you cannot so in vanilla AX/D365.

    Jonathan Howe
    IT Manager
    Cross Manufacturing Company (1938) Ltd
    Bath, UK.


    Conference-AXUG_200x200


  • 7.  RE: Using external item descriptions on sales orders

    Posted 4 days ago
    Thank you all for the suggestions.  After learning more about the situation internally, we determined that we will actually be able to set the items up using the customer's item number rather than having our own.  Luckily this time around it turned out to be the easiest solution for everyone involved!

    ------------------------------
    Brandon King
    P Graham Dunn
    Dalton OH
    ------------------------------

    Conference-AXUG_200x200


  • 8.  RE: Using external item descriptions on sales orders

    TOP CONTRIBUTOR
    Posted 3 days ago
    Just remember - Setting up a part using an external source for the part number can be required at times - however it requires extra diligence to ensure proper setup.
    Once you've loaded inventory or other transactions, the setup will be fairly locked down....
    (If you were using an internal part number and a problem occurs, you may simply decide to discontinue the old part, and create a new correctly configured part. This won't be an option when your using an outside source for the part numbers...)


    ------------------------------
    Tony Zeigler
    Senior Consultant
    Strategic Solutions NW, LLC
    Beaverton OR
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role