We are currently reading Pastel data via ODBC into a QlikView system and need to understand how Pastel links Supplier Returns to Supplier Invoices.
When a Supplier Order has been created and an Invoice linking to that order is captured, the LinkDocumentNumber field contains the link connecting the two documents, however when a Supplier Return is generated and matched to the (Original Suppliers' Invoice(?)) there is no reference to the link in the LinkDocumentNumber field and I can see no clear connection in the LinkNum, LinkedNum or LinkID fields either?
Does anyone have any idea how this connection is created in the Pastel tables?
Any assistance would be greatly appreciated.