Freight line and Item Line of a same Sales Order are being splitting into two different Transactions
We have an issue when the user is trying to create the Credit Sales Order by copying the old Sales Order.
Freight line and Item Line of a same Sales Order are being splitting into two different Transactions in AR after Auto Invoice Program run.
According to Oracle Team, It is an intended behaviour of the system...
We are trying to customise the things at AR Interface Table level by deleting the Reference Line Id field from the AR Interface Lines. It will work only if there is only one freight line for the same sales order.
In case there are two Freight lines (One for Sales Order Line #1 and the other for Sales Order Line #2). Can you please suggest how we can define a trigger at that level.