Proposal summary
This proposal describes the EFT Template creation with Netsuite. The Payment file templates are used to generate EFT in different formats.
Requirement
QIMA would like to create EFT File Formats using the provided sample format in Netsuite.
Our Solution
The requirement can be achieved by creating an EFT template using the provided sample format for all currencies based on the client’s requirement. Also need to create company bank details and entity bank details for the new Payment file template. Then that template needs to be tested by creating the vendor bills for the test vendor and need to do the bill processing for verification.
Field Mapping
| CELL in CSV | Value |
| A4 | IFH(static value) |
| A5 | BATHDR(static value) |
| A6 | SECPTY(static value) |
| B4 | IFILE(static value) |
| B5 | FTR(static value) |
| B6 | Entity bank details.custrecord_2663_entity_acct_no |
| C4 | CSV(static value) |
| C6 | Entity bank details.custrecord_2663_entity_acct_name |
| E4 | EFT Bill payments. EFT File Reference Note |
| F4 | EFT Bill payments. EFT File Reference Note |
| G4 | Today’s date |
| H4 | System. timestamp |
| I4 | V(static value) |
| J4 | 1(static value) |
| J5 | @1ST@(static value) |
| K4 | 37(static value) |
| K5 | Today’s date |
| L5 | 848740064292(static value) |
| M5 | currency of the bill |
| N5 | Bill amount |
| O6 | N(static value) |
| P6 | N(static value) |
| U5 | Qima Limited(static value) |
| V5 | 5/F Dah Sing Life Building(static value) |
| V6 | @HVP@(static value) |
| W5 | 99 -105 Des Voeux Road Central(static value) |
| X5 | Hong Kong(static value) |
| AA5 | 48258735003269F8(static value) |
| AI6 | SWF(static value) |
| AJ6 | Entity bank details.custrecord_2663_entity_swift |
| AP6 | CN(static value) |
| AR6 | Expense reimbursement(static value) |
| AV6 | SHA(static value) |
Assumptions
- We will create the payment template for all currencies.
- All values that you have marked as fixed can be hardcoded.
- We will not set any fields as mandatory in company bank details and entity bank details, and will not provide any validation for fields like minimum length and maximum length.