I am attempting to create a simple query showing invoices that have been posted for the day. I'm using SINVOICE, SINVOICEV, SINVOICED, and GACCENTRY all joined via NUM_0, plus a join from SINVOICE.GTE_0 to GACCENTRY.TYP_0. When I attempt to save/validate I'm getting this error:
Graphical query ZPOSTINV -> Table SINVOICED SID0 : Incorrect link
I assume this is because there is a second key field SIDLIN_0 on SINVOICED that needs to be linked to something.
Only thing is there are no other detail tables in the query so I don't know what this should be linked to if anything.
I'm using data from SINVOICED in expressions that sum cost and gross profit totals: sum([F:SID]CPRPRI) and sum([F:SID]PFM)
This is because as far as I know there are no fields in the invoice header tables that contain total invoice cost and GP.
What am I doing wrong here?