Check your settings in Invoice and Order defaults

• Click Settings then Invoice and Order Defaults, then click Update ledgers

If the Update transaction Ref with field is Invoice Number or Customer order number, follow the steps in the Add the data field to your layout section.

Follow the Add the INVOICE table to your layout section, if the field is set to Your order number.

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 layout

Rather watch a video? We've covered the full process in this one:

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 or 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.