AR Transaction Type Mapping from Sales Orders

Issue: 

The AR transaction types are being wrongly picked up from the Sales order.

Case 1:

Sales order type “SAMPLE-TOYS” should generate AR transactions with Invoice-No charge receivables transactions type.

  • Order transaction type setup:

But in our case, It is generating Invoice- DMC domestic receivables transaction.

Cause of the issue:

Receivable Transaction Type on Invoice is derived from Standard sales order in the following sequence.

  1. Receivable Transaction Type of Order Line Type
  2. Receivable Transaction Type of Order Header Type
  3. OM System Parameters: Invoice Transaction Type

In this case, Line Type used on the order setup is UPG_LINE_TYPE_ORDER_1031 which has a defined Receivables Transaction Type as “Invoice-DMC Domestic”.

So, as per the standard functionality, Invoice generated with Receivable Transaction Type as “Invoice-DMC Domestic”.

How do we solve:

To have a different receivable transaction type on AR Invoice then we need to change the Receivable Transaction Type on Order Line Type Setup.

Step 1:

Remove the already existing record from the default order line type setup

Step2:

Click on the Assign Line flow

End date the existing incorrect line type record and add correct line type.

Save the changes made.

Now create a new sales order with SAMPLES – TOYS order type and check the corresponding AR transaction

Conclusion:

The AR transactions should be picked up correctly from the sales order.

Recent Posts