Requirement 1: Purchase Order
J-curve would like to create the Purchase Order PDF template as per given layout
Our Solution
The requirement can be achieved by creating a script for adding a custom button named PO Print in the Purchase Order. When the user clicks the custom button then PDF will be generated.
Field Mapping can be followed as per the given mapping file.
The “Angsana” font can be used for the content
The layout of the PDF will be designed as below
- Header will be displayed on every page
- The item body table can be considered as the Dynamic. So, the table will be end immediately after the item’s lines
- Summary section can be added immediately after the Item table
- Signature will be displayed on every page
Assumptions
- Only an Original copy needs to be generated in A4 page size.
- The header and footer section (actions 1-27 and 49-56) will be repeated on every page if the print has multiple pages
- The amount format is comma-separated.
- The Thai words/Labels will be provided by the JCurve Solutions Limited and we can hard code the Thai labels in the print.
- The font style should be Angsana and the font size should be the same as the file provided by the client.
- The field sourcing will be done based on the file that is provided by the client and we assume all the fields are available in Netsuite account
- The Date is displayed using the formula YYYY + 543 (e.g.: 2022+543 =2565)
- For Field mapping 8, the PR No. will be separated by comma if PR is different in each line.
- If there is only a single contract no. then this will show on the mapping field 17. Otherwise, it will show on mapping filed 30 after the description for each line.
- All vendor installment amount linked to current Purchase Order will be populated to print after the last item line.
- Amount in words sourced from the given field mapping(custbody_amount_words)
Risks
- If document has more than 1 page, Total will show only in the last page
- The Amount In Words (custbody_amount_words) field value population will not be considered in this scope. The value we are getting from this field will be directly populated to the Print