How to Create a Manual Transfer to Merge Two Locations

If you are closing a location that has a large amount of stock you can request that your Infusion Partner or Support Staff create a pending transfer to allow you to view all of the products being transferred.

Please note, charges will apply for any work done in Command Mode.  This is a time saving exercise.

 Command

For Support / Partner:

1. Create a pending transfer.  Find the link number from prodtidx.
2. Check for Serial Tracked items,  kitsets, allocated, or on order products. 

SELECT * FROM prodbals WHERE location = X AND instock<>0 AND CODE IN (SELECT CODE FROM products WHERE serial)

SELECT * FROM prodbals WHERE location = X AND instock<>0 AND CODE IN (SELECT CODE FROM products WHERE kitflag)

SELECT * FROM prodbals WHERE location = X AND (iconorder<>0 OR poonorder<>0 OR alloc<>0 OR joballoc<>0) AND instock<>0

These products should be excluded from the transfer and manually transferred.

If satisfied that all can be transferred:

SELECT 0 AS audit,**LINK NUMBER** AS LINK,prodbals.CODE,PRODUCTS.DESC,prodbals.instock AS qty, PRODUCTS.latest AS rate, (prodbals.instock*PRODUCTS.latest) AS EXTEND FROM prodbals LEFT JOIN PRODUCTS ON prodbals.CODE=products.code WHERE prodbals.location=X AND prodbals.instock<>0

COPY TO prodtlnappend

USE prodtln

APPEND FROM prodtlnappend 

Open your product transfer,  you will see all of the stock from location x ready to process to the desired location.

A product Integrity check must be done on the completion of the transfer.  It is not necessary to rebuild the History.