Dot matrix printing on 15 x12 inch paper

[Former Member]

Hi

I have created report for purchase register

Report is so large to print

so i have desiged this report in PDL for dot matrix printer and paper size 15 inch x 12 inch.

When i going to print this report, i not get proper print out

Please tell me the setting regarding to print this report on dot matrix 15 x 12 inch continous paper.

Regds

Kishor

[former_member583013]

Kishor,

I have already suggested all the possible setting checks I could think of. Please make sure that the dot matrix printer you are using is supported by SAP Business One.

Supported Dot Matrix Printers

SAP Business One supports the following models of dot matrix printers:

<li> Citizen PROdot 300

<li> Epson FX-880

<li> OKI MICROLINE 320 Elite

Suda

[Former Member]

HI

Thanks for you valuable suggestion

Printer at my end is not supported by SAP B1

ok

what is use of Function grouplinenum() in PLD

I wants the follwing output

docnum, Acct Code, Acct_total document_total

1 xyz1 500 1100

xyz2 600

2 abc1 1000 2000

abc2 500

abc3 500

-

---

Total 3100 3100

Please study the following query for above and Please tell me it is possible to design PLD

SELECT A.SERIESNAME, A0.DocType, A0.DocNum, A0.DocDate, A0.NumAtCard, A0.TaxDate,

A0.CardCode, A0.CardName, A1.City,

A2.TaxId11, A2.TaxId1, A2.TaxId2,

A4.TAXTYPE, A4.VATRATE, A4.vattaxable, A4.Totvat,

A0.DOCTOTAL, A0.WTSUM,

A5.TAXCODE, A5.formatcode, A5.ACCTNAME, A5.ACTOTAL,

(case when TAXTYPE IS NULL then A0.DOCTOTAL + A0.WTSUM ELSE 0.00 END) AS LabourChrg,

(case when TAXTYPE IS NOT NULL

then A0.DOCTOTAL + A0.WTSUM - ISNULL(A4.VATTAXABLE, 0.00) - ISNULL(A4.TOTVAT, 0.00) ELSE 0.00 END) AS LabourChrg

FROM NNM1 A

INNER JOIN OPCH A0 ON A.SERIES = A0.SERIES

LEFT OUTER JOIN CRD1 A1 ON A0.CARDCODE = A1.CARDCODE AND A1.LINENUM = 0

LEFT OUTER JOIN CRD7 A2 ON A0.CARDCODE = A2.CARDCODE

LEFT OUTER JOIN

(SELECT C0.DOCENTRY,

MAX(case when C1.nftaxid = -7 then 'L' when C1.nftaxid = -4 then 'C' else 'O' end) as TAXTYPE,

MAX(C0.TAXRATE) as VATRATE, SUM(C0.TAXSUM) as TOTVAT, SUM(C0.BASESUM) as VATTAXABLE

FROM PCH4 AS C0, OSTT AS C1

WHERE C1.ABSID = C0.STATYPE

AND C1.nftaxid in (-7, -4)

GROUP BY C0.DOCENTRY) A4 ON A0.DOCENTRY = A4.DOCENTRY

INNER JOIN

(SELECT E0.DOCENTRY, E0.TAXCODE, E1.formatcode, E1.ACCTNAME, E0.ACTOTAL

FROM

(SELECT D0.DOCENTRY, D0.TAXCODE, ISNULL(D1.ACCTCODE, D0.ACCTCODE) AS ACCTCODE,

SUM(D0.LINETOTAL + D0.LINEVAT + D0.DISTRIBSUM + D0.STCKDSTSUM) AS 'ACTOTAL'

FROM PCH1 D0 LEFT OUTER JOIN PDN1 D1

ON D0.BASEentry = D1.DOCENTRY AND D0.BASELINE = D1.LINENUM

GROUP BY D0.DOCENTRY, D0.TAXCODE, ISNULL(D1.ACCTCODE, D0.ACCTCODE)) AS E0

INNER JOIN OACT E1 ON E0.ACCTCODE = E1.ACCTCODE) A5

ON A0.DOCENTRY = A5.DOCENTRY

WHERE A.SERIESNAME ='[%0]'

ORDER BY DOCNUM

Thanks

[former_member583013]

Kishor,

grouplinenum() is used to print the line number of the item within the group instead of its line number in the original result set.

Read this document to understand how sort and group by works in PLD

https://websmp109.sap-ag.de/~sapidb/011000358700000208072007E/CW11_LOG_PLD.pdf

Also, there are a few recorded Webex sessions that you could look at https://websmp208.sap-ag.de/smb/education Click on Expert training sessions.....Archive EES ...Print layout designer

.

Suda

[former_member583013]

Please make sure if you have the following settings.

In the PLD Properties (Open PLD go to Print layout designer menu on top ....Display document properties)

On the Paper format tab > make sure the Dot matrix printer is selected.

The Paper Format should be select from one of the available choices for this printer

Check that you do not use any fancy fonts. Just use one standard font.

Save

Check this and let me know

Suda

[Former Member]

Hi

I am trying this setting but i not get proper printout.

The printout get shinked here

I useing draft 10cpi font for this document

Second query is

i want to group this report on document number and each doucment have many items .

I want to numbering the item like 1, 2, 3 for each document

Please guide me

Narendra