Is it possible to use the same line order from the project invoice for the AR invoice lines?
Summary:
When a line is deleted from the project invoice, the AR invoice generated does not follow the same line ordering sequence as the project invoice.
By default, the AR invoice line ordering for project invoice is based on the sequence from INTERFACE_LINE_ATTRIBUTE5 to INTERFACE_LINE_ATTRIBUTE8 in the RA_INTERFACE_LINES_ALL table. We are trying to create a new DFF to bring in the project invoice line number (INVOICE_LINE_NUM from the PJB_INVOICE_LINES table) into the AR invoice table (RA_INTERFACE_LINES). So that the invoice line attribute with the DFF can be used in Manage AutoInvoice Line Ordering Rules.
Tagged:
0