User Tools

Site Tools


implementation:manufacturing:pdc_print

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
implementation:manufacturing:pdc_print [2018/06/07 12:08]
csuhaa typo
implementation:manufacturing:pdc_print [2018/07/19 12:44] (current)
csuhaa report path version added
Line 1: Line 1:
 ======PDC Custom printing====== ======PDC Custom printing======
-=====Import the report===== +In order to print a report with Produmex PDC, import ​it into SBO or place it to a folder that Produmex Service Broker can access. 
-In order to print a report with Produmex PDC, first import the report into SAP Business One with the Report and Layout Import Wizard. ​+ 
 +<WRAP round tip>​**Import the report** \\ 
 +Import ​the report into SAP Business One with the Report and Layout Import Wizard. ​
  
 Browse the report then select ’Inventory’ > ’Inventory Reports’ as the destination location. ​ Browse the report then select ’Inventory’ > ’Inventory Reports’ as the destination location. ​
Line 10: Line 12:
  
 {{ :​implementation:​manufacturing:​customguide:​print:​report_id.png |}} {{ :​implementation:​manufacturing:​customguide:​print:​report_id.png |}}
 +</​WRAP>​
  
 =====Example - Print product label===== =====Example - Print product label=====
-====1.1. Add Print button====+====1. Add Print button====
 Open the Customization Fields table via: Tools > User Defined Windows > BXPCUSTFD - Customization Fields. For more information about the Customization Fields user table please see: [[implementation:​manufacturing:​customizationtechnology#​create_custom_field|Create custom field]] Open the Customization Fields table via: Tools > User Defined Windows > BXPCUSTFD - Customization Fields. For more information about the Customization Fields user table please see: [[implementation:​manufacturing:​customizationtechnology#​create_custom_field|Create custom field]]
  
Line 22: Line 25:
 {{ :​implementation:​manufacturing:​customguide:​print:​pdc_print.png |}} {{ :​implementation:​manufacturing:​customguide:​print:​pdc_print.png |}}
  
-====1.2. Create user query====+====2. Create user query====
 Add the custom queries with the Query Manager. For more information about PDC custom queries please see: [[implementation:​manufacturing:​customizationtechnology#​create_an_sap_user_query|Create a SAP user query]]. Add the custom queries with the Query Manager. For more information about PDC custom queries please see: [[implementation:​manufacturing:​customizationtechnology#​create_an_sap_user_query|Create a SAP user query]].
  
Line 33: Line 36:
 The name of the second query is the Produmex PDC event name on button click. In this example the user query name will be: //​BXPPSMobilePDC_ProductBatchNumbersAdvScreen_Print_click//​ The name of the second query is the Produmex PDC event name on button click. In this example the user query name will be: //​BXPPSMobilePDC_ProductBatchNumbersAdvScreen_Print_click//​
  
-Example query:+SQL
 <​code>​SELECT ​ <​code>​SELECT ​
-   '​RCRI0012' ​ "​PrintLayout$",​+   '​C:​\Produmex\Reports\Label.rpt' ​ "​PrintLayout$",​
    ​$[CurrentPDCBooking.ProductCode] "​Print_ItemCode",​    ​$[CurrentPDCBooking.ProductCode] "​Print_ItemCode",​
    ​$[CurrentPDCBooking.ProductName] "​Print_Item_ItemName",​    ​$[CurrentPDCBooking.ProductName] "​Print_Item_ItemName",​
Line 46: Line 49:
    '​Document PRINTING' ​ "​Message$",​ '​I'​ "​MessageType$"</​code>​    '​Document PRINTING' ​ "​Message$",​ '​I'​ "​MessageType$"</​code>​
  
-The user query does the following:+HANA 
 +<​code>​SELECT  
 +   '​RCRI0012' ​ "​PrintLayout$",​ 
 +   ​$[CurrentPDCBooking.ProductCode] "​Print_ItemCode",​ 
 +   ​$[CurrentPDCBooking.ProductName] "​Print_Item_ItemName",​ 
 +   ''​ "​Print_SerialNumber",​ 
 +   ​$[TextBatch] "​Print_BatchNumber",​ 
 +   ​$[TextBestBefore] "​Print_BestBeforeDate", ​  
 +   ​$[TextBatchQuantity] "​Print_Quantity",​ 
 +   ​$[TextSSCC] "​Print_SSCC",​ 
 +   '​PDFCreator'​ "​PrintPrinter$",​ 
 +   '​Document PRINTING' ​ "​Message$",​ '​I'​ "​MessageType$"​ 
 +   FROM DUMMY</​code>​ 
 + 
 + 
 +The user query does the following: ​\\
 Sets the parameters of the selected report to the values entered on the screen and sends it to the defined printer. Then displays the ‘Document printing’ message. Sets the parameters of the selected report to the values entered on the screen and sends it to the defined printer. Then displays the ‘Document printing’ message.
-The user query must contain every report parameter with the Print_ prefix. In the example the report has five parameters:  +The user query must contain every report parameter with the Print_ prefix. In the example the report has the following ​parameters:  
-  ​ItemCode +  ​ItemCode 
-  ​Item_ItemName +  ​Item_ItemName 
-  ​BatchNumber +  ​BatchNumber 
-  ​BestBeforeDate +  ​BestBeforeDate 
-  ​SerialNumber +  ​SerialNumber 
-  ​PrintQuantity +  ​PrintQuantity 
-  ​SSCC+  ​SSCC
  
 {{ :​implementation:​manufacturing:​customguide:​print:​print_review.png |}} {{ :​implementation:​manufacturing:​customguide:​print:​print_review.png |}}
  
-Replace the PrintLayout$ value with the Report ID. In the example the report ID is //​RCRI0012//​. ​+Replace the **PrintLayout$** value with the Report ID (in the HANA example the report ID is //​RCRI0012//​). It is also possible to specify a report that is not imported into SBO. In this case add the report file path (in the SQL example it is //​C:​\Produmex\Reports\Label.rpt//​)
  
-Replace the PrintPrinter$ value with your printer name. In the example the printer name is //​PDFCreator//​.+Replace the **PrintPrinter$** value with your printer name. In the example the printer name is //​PDFCreator//​.
implementation/manufacturing/pdc_print.txt · Last modified: 2018/07/19 12:44 by csuhaa