LPL - Auto Number AR Invoice based on last invoice number in the system

The "Transaction" field name (a.k.a. ReceivableInvoice) under the ReceivableInvoice BC is currently being manually typed in. User would like this ReceivableInvoice field to be auto generated based on the last AR invoice number. Is there a setting for this or LPL field that could be created to auto generate the field?

ApplicationAdministrator > Financials > Receivables > Processing > Invoices, Invoice Batch tab. Select an invoice, go to Transactions tab and proceed to add new transaction. The transaction field is what the user would like auto populated based of the last invoice number vs. having to find and type in.

com_2010feb_proactive.pdf

Find more posts tagged with

General Discussions

Accepted answers

All comments

jose-sahagun

Does anyone have any thoughts on how to accomplish autonumbering with LPL?

dEPM-648-Application Studio - Hiding rows and columns (with narrat.mp4

andy

There is an "autosequence" option that I've used on a user business class before, but I believe it's defined in the key field, so you might not be able to use this on a delivered business class.

Failing that, you could create a self relation sorted by that Transaction field, a derived field that returns the "last" value of that relation incremented by 1, and then default that derived field on the form. This assumes the Transaction field is an integer.

Copyright © 2025 Infor. All rights reserved.