1. Implementing Order Management
  2. Keep Your Sales Order Number When You Import

Keep Your Sales Order Number When You Import

Control how Order Management sets the sales order number when you import a source order.

Use a profile option.

Profile Option

Value

Where You Can Use It

Retain Sales Order Number

Select one.

  • Y. Use the source order number that you import from the source system as the order number during and after transformation. Order Management will display the source order number throughout the Order Management work area after transformation and during order fulfillment.

  • N . See the description below this table.

Only for a single site

Learn how to set up a profile option. For details, see Use Order Profiles to Control Order Management Behavior.

Don't Keep Your Sales Order Number

If you set Retain Sales Order Number to N, then Order Management doesn't use the source order number as the order number during or after transformation.

  • Order Management will assign a new order number for the source order and display the new number throughout the Order Management work area after transformation and during order fulfillment.

  • If the source order number in the source order that you import from the source system isn't unique in the source system, then you must set this option to N.

    For example, if source system A contains:
    • Two source orders that each use order number 12345, then set this option to N.
    • One source order that uses order number 12345, and if source system B contains one source order that uses order number 12345, then set this option to Y or N.

    This set up is necessary to avoid an error when you import orders because Order Management requires a unique order number for each sales order in the same source system.

  • Order Management creates a unique number for each sales order that you create in the Order Management work area, and each of these orders use Order Orchestration and Planning (OPS) as the source system.

    If you use OPS as your source system, and you if set Retain Sales Order Number to Y, then a conflict might happen between order numbers.

    For example, your source system might create a source order with order number 543865, and an order that you create in the Order Management work area might also use order number 543865. You must make sure these order numbers are unique. For example, use a value for your source order number that isn't numeric, or add a prefix or suffix to the number, such as src_543865.

  • The default value is N.

Integrate with Accounts Receivable

You might encounter a situation where the order number in Accounts Receivable isn't the same as the order number in Order Management. This might cause problems, such as when you do AutoInvoice during file-based data import in Accounts Receivable.

Order Management uses the RA_INTERFACE_LINES_ALL table to integrate with Accounts Receivable.

Order Management uses the ORDER_NUMBER column and SOURCE_ORDER_NUMBER column on the DOO_HEADERS_ALL table to populate columns in RA_INTERFACE_LINES_ALL.

Column in RA_INTERFACE_LINES_ALL

What Does it Store

INTERFACE_LINE_ATTRIBUTE1

SOURCE_ORDER_NUMBER

INTERFACE_LINE_ATTRIBUTE3

ORDER_NUMBER

SALES_ORDER

SOURCE_ORDER_NUMBER

Order Management sets the ORDER_NUMBER and SOURCE_ORDER_NUMBER in the DOO_HEADERS table to the same value that it uses in the Order Management work area.

However, if the values that you import are different than what Order Management uses, then you have two choices to make sure you use the same order number in Order Management and in Accounts Receivable:

  • Set the Retain Sales Order Number profile to Y, and Order Management will set ORDER_NUMBER to the same value that SOURCE_ORDER_NUMBER contains.

  • Use a document sequence to set the value in ORDER_NUMBER. For details, see Set Up Sequences for Sales Order Numbers.

Answers to Some of Your Questions About Sales Order Numbers

  • You can't use different order number sequences for different order types or different source systems. For example, you can't use sales orders 1000 through 10000 for order type A, and sales orders 10001 through 20000 for type B.

  • Order Management creates order numbers from a database sequence that makes sure order numbers are unique, but the sequence might contain gaps because of caching and other processing anomalies. You can't change this behavior.

  • You can't assign an order number from one draft order to another draft order, even if you delete the original draft because deleting the draft would will result in gaps in the order number sequence. Order Management assigns the order number for a draft order and the order details in the DOO_HEADERS_ALL table. If you delete the draft, then Order Management also deletes the entry for the draft from DOO_HEADERS_ALL.

Here's some SQL you can use to identify the line numbers that Order Management assigned to an order line and the fulfillment line.

SELECT  dha.header_id            ,
       dha.order_number         ,
       dha.source_order_number  ,
       dha.submitted_flag,
       dla.line_number          ,
       dla.SOURCE_LINE_NUMBER   ,
       dla.SOURCE_LINE_ID,
       dla. DISPLAY_LINE_NUMBER ,
       dfla.SOURCE_LINE_NUMBER  ,
       dfla.fulfill_line_number
FROM    fusion.doo_headers_All dha,
       fusion.doo_lines_all dla  ,
       Fusion.doo_fulfill_lines_all dfla
WHERE   dha.source_order_number in ('&SOURCE_ORDER1','&SOURCE_ORDER2')
       AND dla.header_id       = dha.header_id
       AND dfla.line_id        = dla.line_id
--and submitted_flag = 'Y'
order by dha.SOURCE_ORDER_NUMBER , dla.LINE_NUMBER

Related Topics