Solved

Printing from Exact Financials to Xerox ColorQube not working correctly

Posted on 2014-11-04
7
238 Views
Last Modified: 2014-11-11
Dear experts,

I've been busting my head lately because of this problem.
What I try to achieve is to print the invoices from Exact financials to the Xerox machine.

Everything seems fine when I print only one invoice.  I can get it to print to the machine, tray 2 and a nice invoice comes out.

But when I try to print for example 20 invoices, the address on each invoice is moving up a little. I thought it must be something in the INIT-string but I've tried several things but nothing is working.

In the attachments you'll find a screenshot of the settings that are working fine except when I print more than 1 invoice.

Thanks in advance,

Len
Exact-universal.PNG
0
Comment
Question by:KNBsysteembeheer01
  • 3
  • 3
7 Comments
 
LVL 16

Assisted Solution

by:DansDadUK
DansDadUK earned 500 total points
ID: 40423712
I've no knowledge of Exact Financials, or Xerox ColorQube, just a few comments on the PCL strings defined in the dialogue in the screenshot.

The 'Init' string:
<Esc>E            Printer Reset
<Esc>9            Clear Horizontal Margins
<Esc>&l1o         Orientation: Landscape
       6d         Line Spacing (6 lines-per-inch)
       3E         Top Margin (3 lines)
