Check Print Layout in Crystal

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hey Rahul,

I don't see any number of copies options under print preferences either on the general tab or the per document tab for the check print layouts. It's not a problem with the query because the print preview comes out as a single page. However, when I try to print preview in SAP, two separate windows open printing the same check.

The customer will want to use the document printing window in Sales A/R, but for now I'm simply testing hitting the print preview button while the check for payment window is open.

Do you have any other suggestions of what could cause this? I'm running 8.81 PL04. I thought maybe the problem was related to the tokens I'm using to connect Crystal to SAP.

Thanks,

Kevin

[Former Member · Accepted solution]

Hi Kevin.......

When you go to Print Preference there in Per Document Document you find one Tick Box called Print Document

Tick that box and And check the No. of Copies.......

Regards,

Rahul

[Former Member · Accepted solution]

Hey Rahul,

That option exists for most documents, but not for the check for payment.

Thanks,

Kevin

[Former Member · Accepted solution]

Hi Kevin......

Check this out.

When you select Checks for Payment in Dropdown then you are right the option for No. of copies does not appear but when you select Checks for Payment Option some options enabled under Print On and one of them is Check Stock and the moment you select this option you get two more radio button and select Overflow Blank Paper and you can find the No. of Copies Option.

Please check here.......

Also please check the same in Sales AR > Document Printing> Checks for Payment in Dropdown and No. of Copies exactly at the bottom of this window....

Regards,

Rahul

Edited by: RAHUL MOUNDEKAR on Sep 20, 2011 9:53 PM

[Former Member · Accepted solution]

Hey Rahul,

Thanks! You are right. When I opened this up I saw that the number of copies was set to 2. However, after changing it to 1, it doesn't seem to have affected the extra copy of the check when I print preview.

Any other ideas?

Thanks,

Kevin

[Former Member · Accepted solution]

Hi Kevin....

And What about the No. of Copies in following Path?

Sales AR > Document Printing> Checks for Payment in Dropdown and No. of Copies

Please check and once you do just restart SAP........

Regards,

Rahul

[Former Member · Accepted solution]

Hey Rahul,

I've checked both places, they were both set to 1. I restarted SAP but the issue remains.

Thanks,

Kevin

[Former Member · Accepted solution]

Then Last Option.

Check your Printer Setting. Is that defaulted to more than 1 Copies?........

Also Please Open PLD (Print Layout Designer) and Check the No. Of Copies for Print under Document Properties.

Regards,

Rahul

[Former Member · Accepted solution]

Hey Rahul,

No, the printer is not set to print more than one copy. We do not get this problem with any other layout. We are currently using Crystal Reports, not the PLD.

Thanks,

Kevin

[Former Member · Accepted solution]

Then Check in Report and Layout Manager under Administration> Setup> General--> Report and Layout Manager.

Open it for Check for payment and check in this window.....

Regards,

Rahul

[Former Member · Accepted solution]

Hey Rahul,

The number of copies in this window is also set to 1....

I've double checked everything, I don't understand what could be causing this.

Thanks,

Kevin

[Former Member · Accepted solution]

Do your users have any defualt groups set against them? Number of copies can be set in here as well?

[BattleshipCobra]

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

[Former Member]

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)

[Former Member]

Hey all,

Thanks for the input, unfortunately none of these seemed to help. However, after further testing I believe that this is a bug in SAP. When I try to print the check using document printing, I get an error message that says "Missing parameter values". This is the same error that is described in SAP note 1466274.

I'm using SAP 8.81 PL04 so I expected that this bug would have been resolved, but the print layout is rock solid. I've tested it directly against the SQL database and there are no problems. It only prints a single page. The duplication occurs on the print level, not on the page level and only when I choose the Print Preview button. If I print from the check for payment window, it seems to work alright. However, print preview or printing from document printing causes errors or duplication.

I am logging this issue with SAP for additional support.

Thanks again!

Kevin

[Former Member]

Hey guys,

I have some new information. After investigating this issue in other databases, we did not replicate the same issue. We now believe that this issue is related to functionality unique to having multiple currencies or operating in a Canadian localization.

When we run the document printing wizard, we get an error from Crystal saying that there is a missing parameter. I believe that this is a missing token, but I cannot figure out what that token should be. I've already included DocKey@ and ObjectID@ which is good enough to work on a US localization database, but there must be another token which I am unaware of.

After double checking the query produced by this report, it produces only a single record.

Does anyone know of additional tokens beyond the DocKey@r ObjectID@ that may be essential to a check print layout?

Thanks,

Kevin

Edited by: Kevin Lee on Oct 4, 2011 8:25 PM

[Former Member]

The cheque layout I am using uses only dockey, the objectid is not necessary for this I think?

[Former Member]

Thanks for the suggestion. I tried this out, but I get the exact same results. I think there is an additional token that is not being included that should be given the Canadian localization or multicurrency.

Thanks,

Kevin

[Former Member]

Kevin,

Were you able to figure out a solution to this problem? Please let me know as I have the exact same issue.

I'm on 8.82 PL 04 US localization

Thanks

[Former Member]

Hi,

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

Thanks.

Clint

[Former Member]

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