Skip to main content
Solved

Customizing Numbering Sequence for Child Order created from Blankets


Hello!

I have been tasked to create or alter the numbering sequence logic for child orders created from Blanket orders. The goal is to have the sales order number produced by the create child orders process include the original blanket order number, followed by a dash and a sequence depending on the number of child orders being created. Example below:

Blanket Order is created with 5 line items that is expected to result in 5 child orders, the OrderNbr for this blanket order is 000001

 

Those 5 child orders should have the following as their OrderNbr:

000001-1

000001-2

000001-3

000001-4

000001-5

 

I suspect we will need to alter the numbering sequence to accommodate the increased size of the sequence start and end number, but I am lost as to where we would inject the logic to achieve the above.
 

Any help or guidance would be greatly appreciated!

Best answer by Marco Villasenor

Hi @Stevendh 
You would need to:

  1. Configure the numbering sequence used for orders to follow your new structure
  2. Create a custom DAC attribute with the code to identify if it is a child order or not, to calculate the next value.
  3. Customize the DAC field to use the new attribute

This article has an example for creating a custom numbering attribute for DACs: Auto-Numbering Customization - Acumatica Developers Blog

Of course, you still need to work out how to identify the parent order and the last child number to calculate the next CD in the sequence.

View original
Did this topic help you find an answer to your question?

2 replies

Marco Villasenor
Jr Varsity II
Forum|alt.badge.img+2

Hi @Stevendh 
You would need to:

  1. Configure the numbering sequence used for orders to follow your new structure
  2. Create a custom DAC attribute with the code to identify if it is a child order or not, to calculate the next value.
  3. Customize the DAC field to use the new attribute

This article has an example for creating a custom numbering attribute for DACs: Auto-Numbering Customization - Acumatica Developers Blog

Of course, you still need to work out how to identify the parent order and the last child number to calculate the next CD in the sequence.


  • Author
  • Freshman I
  • 2 replies
  • June 4, 2024
Marco Villasenor wrote:

Hi @Stevendh 
You would need to:

  1. Configure the numbering sequence used for orders to follow your new structure
  2. Create a custom DAC attribute with the code to identify if it is a child order or not, to calculate the next value.
  3. Customize the DAC field to use the new attribute

This article has an example for creating a custom numbering attribute for DACs: Auto-Numbering Customization - Acumatica Developers Blog

Of course, you still need to work out how to identify the parent order and the last child number to calculate the next CD in the sequence.



This took me some time to implement but seems to work as intended, thank you so much!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings