Skip to main content
Question

Create a Number Sequence on User-Define Fields

  • October 14, 2024
  • 6 replies
  • 140 views

Forum|alt.badge.img

Is it possible to change a custom user-defined field to utilize an auto-numbering sequence?

For example, I have the following user-defined fields:

Receipt Selector:

  • Acknowledgement Receipt
  • Collection Receipt

Then I have another user-defined field:

Ref. Number: An auto-number generated based on the selected receipt.

6 replies

darylbowman
Captain II
Forum|alt.badge.img+15

If by ‘user-defined field’ you mean an Attribute UDF, then no. If you mean a custom database field, then yes.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • October 15, 2024

@darylbowman Why is this not possible with the Attribute UDF?


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • October 15, 2024

@jhoncandare04  Acumatica Attribute UDF (User-Defined Fields) in Acumatica aren't typically used for generating numbering sequences. Acumatica's numbering sequences are designed to be applied at the system level, such as for documents (invoices, sales orders, Shipments etc.), and they rely on system-specific fields rather than attributes.

Attributes are generally used to store additional metadata or custom information related to records, like customer, vendor, or inventory information. While attributes can be powerful for data collection, they don't integrate with the system's auto-numbering functionality.

 

Hope this clarifies!!


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • October 15, 2024

though attributes are primarily used for storing metadata or custom information, with the right configuration and development, they can be adapted for more advanced use cases like numbering sequences.i think it is possible to achieve this through customization .


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • October 15, 2024

No @jhoncandare04  It is not possible with the customization for the Attribute UDF. 

If you wanted to use the Numbering Sequence, I recommend you to go with the Database custom field.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • December 24, 2024

Hi ​@jhoncandare04 were you able to find a solution? Thank you!