Document numbering Based On Optional Field

In our previous blog “Why Use Document Numbering”, we had discussed about the use of document numbering for sage 300 ERP. We already know that the document numbering module generates the document numbers based on Location, Account set, combination of account set and also does generate based on the bank code. In this blog we will discuss about the new number generation method i.e. based on the optional field. This is the customization part which was done for one of our clients.
Optional field customization in document numbering of sage 300 ERP allows a user to generate the document number based on optional field condition.
New Stuff: Miscellaneous Payment Feature in SAGE 300 ERP
In this method, the user needs to define an optional field which will be considered for number generation process. Based on that optional field value, the document number will be generated.
Let’s take an example, to understand idea behind the number generation on optional field. First, the user needs do the configuration.
For example, we will create configuration for IC shipment screen,
⦁  Create one or more optional field GNDNUM for defining values of optional fields defined in               transaction for number generation.
Refer below screen for IC shipment optional field configuration.

⦁  Create one or more optional field GNDNUM for defining values of optional fields defined in       transaction for number generation.
Refer below screen to define optional field values.

⦁  Now, we need to define number series which would be generated for IC shipment.
Please refer the below screen to define numbering mapping.

⦁  Now, we will do the IC shipment entry with optional field “RGP”.
Please refer the below screen for IC shipment transaction with optional field.

 

⦁  After posting, the number will be generated as per configuration.
Please refer the below screen.

With the help of this customization, users can generate a number series on the basis of their requirements which are apart from Account set, Location, bank code and location | Account set.
Read Also:
1.Document Numbering for AR Misc. Receipt
2.Grouping feature in Document Numbering Series for Sage Accpac
3.Set Document Numbering based on Bank Code for Sage 300 ERP
4.Configuring Document Numbering for Sage 300 ERP
5.Set Document Numbering for Sage 300 ERP on the combination of Account Set and Location