How the TRX_DATE Will be Calculated while interfacing Bill Lines to AR?
How the TRX_DATE on RA_INTERFACE_LINES_ALL table is calculated?
is it based on the interface date? Or based on when the ESS job (Send Subscription Billing Information to Receivables) is performed?
Expected result = TRX_DATE is the same as subscription interface date, so the AR invoice date will have the correct value, which is the same as subscription interface date
Bill Line Creation Date : 2022-02-17
Interface Date at Bill Lines : 2022-03-01
Invoiced Date at Bill Lines 2022-03-01
TRX_DATE at RA_INTERFACE_LINES_ALL : 2022-04-26
ESS Job Executed on : 2022-04-26