U04 End of Period
U0424 Vendor ACH
| EOP Only | Yes |
| Frequency | Daily |
| Sequential Updates | No |
| Skip Notes | No restrictions |
For more information about End of Period,
refer to U04 End of Period Overview.
The Vendor ACH module selects disbursements which were identified as Vendor ACH when initially entered in the U0101 Book Lease update—that is, DISBURSEMENT TYPE is NEWA. The module reviews disbursements for the current portfolio from the last date Vendor ACH ran through 2 business days from the EOP submit date.
If the PRENOTE USED switch is set to Y for the portfolio selected, prenotification time criteria will be verified as NACHA Rules require, and prenotification entries will be created for vendors who have not yet been notified. (Vendors with CCD Standard Entry Class Code will be prenoted only if the PRENOTE CCD switch is set to Y for the portfolio.)
A standard ACH file is created for this portfolio to be uploaded into the Federal Reserve ACH system the following morning. This allows the user to enter as disbursement date the actual day the vendor should be credited. The Vendor ACH module picks up these records in advance (based on the ACH grace days) and submits them to the Federal Reserve for processing on the actual disbursement date.
The vendor account credited is input through U0201 Vendor and stored in the rlr Vendor table. The account debited is stored in the rac Preauthorized Payments Control table, the same file/account used in the PAP/ACH module to credit lease payments. Records are stored by portfolio.
EOP U0117 Check Disbursal runs and disburses all checks due to be disbursed today. It will not process NEWA checks. Once a check has been processed by the Vendor ACH module, it will be skipped if LeasePak encounters it again on subsequent runs.
The Vendor ACH module processes all rck Cashier Check records for the selected portfolio. Based on the last time Vendor ACH was run for the selected portfolio, the module selects all RCK records of DISBURSEMENT TYPE = NEWA that have not been printed (or have been voided since the last Vendor ACH run) that are to be disbursed on or before today (EOP submit date) plus the ACH Grace days. After successfully processing each RCK record, the module updates it with a print flag of P. For void checks, debit entries are created, and the flag V is not changed.
If prenotifications are used and time criteria are not satisfied, the entry will be included in the Exception Report and no live dollar entry will be sent.
The field D_LAST_VACH_S is also updated with the date when EOP runs. The scratch file name is DSPP_Pxx_VACH_YYMMDD.DAT. Where YYMMDD represents the primary disbursement date, i.e., the date the vendor is due to receive the money. When the Vendor ACH module starts up, it deletes any existing DSPP_Pxx_VACH_YYMMDD files. The Bank file is called Pxx_VACH_BANK_YYMMDD.DAT. Any pre-existing copies of this file are deleted as well. This prevents double posting problems.
Before running Vendor ACH, U0720 Weekend and Holiday Assignment should be set.
If any Dealer Alert switches are turned on in U0201 Vendor, the owed amount will not be disbursed. An output exception file will display the held-back check. If the Suspense Override Date is populated, the owed amount will be disbursed only up to the specified date.
Using Vendor ACH with WDE
Australian PAP Method
With WDE, if the Vendor's PAP Transit ID and Account Number are blank, U0424 Vendor ACH will still create a check, inserting spaces where the information would normally be in the bank file. LeasePak produces the U0424C Vendor ACH Exception report in conjunction with Vendor Alert only.
WDE: Vendor ACH Bank File Format
Header Record
| Character Position | Field Size | Field Description | Specification | LeasePak Value |
|---|---|---|---|---|
| 1 | 1 | Record type 0 | Must be 0 | 0 |
| 2-18 | 17 | Blank | Must be blank filled | Blank |
| 19-20 | 2 | Reel sequence number | Must be numeric commencing at 01, right justified, zero filled | 01 |
| 21-23 | 3 | Name of user's financial institution | Must be approved financial institution abbreviation--Westpak's abbreviation is WBC | rac.fin_inst_s (set in U0212 Portfolio→PAP/ACH Control File) |
| 24-30 | 7 | Blank | Must be blank filled | Blank |
| 31-56 | 26 | Name of user supplying file | Must be preferred specification from application, left justified, blank filled; cannot be blank | Portfolio name--truncate to 26 characters |
| 57-62 | 6 | Number of user supplying file | Must be user identification number which is allocated by APCA; must be numeric, right justified, zero filled | rac.o_id_num_s (Originator ID) |
| 63-74 | 12 | Description of entries | Must not be blank; left justified, blank filled | Hardcoded by LeasePak |
| 75-80 | 6 | Date to be processed | Must be numeric, format DDMMYY; zero filled | Primary disbursal date |
| 81-120 | 40 | Blank | Must be blank | Blank |
Detail Record
| Character Position | Field Size | Field Description | Specification | LeasePak Value |
|---|---|---|---|---|
| 1 | 1 | Record type 1 | Must be '1' | 1 |
| 2-8 | 7 | Bank/state/branch | Must he numeric with a hyphen in character position 5; character positions 2 and 3 must equal valid financial institution number; character position 4 must equal a valid State number (0-9) | rlr.inst_id_s (Vendor BSB) |
| 9-17 | 9 | Account number to be debited or credited | Only numbers, hyphens, and blanks are valid, must not contain all blanks or zeros; leading zeros which are part of a valid account number must he shown--for example, 00-1234; right justified, blank filled | rlr.p_acct_s (Vendor account) |
| 18 | 1 | Indicator | (blank) | Blank |
| 19-20 | 2 | Transaction code | Must be one of the valid industry standard transaction codes (see list); only numbers valid | '50' |
| 21-30 | 10 | Amount | Numbers only, must be greater than zero; format in cents, no punctuation; right justified, zero filled, unsigned | rck.amt_d (check amount) |
| 31-62 | 32 | Title of account to debited or credited | Must not be blank; preferred format: last (name) first middle (with only spaces in between); left justified, blank filled | rlr.nam_s (Vendor long name, truncated to 32 characters) |
| 63-80 | 18 | Lodgment reference | Reference as submitted by the user indicating details of the origin of the entry--for example, payroll number, invoice, contract number; left justified, blank filled; cannot be all blank | Portfolio number + company number + office number + unit number (of asset/unit) |
| 81-87 | 7 | BSB number, format xxx-xxx | Bank(financial institution)/state/branch and account number of user to enable retracing of the entry to its source if necessary; only numbers and hyphen; character positions 81-82 must be a valid financial institution number; character position 83 must be a valid state number (0-9); character position 84 must he a hyphen | rac.o_inst_id_s (Orix's BSB number) |
| 88-96 | 9 | Account number | Right justified, blank filled | rac.o_acct_num_s (Orix's account number, numeric only) |
| 97-112 | 16 | Name of remitter | Name of originator of the entry (may vary from name of the user); all characters valid, cannot be all blank; left justified, blank filled | dck.unit_s ('PRO -' + check asset number); not a critical field |
| 113-120 | 8 | Amount of withholding tax | Only numbers valid; format in cents, no punctuation; right justified, zero filled, unsigned | 00000000 |
File Total Record
| Character Position | Field Size | Field Description | Specification | LeasePak Value |
|---|---|---|---|---|
| 1 | 1 | Record type 7 | Must be '7' | 7 |
| 2-8 | 7 | BSB format filler | Must be '999-999' | 999-999 |
| 9-20 | 12 | Blank | Must be blank | Blank |
| 21-30 | 10 | File (user) net total amount | Numeric only; difference between file debit and credit total amounts; format in cents, right justified, zero filled, unsigned | 0000000000 |
| 31-40 | 10 | File (user) credit total amount | Numeric only; credit total amounts; format in cents, right justified, zero filled, unsigned | Total PAP/ACH 'NEWA' check amounts disbursed for the portfolio |
| 41-50 | 10 | File (user) debit total amount | Numeric only; debit total amounts; format in cents, right justified, zero filled, unsigned | 0000000000 |
| 51-74 | 24 | Blank | Must be blank | Blank |
| 75-80 | 6 | File (user) count of Type 1 records | Numeric only; right justified, zero filled | Number of detail records |
| 81-120 | 40 | Blank | Must be blank | Blank |
U0424A Vendor ACH Report
The U0424A Vendor ACH reports all checks disbursed to Vendors and includes the following information:
- VENDOR
NUMBER
- VENDOR
NAME
- ACH
TRANSIT ID
The Automated Clearing House Transit identification number is displayed.
- ACH ACCT NUMBER
The Automated Clearing House account number is displayed.
- CHK
NUMBER
The automatically generated check number is displayed.
- DISBURSE
DATE
The date of disbursement is displayed
- AMOUNT
The amount of disbursement is displayed.
U0424B Summary of Vendor ACH Bank File Report
This report contains a summary of vendor ACH transactions.
- NO
OF TRANSACTIONS
The total number of transactions is displayed.
- AMOUNT
The total amount of disbursement is displayed
U0424C Vendor ACH Exception Report
The U0424C Vendor ACH Exception reports all checks not included in the scratch (and bank) file because Vendor was not prenotified on time and includes the following information:
- VENDOR
NUMBER
- VENDOR
NAME
- ACH
TYPE
The Vendor ACH Type (Standard Entry Class Code) is displayed.
- ACH
TRANSIT ID
The Automated Clearing House Transit identification number is displayed.
- ACH ACCT NUMBER
The Automated Clearing House account number is displayed.
- CHK
NUMBER
The automatically generated check number is displayed.
- DISBURSE
DATE
The date of disbursement is displayed
- PRENOTE
DATE
The date the prenotification was sent is displayed
- AMOUNT
The amount of disbursement is displayed
Reference Guide |
Table of Contents
© 2025 NETSOL Technologies. All rights reserved.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.