Setting Up Auto Invoice Interfacing from Payroll
Add the vendor number to all the deduction codes and the deduction tables you wish to invoice. This must be done in each applicable payroll. The database for deduction codes can be found from Payroll > Payroll System Maintenance > Payroll Database Maintenance > Setup Table: Deduction Code.The database for deduction rate table codes can be found from Payroll > Payroll System Maintenance > Payroll Database Maintenance > Setup Table: Deduction Code.
In each applicable payroll, change the Users Specific Parameters Profile (Payroll System Maintenance > Payroll Profile Maintenance > Users Specific Parameters Profile), Page 2.
Field: Auto Interface:
Set to Y to have the payroll journal entries and deduction invoice entries automatically invoiced at the end of the Payroll Update, Cheque Cancellation, Manual Cheque Entry, Year to Date Adjustments, and Statement History Adjustments. You will then be prompted to enter a valid GL to use as the default Invoice Error GL during interfacing.
Set to J to have only the payroll journal entries automatically interfaced.
Set to I to have only the payroll invoice entries automatically interfaced.
Verify the setup of the Finance Journal and Invoice Interface Profiles. In Finance, go to Finance Setup > Interface Setup Menu.
The journal interface is set up first
Then the invoice interface is set up and the Journal Entry format number is attached to the invoice interface profile.
Add the invoice interface code to the Payroll Master Profile (Payroll System Maintenance > Payroll Profile Maintenance > OPS Master Profile). Field: BAS Interface Code.
Finance Journal Entry Interface Profile
Format Name: Payroll Journal Entry Interface
Delimited/Fixed/XML Format: Fixed
Record Length: 149
Start Position | Length | |
|---|---|---|
Source Code | 031 | 002 |
Transaction Date | 011 | 002 |
GL Account Code | 001 | 020 |
SL Account Code | 021 | 010 |
Reference Data | 033 | 027 |
Commitment Amount | 080 | 020 |
Expenditure Amount | 100 | 020 |
Commitment Reference No | 070 | 010 |
Vendor No | 140 | 010 |
Secondary Vendor No | 000 | 000 |
Repeating Detail Group |
Finance Invoice Interface Profile
Start Position | Length | |
|---|---|---|
Vendor Number | 001 | 010 |
Invoice Number | 011 | 010 |
Due Date | 025 | 008 |
Invoice Date | 033 | 008 |
Invoice Amount | 041 | 015 |
Reference | 056 | 072 |
Vendor Name | 128 | 040 |
Vendor Address 1 | 168 | 030 |
Vendor Address 2 | 198 | 030 |
Vendor Address 3 | 228 | 028 |
Postal Code | 000 | 000 |
Vendor Address 4 | 256 | 010 |
Bank Number | 266 | 002 |
Tax Reportable | 268 | 002 |
Record Length | 000 | 268 |
JE Format Number | 1 | |
Format Name | Payroll Invoices |