Support for CIDs in Summary Invoice Prints and grid CIDs for Order and Invoice Print
Reference No: 29745
Details
Below prints are supported with .RTF format and pdf format.
Support for Panel ID 992219 for Printing Summary Invoice Header CIDs
To print the Summary Invoice Header information, use the below CIDs between the Start Panel (Component Type 82) and End Panel (Component Type 83) using the Panel ID as 992219.
CIDs to Print Header for Summary Invoice
The additional CIDs can be used along with existing CIDs while generating Summary Invoice Prints (generated using 151000UI, 151100UI, and 151200UI).
The details of the additional CIDs are provided in Table 1.0.
Table 1.0 CID Details for Summary Invoice Print
CID | Description |
876 | This CID prints the Project Number from the first order within the Summary Invoice. |
3 | This CID prints the Order Description from the first order within the Summary Invoice. |
10 | This CID prints the Main Company Name from the first order within the Summary Invoice. |
3331 | This CID prints the Main Company Phone Number from the first order within the Summary Invoice. |
112233 | This CID prints the Main Company E-mail from the first order within the Summary Invoice. |
700000 | This CID prints the UDF1 value from the first order within the Summary Invoice. |
2000100 | This CID prints the Contact Name from the contact page of the first order within the Summary Invoice. |
2000200 | This CID prints the Contact Phone Number from the contact page of the first order within the Summary Invoice. |
2000400 | This CID prints the Contact E-mail from the contact page of the first order within the Summary Invoice. |
1 | This CID prints the Order Number from the first order within the Summary Invoice. |
666 | This CID prints the Purchase Order Number from the first order within the Summary Invoice. |
67 | This CID prints the Billing Company Name from the first order within the Summary Invoice. |
651 | This CID prints the Billing Contact Company Phone Number from the first order within the Summary Invoice. |
659 | This CID prints the Billing Contact E-mail Address from the first order within the Summary Invoice. |
6890 | This CID prints the Advance Reference Number. |
6891 | This CID prints the Deposit Reference Number. |
6892 | This CID prints the Advance Last four digit Card Number. |
6893 | This CID prints the Deposit Last four digit Card Number. |
1458 | This CID prints the Total Replacement Cost from the first order within the Summary Invoice. |
10008 | This CID prints the Total Replacement Cost from the Order print |
CIDs to print the Payment schedule from the Order Grid Pricing along with the Posted invoice information
The payment schedule is printed based on the Order Header Grid using the Grid/PanelID [800003], and Additional CID is being added in the Grid/PanelID [800003] as [603052] and which prints as Previously Billed next to the invoice weeks that have already posted as shown in Figure 1.0.
Table 2.0 CIDs Reference Table
CIDs | Description |
603041 | Prints the Grid Schedules Unit. |
603042 | Prints the Grid Schedules Value. |
603043 | Prints the Total Rent Amount of Each Grid Schedule. |
603052 (NEW) | This CID prints as Previously Billed. If invoice is posted and additionally in the UI file 5th column Component Type should be 4 and 23rd Column Choice ID should be 7778. |
Figure 1.0 Payment Schedule in the Print
Support for Panel ID 153100 for items with group by shelf and sort by Product ID
The support for existing Panel ID (153100) which use to print the item grid for Order and Invoice Print. Extra components in the UI file has been given to achieve Items with group by shelf and sort by Product ID.
Below is the extra component fields which needs to be added to the UI files:
The Type Grid with Component Type as 7.
In the 39th Column, GROUPBY = 55, SORTBY = 35 in the Order UI form.
In the 39th Column, GROUPBY = 49, SORTBY = 17 in the Invoice UI form.
GROUPBY defines the table column number which has to group.
SORTBY defines the Item grid records which are sorted by which columns.
Figure 2.0 Order UI Form
Figure 3.0 Invoice UI Form
At Present, GROUPBY component is supported for one field.
Support for multiple fields for SORTBY as 35/26/48 with delimiter as "/".
Only Kit Header will be printed for a package, Kit Childs and Non-Item lines like (Section Header, Separator, and Section Total) won’t be printed.
In Print, items will be listed under the respective shelf which is tagged in the Order.
In Print, if Item is without a shelf, it will appear last in the sequence.