https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Sage%20MAS%2090%20and%20200/Gated%20Customers/Warr_Svc_Support%20Plan/110-9000685.xml
110-9000685 - Electronic Payment checks skip check numbers when Print G/L Distribution is checked.
This article is available to everyone.
Print this article Does this article apply to my products?
Special Considerations or Warnings
Defect ID: 100915
Issue
Electronic Payment checks are not in sequence when Print G/L Distribution is checked.
Solution or Workaround
Target or Version Corrected: 4.50.6.0
None
Steps to Duplicate
Step to Duplicate: ABC Company,
Setting up ACH
1. Open Accounts Payable / Setup / Accounts Payable Options
2. Go to 'ACH' Tab and select the 'Enable ACH Electronic Payments' and 'Print Vendor Remittance Advice' checkboxes
3. Enter a path for the ACH Electronic Payment Folder and click Accept
4. Open Accounts Payable / Setup / ACH Interface Maintenance
5. Select Bank Code D from the lookup
6. Select the 'Pre-note Approved' checkbox and enter 123123123 in the Immediate Destination & Immediate Origin fields
7. Click on the 'Records' tab and enter the following
Service Class Code: 200
Standard Class Entry: CCD
8. On the 'Additional' tab, select the 'Include Debit Record' checkbox and enter 27 in the 'Transaction Code' field and enter the following numbers in these fields:
Receiving DFI Identification: 333333333
DFI Account Number: 55555555555555555
Individual ID Number: 777777777777777
9. Select ""Yes"" from the Set 'Put CR/LF after Each Record' dropdown and select the 'Include Addenda Record' checkbox
10. Click Accept
****Set up 2 ACH vendors.
1. Open Account Payable / Main / Vendor Maintenance
2. Click the Vendor Number lookup and select 01-AIRWAY
3. On 'Main' tab, select the Electronic Payment' checkbox
4. Click the More dropdown arrow and select Electronic Payment
5. In the Vendor Electronic Payment, enter or select the following and click Accept:
Bank Account No: 123456789
Routing Transit No: 123123123
Bank Account Type: Checking
Distribution Method: Percent of Net Amount
Percent Amount: 100%
Pre-Note Sent: Approved
Pre-Note Date: 05/01/2010
6. Click the Vendor Number lookup and select 01-ALLCLIM
7. On 'Main' tab, select the Electronic Payment' checkbox
8. Click the More dropdown arrow and select Electronic Payment
9. In the Vendor Electronic Payment, enter or select the following:
Bank Account No: 987654321
Routing Transit No: 123123123
Bank Account Type: Checking
Distribution Method: Percent of Net Amount
Percent Amount: 100%
Pre-Note Sent: Approved
Pre-Note Date 05/01/2010.
10. Click Accept and close Vendor Maintenance
*******Create new invoices and payment
1. Open Accounts Payable / Invoice Data Entry
2. If an 'A/P Invoice Batch' window appears prompting for a batch number, click the '#' button to obtain the next batch number. Accept
3. On the Invoice Data Entry screen enter the following:
Vendor No: 01-AIRWAY
Invoice No: Test001
Invoice Amount: $100.00
Lines Tab and select account 555-00-03.
In the Amount field, enter $100.00. Accept
4. Enter 2nd invoice as follows:
Vendor No: 01-ALLCLIM
Invoice No: Test002
Invoice Amount: $200.00
Lines Tab, G/L Account: 960-00-04
Amount field, enter $200.00. Accept
5. Print and update the Account Payable Invoice Register
6. Open Accounts Payable / Check Printing and Electronic Payment / Invoice Payment Selection
7. Change invoice due date to the due date on the invoices created above. Click on 'Select' button
Highlight invoice Test001 for 01-AIRWAY and invoice Test002 for 01-ALLCLIM
8. Click 'OK' button
9. Verify the 'Include Electronic Payment Vendors' is set to Yes and click Printer icon
10. Click 'Preview' and then close the Invoice Payment Selection Register
11. Click 'Yes' to ""Do you want to print checks and/or remittance advices?""
12. In the Select Payment type window, verify the Electronic Payment radial button is selected and click OK
13. On the Electronic Payment Remittance Advice Printing window check the ""Print G/L Distribution"" box.
14. Click Print and select OK to ""Remove your Stubs from the printer and replace with paper"" message and click 'Yes' to 'Do you want to print the Check and Electronic Payment Registers?""
15. Click 'Preview' button to view the Check Register
16. Note: Electronic Payment Check Numbers are not in sequence. A check number is skipped for every G/L distribution line.
17. Exit the Check Register and select No to ""Do you want to print the Electronic Payment Register?"" and No to ""Do you want to update the Check Register?""
18. Open Check Printing and Electronic Payment
19. On the Electronic Payment Remittance Advice Printing window do not select ""Print G/L Distribution"" box.
20. Click ""Print Stubs/Advices Already Printed"" box
21. Click Print and select OK to ""Remove your Stubs from the printer and replace with paper"" message and click 'Yes' to 'Do you want to print the Check and Electronic Payment Registers?""
22. Click 'Preview' button to view the Check Register
23. Note: Electronic Payment Check Numbers now in sequence.
Does this article apply to my products?
Products: Sage 100 Standard ERP [Sage ERP MAS 90]
Applications: Accounts Payable
Version Applicable: 4.50