You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is it possible to use the same line order from the project invoice for the AR invoice lines?

edited Feb 13, 2025 7:45AM in Receivables & Collections 2 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!