======Preprint pallet labels====== It is possible to pre-print logistic labels so they can be used later when creating stocks. Because in this case the SSCC’s do not exist in the system when they are printed, it requires a special procedure in order to create the labels and to avoid SSCC duplications. ====1. Add the stored procedure==== Before adding the stored procedure, go to the [[implementation:wms:sscc|‘SSCC tab’]] of the Organizational Structure and check the ‘Current SSCC’ number. Add the {{:implementation:howto:preprintlabel:pmx_sp_goodsreceiptlabel_mass.zip|‘PMX_SP_GoodsReceiptLabel_Mass’ stored procedure}} to the PMX_ database. Modify the start SSCC by entering the current SSCC number plus one as the value for the //set @currentSSCCInt// parameter. The added SSCC number will be the first SSCC number to be printed. EXAMPLE: In the example the Current SSCC number was 10, therefore we added 11 as the start SSCC number. {{ :implementation:howto:set_current_sscc.png |Set current SSCC}} ====2. Crystal Reports==== Open the {{:implementation:howto:preprintlabel:goodsreceiptlabel_mass.7z|‘GoodsReceiptLabel_MASS’ report}} in Crystal Reports. Set the datasource location of the report to the ‘PMX_SP_GoodsReceiptLabel_Mass’ stored procedure. {{ :implementation:howto:datasource_location.png |Set datasource location}} Print the labels from Crystal Reports. On the ‘Enter values’ form add the number of the logistic labels to print to the @count field and click on the ‘Ok’ button. {{ :implementation:howto:enter_values.png |Enter values}} ====3. Modify the current SSCC number==== As the pre-printed SSCC’s do not exist is the system, the current SSCC number did not change. In order to avoid SSCC duplication, increase the current SSCC number with the number of the printed SSCC’s on the PMX_SSCC table. EXAMPLE: We printed 10 labels therefore we increased the value in the Current SSCC column by 10. Because the original value was 10, we set 20 as the new value. {{ :implementation:howto:current_sscc.png |Adjust current SSCC}} {{ :implementation:howto:label.png?400 |Label}}