News

Sage 50 – Add The Customer Order Number To Your Customer Statements

Published: 1 October 2025

The steps in this guide detail how to add the Customer order number that’s on your sales order and invoice to your customer statement layouts.

Summary 

To help you track customer invoices and orders in Sage 50 Accounts, you can enter an order reference or number your customer provides you, when you enter the sales order or invoice. 

You can add this customer order number to your customer statement layouts. 

To add the INVOICE table to your layout 

  1. Select the document you want to amend, then click Edit. 
  2. Click Report, then click Joins. 
  3. Click and drag the INVOICE table into the central pane. 
  4. From the AUDIT_HEADER table select the INV_REF_NUMERIC variable 
  5. From the INVOICE table select the INVOICE_NUMBER variable. 
  6. Click and drag the INV_REF_NUMERIC variable from the AUDIT_HEADER table to the INVOICE_NUMBER variable in the INVOICE table. 
  7. Select the join between the two tables. 
  8. In the Properties pane, change the Join Type to Parent Outer.
  9. Click OK. 

Add the data field to your document

  1. On the menu bar click Toolbox, then click Add Data Field.
  2. Click once in the blank space where you want the data field to appear.
  3. Select the INVOICE table, then select CUST_ORDER_NUMBER.
  4. Click OK.
  5. If required, click and drag to move or resize the data field.
  6. On the menu bar click File, then click Save As.
  7. Enter a new file name then click Save.
  8. On the menu bar click File, then click Exit.

NOTE: You might need to move some of your current fields along, so that you can fit in the customer order number.  You can click and drag fields left and right to do this.

You can also add a text box in the column headings for Customer Order No.

Further Information

If you’d like to talk to our product experts about Sage 50 Accounting, or would like to book a demonstration, you can find more information here.

While Sage 50 can get the job done, if you’re looking for a smarter, cloud-ready accounting solution with more flexibility and modern features, it might be time to explore what Business Central Switch can do for you!

Want to learn more?

Read More