Who is populating record in RA_INTERFACE_LINES_ALL if the transaction is coming from Sales Order?
Can I manually populate RA_INTERFACE_DISTRIBUTIONS_ALL if the transaction is coming from Sales Order? All the sample records I created in this table are simply ignored by Auto Invoice and still uses the GL account set in Auto Accounting.
I now was able to override auto accounting by populating RA_INTERFACE_DISTRIBUTIONS_ALL. Interface_line_context and interface_line_attribute1--15 must be exactly same with the record in RA_INTERFACE_LINES_ALL. The problem that is why my previous tests never worked was I forgot to populate ORG_ID!
Yes, I was able to populate RA_INTERFACE_DISTRIBUTIONS_ALL even if the transaction came from Sales Order.
Doing so you may get duplicated transactions as any invoiceable sales order line will be pushed in the autoinvoice process when the workflow activity comes to this step.
Can you please clarify your point, I value your comment. Which transactions will get duplicated? I need to override Auto Accounting because we need to control the GL account for discounts and have several kinds of discounts that we want to differentiante the GL account from each other when passed to AR and GL.