<Esc>(10U         Primary Font: Symbol Set (10U = PC-8 Code Page 437)
<Esc>&l0S         Simplex/Duplex: Simplex
<Esc>&l4H         Paper Source: id 4 is Printer Dependent

Open in new window


does not include any sequence to select a Paper Size, so the printer will use its default size - but this may not be the same as that assumed by the Exact Financials application?

The 'end' string:
<Esc>E            Printer Reset

Open in new window


The 'CPIn' strings:
<Esc>(10U         Primary Font: Symbol Set (10U = PC-8 Code Page 437)
<Esc>(sp          Primary Font: Spacing: Fixed
       10h        Primary Font: Pitch (10 characters per inch)
       12v        Primary Font: Height (12 points)
       s          Primary Font: Style (Upright, solid)
       3b         Primary Font: Stroke Weight: Bold
       3T         Primary Font: Typeface (3 = Courier (base value))
<Esc>&k23H        Horizontal Motion Index (23/120 inches)

Open in new window


<Esc>(10U         Primary Font: Symbol Set (10U = PC-8 Code Page 437)
<Esc>(sp          Primary Font: Spacing: Fixed
       10h        Primary Font: Pitch (10 characters per inch)
       12v        Primary Font: Height (12 points)
       s          Primary Font: Style (Upright, solid)
       b          Primary Font: Stroke Weight: Medium
       3T         Primary Font: Typeface (3 = Courier (base value))
<Esc>&k11.5H      Horizontal Motion Index (11.5/120 inches)

Open in new window


<Esc>(10U         Primary Font: Symbol Set (10U = PC-8 Code Page 437)
<Esc>(1O          Primary Font: Symbol Set (1O = OCR-B)
<Esc>(s0p         Primary Font: Spacing: Fixed
       10.00h     Primary Font: Pitch (10.00 characters per inch)
       12.0v      Primary Font: Height (12.0 points)
       0s         Primary Font: Style (Upright, solid)
       0b         Primary Font: Stroke Weight: Medium
       110T       Primary Font: Typeface (identifier = 110)

Open in new window


<Esc>(10U         Primary Font: Symbol Set (10U = PC-8 Code Page 437)
<Esc>(sp          Primary Font: Spacing: Fixed
       12h        Primary Font: Pitch (12 characters per inch)
       14v        Primary Font: Height (14 points)
       s          Primary Font: Style (Upright, solid)
       b          Primary Font: Stroke Weight: Medium
       3T         Primary Font: Typeface (3 = Courier (base value))
<Esc>&k11.5H      Horizontal Motion Index (11.5/120 inches)

Open in new window


select different fonts and character spacings.

Note that typeface 3 is a 'base' typeface selector, used in (much) older generations of PCL printers, although it  should still work on current generation PCL printers.
And typeface 110 is not a standard one on LaserJet printers, so not sure what this will select; the symbol set selected is associated with OCR-B, and this is also not provided as standard on LaserJet devices.
I don't know of the ColorQube supports these via a model-specific printer-resident font; if not, then the printer will attempt to provide what it considers to be the closest match to the provided characteristics,
0
 
LVL 38

Expert Comment

by:Herman D'Hondt
ID: 40425789
You did not specify which model ColorQube you have. They cover quite a range of different printers.

Xerox do provide PCL manuals for their products. They may help you trace the cause of the problem. Some of the manuals are at the following links:

CQ 8700/8900:
download.support.xerox.com/pub/docs/CQ8700/userdocs/any-os/en_GB/ColorQube_8700-8900_PDL_Guide.pdf

CQ 9201/9202
www.office.xerox.com/support/dctips/dc09cc0451.pdf

These manuals are very hard to find on Xerox' website. The easiest way to find them via Google. I found these by searching for:
pcl command site:xerox.com colorqube
0
 
LVL 16

Expert Comment

by:DansDadUK
ID: 40425853
With the information provided so far, we're just guessing at the reason for the reported symptoms.

What would be better (IF your application allows it) would be to provide a 'capture' of the output of a multi-invoice sample (using 'sanitised' data), like that provided by the 'Print to file' option in the Print dialogue of standard Windows applications.

Analysis of the resultant .prn file may very well show what the problem is.

You could post it here, or do the analysis yourself, using the PRN File Analyse tool in the PCL Paraphernalia application, available via http://www.pclparaphernalia.eu
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:KNBsysteembeheer01
ID: 40425859
here you find a capture with the use of print to file.
exactcs.txt
0
 
LVL 16

Expert Comment

by:DansDadUK
ID: 40425965
Not sure just what you've captured; a few comments based on (attached) analysis:

The captured data starts with an odd control-code character: Device-Control-2 - decimal code 18, hexadecimal 12, usually referred to as <DC2>.
The captured data shows no sign of the sequences defined in your 'init' or 'end' strings.
The data contains (once on each page) invalid PCL sequences (<Esc>*(s3B) which should probably have been <Esc>(s3B, intended to select a Bold variant of the current Primary font (whatever that is).
The text 'KOPIE FACTUUR' on each page is preceded by an orphan Escape character (decimal code 27, hexadecimal 1b), usually referred to as <Esc>
The pages are separated by Form Feed control-code characters (decimal code 12, hexadecimal 0c), usually referred to as <FF>.
Vertical spacing is achieved via use of multiple Line Feed control-code characters (decimal code 10, hexadecimal 0a), usually referred to as <LF>.
Horizontal left-edge is achieved via use of Carriage Return control-code characters (decimal code 13, hexadecimal 0d), usually referred to as <CR>; this will move the PCL cursor to the current left-margin (whatever that is set to) on the current line.

If I send the contents of the file to my local LaserJet 1320n printer (which holds A4 paper (physical size 297 x 210 mm, printable area is usually about 4-6 mm less than this all round):

Pairs of pages are printed.
The first page of each pair contains data (with the 'KOPIE FACTUUR' line in the same relative horizontal and vertical position on each page; some data on the right-hand edge is missing, as A4 paper is only 210mm wide.
The second page of each pair is blank; i think this is because the number of lines (including trailing blank Line Feed  lines on each input page moves the PCL cursor past the bottom of the paper (or past the perforation-skip limit).

What paper size is the report designed for?
... and what paper size is in use on your printer?

It's possible (I don't know) that the (unexpected) <DC2> character at the start is being interpreted (on your printer) as data, and pushing the head of page down (on the first page only)?
exactcs.prn-analysis.txt
0
 

Accepted Solution

by:
KNBsysteembeheer01 earned 0 total points
ID: 40426027
I've found it! It had something to do with the driver. I installed another driver. Then the lines didn't shift anymore.

Thanks guys for your replies and help.
0
 

Author Closing Comment

by:KNBsysteembeheer01
ID: 40434607
I've found it myself by experimenting with several drivers for the machine.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This seems to be a very common error related to the Samsung printer driver. First, this is the error we're talking about: Log: System Type: Error Event: 7000 Agent Time: 3:37:24 am 22-Apr-09 Event Time: 6:07:24 pm 21-Apr-09 UTC Source: Se…
If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now