Tayana Solutions

tayana solutions
+1-678-910-2774
Schedule Demo

Mastering Acumatica: Unique Sales Order Tracking

This video explores a clever solution to a common Acumatica challenge: creating unique external reference numbers for sales orders, ensuring data integrity and streamlined automation. 

(a) Challenges: The Quest for Unique Sales Order References

  • Manual Data Entry: Without an automated system, users had to manually enter external reference numbers for each sales order. This manual process was time-consuming and prone to errors, especially as the volume of orders increased. 
  • Risk of Duplication: Manual entry increased the likelihood of generating duplicate external reference numbers. Duplicate entries could lead to confusion, reporting inaccuracies, and potential problems with order processing. 
  • Client Demand for Automation and Uniqueness: The client required a system that automatically generated unique external reference numbers, similar to how a key field functions, ensuring each sales order had a distinct identifier. 

(b) Solution: Combining Acumatica Features with Custom Ingenuity

The Approach: The solution involved a clever combination of existing Acumatica fields and a custom field, demonstrating the platform’s flexibility and customization capabilities. 

The Building Blocks: 

  • SO Invoice Number: The existing SO Invoice Number field was leveraged as part of the solution. 
  • Customer Unique ID: Each customer in Acumatica has a unique ID, which was also incorporated into the external reference number generation. 
  • Custom Field at the Customer Level: A custom field was created at the customer level to serve as an incrementing counter for each new sales order placed by that customer. 

The Logic: When a new sales order is created, the solution automatically generates the external reference number by combining: 

  1. Customer’s Unique ID: This ensures the reference is tied to the specific customer.
  2. SO Invoice Number: This adds another layer of uniqueness. 
  3. Incrementing Value from the Custom Field: This custom field at the customer level increases with each new sales order, ensuring each reference number is completely unique. 

Example: For a customer with the ID “CustomerA123,” the first sales order might have an external reference number like “CustomerA123-SO1234-0001.” The next sales order for the same customer would be “CustomerA123-SO1235-0002,” and so on. 

Benefits and Advantages: 

  • Guaranteed Uniqueness: The solution completely eliminates the possibility of duplicate external reference numbers, ensuring data integrity. 
  • Streamlined Automation: Sales orders now have unique reference numbers generated automatically, saving time and reducing the risk of manual errors. 
  • Scalability: The custom field is designed to handle a large number of orders per customer. 
  • Improved Data Integrity: Accurate and consistent external reference numbers contribute to improved data quality, which is essential for reporting and analysis. 
  • Enhanced Efficiency: Automation speeds up order processing, making the entire workflow more efficient. 
  • Increased Client Satisfaction: The solution directly addresses the client’s specific needs and provides a reliable, long-term fix.