Solution Properties
Solution ID:
223924550037367
Last Modified Date:
Mon Nov 21 17:54:25 UTC 2022
Taxonomy Path:
Category//Reporting//Printing//Email
Author:
legacyauthor
Multiple invoice payments cause overlap on the stubs
Description

This may appear as the following messages:

  • Error: "The cheque cannot be printed because there are more than 36 transactions on it."
  • Error: "There are more than 24 detail lines to be printed on this cheque stub. Some details may overlap or not appear when print."
  • Message: "There are more than 36 detail lines to be printed on this cheque stub. Some details may overlap or not appear when printed. Do you wish to continue?"
Cause
  • By default, Sage 50 forms and pre-printed setting have a limit of 36 invoices for a single payment or receipt due to Canadian Payments Association standards and program font size limitations.
Resolution

Workaround 1: Customize the cheque stub with a longer first stub

  1. If you have a custom cheque already, go to Step 3.
  2. If you don’t have a custom cheque, you can follow Step 1 and Step 2 in article How to customize forms to modify text, data, images or add a company logo. After customizing, proceed to step 4.
  3. Open Sage 50 Forms Designer for the cheque.
  4. Click the Stub Options button to change it from two stubs to one stub.
  5. Manually expand the length of the first stub column.
  6. Click File, Save as assign a unique name.

Workaround 2: Customize the Receipt with a longer first stub

  1. Select Setup, Reports & Forms, Receipts.
  2. Select Custom Forms.
  3. Under Description, select Receipt.
  4. Click Customize Form to open the Sage 50 Forms Designer.
  5. Click on Stub Options button (located in the right margin) and change it to One stub.
  6. Remove the footer and total information fields from the middle of the receipt by clicking on the field (surrounded by black dots) and pressing Delete on the keyboard.
  7. Manually expand the length of the first stub column by clicking the field and dragging the bottom line down.
  8. Click File, Save As. Assign a unique name and save outside of the Forms folder.
    • We recommend creating a folder for your custom forms.

Workaround 3: I would rather print in two or more parts

  1. Create a payment cheque with all invoices selected.
  2. Print but do not post (process) the payment.
  3. Create two (or more) payments each with the maximum of invoices allowed (36).
    • Rename the cheque number to add an extra letter, such as '435a' where 435 is the cheque number of the one you printed, and the letter is sequential based on how many payments you need to do
    • Print these payments so that you have stubs
  4. Each payment stub (from the previous Step only; 3.) can then be included to the single cheque.
  5. Please note that your bank reconciliation will be off due to the single cheque is the sum of the posted multiple payments.
    • The cheque number with the letter reference will be useful for you in this regard.
[BCB:159:Chat 50 CA English:ECB]
Steps to duplicate
Related Solutions