Proposal Summary
Magswitch would like to source the quantity populated in the Commercial Invoice PDF from the Item fulfillment.
Requirement
Magswitch wants the QTY in the IF pdf to reflect the QTY shipped in individual IF.
Auto-Population
Layout
Our Solution
The current development in the IF needs to be modified to incorporate the new changes in the commercial invoice print taken from the IF record. The QTY in the IF pdf should reflect the QTY shipped in individual IF.
We need to modify the existing scripts in IF and need to create a separate template same as the existing Advanced PDF template – for Commercial Invoice in SO, but with some changes in the Auto Populations/field mapping used as per the requirement.
New Field mapping:
Following are the fields that need to be changed in the new pdf of IF. All the other field’s mapping are the same as before.
| Labels | Netsuite Field |
| Sales order/Packing No: | REF. NO. (Field ID: tranid) of IF |
| Shipped To: | Address (Field ID: shipaddress) under Shipping Address in IF |
| Part Number: | PART NUMBER (Field ID: custcol1) in IF item table. |
| Qty(Pcs) | Quantity of each item fulfilled in the IF. |
| Amt | [Rate of item in SO] * [Qty(Pcs)] |
| Total Qty | Total Quantity of items in the IF |
| Total Amt | Total Amt of items in the IF |
| Total Weight | [Weight of item] * [Total Qty] |
| Barcode | Barcode and label should be the REF. NO. (Field ID: tranid) of IF |
There is no change in the current layout apart from the changes in the data sourcing.
Areas that need to be changed are highlighted in the current layout, added below:
Assumption
- Template – alignment, header, footer and subsidiary conditions are the same as in the previous SO pdf.
- “<subsidiary> – Comm. Inv” custom button naming in IF also follows the previous development, where <subsidiary> is the Subsidiary in the IF/SO
Risk
- The existing custom button “<subsidiary> – Comm. Inv” in IF is utilized to print the revised pdf. But we have to use a different scripting logic to bring the modifications in the current functionality in IF which includes more effort.
