Skip to main content

Transfer Variance Report

Distributor/producer guide to the Transfer Variance Report in Encompass: find case, price and $0 cost differences between transfer invoices and purchases. Needs PurchaseCostEdit permission and v24.10+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 24.10

Pre-Conditions

*Required Permission - PurchaseCostEdit

* The Products Product Type must have 'Track Inventory' set to 'True' to show on the Transfer Variance Report.

Steps

The Transfer Variance Report is used to show inventory and price differences between transfer invoices and purchases. This report is useful to catch any mistakes during picking, loading, and receiving transfers. A Products Product Type must have 'Track Inventory' set to 'True' to show on the Transfer Variance Report. Otherwise, these Products will not show.

Filters:
​
​

  • From Location: Loadsheet or sending location
    ​
    ​

  • To Location: Shipment or receiving location
    ​
    ​

  • Invoice Status: Status of the loadsheet/invoice
    ​
    ​

  • PO Status: Status of the shipment/purchase
    ​
    ​

  • Start Date / End Date: Date range of the loadsheet and shipment date. Default Start Date = today - 30 days. Default End Date = today + 15 days
    ​
    ​

  • Invoice Num: Invoice number on both the invoice and purchase
    ​
    ​

  • Only Show Differences: Only shows transfer with a case and/or price variance between the transfer invoice and purchase
    ​
    ​

  • Show $0 Costing: Only shows products that were transferred at a $0 price or $0 keg deposit

Show $0 Costing Logic:
​
​$0.00 Case or Deposit will show as an Error on the report and the amount will show in red $0.00.
​
Deposit cost with $0.00 will only show if the following condistions are true:
​
​

  1. The package (ex. 1/2 BBL) on the product has a Packages Deposits record
    ​
    ​

  2. The transfer date is between the Packages Deposits Start Date and End Date or the End Date is blank
    ​
    ​

  3. The transfer customer is in the Deposit Area on the Packages Deposit record
    ​
    ​

  4. The Deposit Method = 1) Calculate as In-Line Deposit
    ​
    ​

  5. The Deposit amount on the Packages Deposit must be greater than $0.00

Best Practices

It is recommended to transfer inventory at a laid-in cost or laid-in + tax prices using a transfer out inventory customer. When creating new products, the costing may not be initially known, and due to timing issues, it is possible that products can be transferred at $0 before the costing is set up.

* The Products Product Type must have 'Track Inventory' set to 'True' to show on the Transfer Variance Report.

Did this answer your question?