Procedure for Converting Consignments to Posted
Previous Topic  Next Topic 

It is important to realize that converting consignments is not mandatory but recommended. If you do not mind possibly having wrong Quantity on Hold (QHD) during the day then you can REBUILD.QHD as a batch process every night, but if you are running General Ledger the Inventory Value will never match unless Consignments are posted.


Also please note that you must be running PM version 16.3 or above to run this procedure.



  1. Determine if Consignments are already being posted.

       SORT ORDER WITH TRANS.TYPE = "CO""CC" INVOICE.NO DATE.ENT

       If the INVOICE.NO field is blank then the consignments are not posted.


  1. If manageable, have the customer go through the consignments and determine if the consignments are valid. If invalid consignments are found then delete the invalid consignments from TCL because the cost was most likely already absorbed when the prior physical inventory was done. If you delete in the POS Entry (1.1) program then QOH will be up counted which will most likely not be desired.


  1. To delete from TCL do a procedure similar to the following (this is an example only):

       CREATE-FILE ORDER.date 1 101 (X

       SELECT ORDER WITH TRANS.TYPE = "CO""CC" AND WITH DATE.ENT <= "1/1/2006" AND WITH INVOICE.DATE = ""

       COPY ORDER (D

       To:(ORDER.date

       Restore the items that are in the TABLE ORDERLIST

       QSELECT TABLE ORDERLIST

       COPY ORDER.date (D

       To:(ORDER


  1. If there are remaining consignment orders to convert, run SHL CONVERT.CONSIGNMENTS from TCL and carefully read and follow the on screen instructions. For example, you must decide how to set the "Enable Consignment Post" setting in POS Defaults and Comments (10.2.6.2 field 46). Option <G> will most likely be the preferred setting since this does not required setting up separate accounts for customers and posting consignments to AR. Consignments will only post to General Ledger.


  1. Manual Journal Entries must be done to represent the outstanding consignments. Run a Consignment Order Report (1.6.4) to determine the value of the consignments at cost.


  1. Since posted consignments can not be changed Consignment Credits will have to done to return items to stock and a new Consignment will have to be done to add new items. There is a new POS Entry (1.1) option added at the Order Number prompt to <C>opy or <M>erge orders. This should make doing complete returns much easier because the original consignment can be copied into a new quote order then the transaction type can be changed to CC to make it a consignment credit.


  1. Be sure to check the "Prevent QOH Change on CC" setting in POS Defaults and Comments (10.2.6.2 field 47).


  1. And the "Consignment Inventory" account setting in AR Setup (10.2.2.1 field 16).