Skip to Content
author's profile photo Former Member
Former Member

Check Print Layout in Crystal

Hey guys,

My client had asked for a simple customization to the check print layout which was not possible via the Print Layout Designer. To resolve this, I recreated the check in Crystal Reports. This solution has worked out really well except that when the check is printed, it prints the check two times. I can't determine the cause of this duplication as it does not appear to be affected by any settings in Crystal or in Business One. I'm using two tokens: DocKey@, and ObjectID@. These seem to be working correctly.

The only complication that I can think of is that I've had to connect the address table (CRD1) in order to pull in the address in pieces as the client needed. I've linked the vendor code, and address name, and created a record selection to only return results where CRD1.AdresType = 'B'.

Does anyone have any idea what can cause this type of duplication?

Thanks,

Kevin

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 16, 2011 at 02:08 AM

    Hi Kevin..........

    Check printing two times means is it showing same record two times in the same check or it is printing two time one by one on two different pages?

    If first possibility then please check your Query for Crystal report used for Check Printing.

    For Second Possibility please check the Document Printing in Sales AR or Print Preference option in Administration--> System Initialization and check No. of Copies for Check Printing by selecting check under Per Tab Dropdown......

    Regards,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 16, 2011 at 09:40 PM

    Hi,

    You can try running the query first if the result have 2 values.

    Please try also check the printer settings and set the Printer quality to the highest value.

    Thanks.

    Clint

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2011 at 04:25 AM

    hi kelvin,

    I found one solution for Duplicate problem. In sap, one customer has more than one address. If customer has multiple address, duplicate problem will occur coz of relationship. Please check the customer code you want to filter. I think it has multiple address. You can use the the following script to check it.

    select * from ocrd where card code='----


    '

    select * from crd1 where card code='----


    '

    If my thought is right, you need to fix this problem. I solved this problem by setting standard address of customer.

    If you have any question, please let me know.

    zzymt (myanmar)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2011 at 01:08 AM

    Hi,

    Did you printing without the link address lets try if that cause of the problem.

    Thanks.

    Clint

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 17, 2014 at 04:05 PM

    Here's a Crystal Reports check / cheque layout you could start with: Crystal Reports Check / Cheque Layout for SAP Business One - YouTube

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.