Requirement: Create a BPAY Payment File Format Template in TXT format in NetSuite.
Assuming that structure and field mapping will be given by client.
Here are the testing steps followed to verify the payment file template. These steps may vary along with the requirement and customizations.
Testing steps:
Company Bank Details
- Payments → Setup → Bank Details → New
- Add Bank Name, Select GL Bank Account.
- Set File Cabinet: 1638 (File stores EFT templates)
- Set EFT Template: BPAY Payment file format.
- Save the record.
- Enter values in Payment account Detail, Payer Institution code and State.
- Save the record.
Vendor
- Create or edit vendor record.
- Subsidiary of company Bank Details and Primary subsidiary of Vendor should be same.
- Under Bank Payment Details subtab, check ‘EFT BILL PAYMENT’ checkbox.
- Save the record.
- Edit the vendor record.
- Under Bank Payment Details subtab, click ‘New Bank Details’ button.
- Set Payment File Format: BPAY Payment file format.
- Set Type: Primary.
- Add mandatory fields and save the record.
Vendor Bill
- Create bill for vendor.
- Save the transaction and approve.
Bill Processing
- Payments → Payment Processing → Bill Payment Processing
- Select Company Bank Details in ‘Bank account’ field.
- Select A/P Account as Account given in vendor record.
- Select the transactions
- Submit
- Payment file Administration page will be opened. (Navigation: Payments → Payment Processing → Payment File Administration)
- After payment is processed, file will be populated on File Reference Field.
- Generated file will be stored in EFT files in file cabinet.
- Verify the field mapping.
Reverse Payments
- Click Reverse Payment on Payment file Administration.
- Select the transaction records.
- Submit.
- File in File Reference Field will be updated after payment reversal is processed.