Basic Transfer functionality in CP SQL
CounterPoint SQL allows you to process multi-step transfers of multiple items between locations. There are three types of transfer transactions as follow:
1. Quick Transfers – Theses types of transfers can either be entered and posted individually or saved to a batch, and then posted later, all at one time. The assumption here that once the transfer is posted, no further work is required.
2. Transfer Out – This is a transfer that is initiated at the "From" (sending) site, where a destination "To" (receiving) location is specified.
3. Transfer In – This is transaction used to process (receive) the transfer(s) at the destination site.
Transfers transactions can be set to vary the General Ledger Sub-Account by a number of different factors.
To complete a transfer, you would enter and post Transfer Out and Transfer In documents, and optionally can print the accompanying forms, edit lists, and journal reports.
Before you begin processing transfers, you must create at least one transfer clearing account and assign the appropriate transfer clearing account to each of your account codes. In addition, you must set up transfer batches for each user who will be processing transfers.
To start the transfer process you would enter, edit, and post a Transfer Out document, which identifies the From (sending) and To (receiving) locations, as well as the items and quantities that are being transferred.
When the inventory arrives at the To location, you can enter, edit, and post a Transfer In document, whichincreases the quantity on hand at the To location and completes the transfer process. You can enter and post multiple receivings for a single transfer, to allow for staggered arrival of transferred goods, but there can only be a single unposted Transfer In for each Transfer Out.
CounterPoint SQL automatically reconciles any quantity discrepancies when the Transfer In is posted, using the "Transfer as received" method. This means that any overages or shortages update are charged back against the From (Sending) location.
For example, when you post a Transfer Out for a quantity of 5 items from location A to location B, quantity on hand at location A is decreased by 5. If you then post a Transfer In for a quantity of 4, quantity on hand at location B is increased by 4 and quantity on hand at location A is increased by 1.
Addi tonally, CP SQL can configured so that Quantities Committed can be shown at either the Sending or Receiving Location, or both.
Please contact CCS Retail Systems Support for assistance with configuring your system for using transfers.