Introduction
ToolWatch Vista integration support allows you to sync Purchase Orders (POs) and receipts in order to create the inventory and to have the purchase history available as a data point that can be used to view historical costs.
Receipts Line
The Vista bPORD table is used and the following fields are mapped.
Vista ReceiptLine | ToolWatch ReceiptLine | Notes |
- | TwPoLineId |
|
KeyID | ExternalId | Essentially the Primary Key, or the equivalent composite key, from the external system. This is the value that will be unique per integration setting for the external system. |
PO | POHeaderNumber |
|
RecvdUnits | Quantity |
|
RecvdCost | ActualPrice | This is price per unit (RecvdCost/RecvdUnits) |
- | LineNumber | This is a field that sequentially tracks receipt items against a PO |
RecvdDate | RecvdDate |
|
Notes | Notes |
|
BatchId | BatchId |
|
PostedDate | PostedDate | The receipt's Posted Date. Receipts are fetched by Company Code and by the PO/line combinations not already sent; PostedDate is not used to filter which receipts are returned. |