APPLIES TO:

SYMPTOMS

The problem is that in the RA_INTERFACE_SALESCREDITS_ALL table, the line associated with the gross price line has the salesperson from the order, but the line associated with the discount has the default salesperson, 'No Sales Credit'.

Issue is verified from the output of the HTMomse11i.sql output.

CAUSE

As per the OM check output the profile option below is set to No.

OM: Credit Salesperson for Freight on Sales N

That is the reason why the default Sales Rep Id of "No Sales Credit" being chosen in this case, for the Modifier Line in the RA_INTERFACE_SALESCREDITS_ALL

In 12.1 this is not achieved via profile option but rather a similar system parameter:

Credit Salesperson for Freight on Sales.

This is standard functionality.

SOLUTION

When using a Modifier of the Type 'Freight and Special charge List', the value for the profile
setting - OM: Credit Salesperson for Freight on Sales is being used. If it is set to No, the Freight
Modifier will have no Salesrep_id in the ra_interface_lines_all table.

Set the value of the above profile OM: Credit Salesperson for Freight on Sales to Yes.

In 12.1 this is not achieved via profile option but rather a similar system parameter: Credit Salesperson for Freight on Sales.

Set this parameter value to Yes.

OR

Create a Modifier of another type such as "Discount List" and try again.
That should resolve the issue of "No Sales Credit" in the RA_INTERFACE_SALESCREDITS_ALL for the Modifier line.