Database links between Vendor Invoices and Purchase Orders and Landed Costs
Vendor Invoices / Bills created in Acctivate can be associated with a Purchase Order, Landed Cost, or Both. Understanding how these links work can help with creating Crystal Reports and Microsoft Excel database queries
The POInvoice database view stores Vendor Invoices created within Acctivate.
When associating a Vendor Invoice with a Purchase Order or Landed Cost, there are two important columns:
-
GUIDPO
- Type
POInvoice.Type
First, the Type field (POInvoice.Type) indicates if this invoice was created from the Enter Purchase Invoice window or Enter Landed Cost window.
-
POInvoice.Type = 'L' indicates that this invoice was created from a Landed Cost transaction
- POInvoice.Type = 'P' indicates that this invoice was created from a Purchase Order
POInvoice.GUIDPO
The GUIDPO field will indicate the GUID, the unique identifier, of the related record based on the Type value.
-
If POInvoice.Type is 'L', Landed Cost, then GUIDPO refers to INVTransaction.GUIDINVTransaction. That is the unique identifier for the Landed Cost.
- If the POInvoice.Type is 'P', Purchase Order, then GUIDPO refers to PO.GUIDPO. That is the unique identifier for the Purchase Order record.