ADempiere Check Print Format with Too Many Remittance Lines

Hi Everyone,

In ADempiere and iDempiere, the default Payment or Check print format can span multiple pages if you have too many remittance lines. This situation causes a problem because your check numbers gets out of sequence for all subsequent checks.

An easy fix is to include a ‘Report View’ on the remittance print format that returns no remittance results when the number of remittance line exceeds a certain value.

UPDATED NOTE: the below fix works if you only use one language. A better solution is described here.

Here are the steps:

1. Log in using System Administrator role.
2. Create a report view for the C_PaySelection_Remittance_v table.
3. Add the this text to the Report View where clause: ((SELECT count(*) FROM c_payselection_remittance_v remit WHERE remit.c_payselectioncheck_id = c_payselection_remittance_v.c_payselectioncheck_id)< 8)
4. Log in using the Admin Role (example: Gardenworld Admin).
5. Create a copy of your original Remittance Line print format (RemitV2), and add the newly created Report View to the Print Format.
6. Update your check print format to include the newly created RemitV2.

Now, when you print a check that exceeds the limit in your report view, your check will no longer print the remittance. Here are some simple steps to make the process even better:

1. Update the Check print format to show the total remit count.
2. Update the Check print format to say “See Remittance Report” when the limit is exceeded.
3. Create a remittance report that only shows the remittance for checks that exceed the limit.

The sky’s the limit for what you can do during the check print process. Let me know if you would like help formatting your checks or any document to display exactly how you want.

I hope this helps!!!

Please note that ADempiere, iDempiere and Openbravo are forks or copies from Compiere. Therefore, they have similar abilities mentioned above. The biggest difference is that ADempiere and iDempiere are pure open source. There are no features held behind a commercial or paid license.