Document Numbering - how to show 'Transaction #' in all documents screen?
In the A/R Invoice and A/P Invoice screen, only 'Primary' 'No' is shown, Could I also have a field that shows 'Transaction #' of this invoice?
Primary No. 288 in A/R Invoice - - - refer to No.288 A/R Invoice, the responding Transaction # is 3722.
I think I need to add a field. Please advise me how to get it.
Gordon Du replied
You need to add an User Field through Manage User Field under Tools. Select Market Documents - Title to add your field.
Use View - User Defined Field to bring it up. Suppose you named it TRANSID.
You hae to create a query such as:
Select T0.TransID from OPCH T0 Where T0.DocNum = $[$4.0.0]
After saving the query, you can click your TRANSID field and go to Tools - Search Function - Define. Then Search by saved query. Double click the empty line to bring up query manager and select the query you just created.
My example is for AP invoice. Change OPCH to OINV for AR Invoice.