Running the Transfer Register Report

Use the Transfer Register report to check for shipping/receiving or pricing/costing discrepancies between branches. You can run the report for transfers between two branches or multiple branches. If transfers were entered as a batch, you can run the report on that batch. We recommend that you schedule transfer registers to run at month-end.

Note: You must be authorized to print the transfer register for a receiving generation. The following authorization keys should be assigned:TOE.ALLOWED and TOE.CLOSED.ORDER.EDIT.

Depending on your authorization, the report displays just pricing information or Cost of Goods Sold (COGS) and G/L Posting in addition to pricing.

This report is useful in closing transfers at month-end. To close out transfers, all inventory must be accounted for. Transfers can be completed, in dispute, or in transit. You can run the report for the following transfer statuses:

Run the report for...	To list...
Shipped and Received	completed transfers. Check that the Total Ship, Total Recv, and Total Cost amounts are equal for each transfer.
Disputed Only	disputed transfers.
Shipped/Not Received	shipped transfers in transit to another branch. If the transfer is in transit at month-end, you must decide which branch owns the inventory while it is in transit. For that branch, post a journal entry to debit Inventory and Credit Transfer Exchange. On the first date of the following month, reverse the journal entry.

To run the Transfer Register report:

From the Xfers > Reports menu, select Transfer Register to display the Transfer Register screen.
In the Start Date and End Date fields, enter the date range of the report. You can enter calendar date or a variable date in these fields.
In the To Br(s) field, indicate the branches to which transfers have been made. You can enter multiple branch numbers separated by commas.
In the From Br(s) field, indicate the branches from which transfers have been made. You can enter multiple branch numbers separated by commas.
In the Status field, press F10 and select the transaction status for the transfers you want to list on the report.

In the Batch field, enter the Batch ID to run the register for a batch of transfers. This field is optional.
Set options, if needed, and generate the report.