Unable to Autoprint the Crystal Report in Sage X3 from web application

Posted By Stacey Orrock over 2 years ago

We are creating Sales delivery from web application(Source code Java) into Sage X3 using Soap web services which is succesful. At the same time We are trying to autoprint the delivery crystal report after creating delivery in Sage X3 for which code was written in APRES_CRE action to call the crystal report.

I can see the log in X3 where it shows print configuration but from the document is not printing

Can someone please help me out whether there would be any setup to print the report from outside of Sage X3?

Thanks

Stacey

Top Replies

Benjamin Eich 3 months ago in reply to GHARIB mohammed +2

Hi GHARIB mohammed Unfortunately, I didn't find the ultimate answer/solution. In my case I found out that the print server itself was causing the problem. Depending on the count of pending jobs in the printer…

Parents

0 Fariss over 2 years ago

Hi Stacey,

We do the same thing.

in APRES_CRE action:

1- We validate the delivery before printing the document

Gosub AVTBOUT_VAL

If GERR=0
Call VALIDATION([F:SDH]SDHNUM) From TRTVENLIVV
Endif

2- We print the CR document

Gosub INIT_ETAT From TRTX3ETA

WARP_NBRCPY=1

WARP_RPTCOD(0)="Your CR document"
WARP_NBRCPY=1
GYEXPL=1
Call ALIM_ETAT(1,WARP_NBRCPY,WARP_RPTCOD,WARP_NUMREQ,WARP_NUMLIG,WARP_SEQREQ) From TRTX3ETA
Call PRINT_ETAT (1,WARP_NUMREQ,YDESTINATION) From TRTX3ETA

I hope that helps
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Fariss over 2 years ago

Hi Stacey,

We do the same thing.

in APRES_CRE action:

1- We validate the delivery before printing the document

Gosub AVTBOUT_VAL

If GERR=0
Call VALIDATION([F:SDH]SDHNUM) From TRTVENLIVV
Endif

2- We print the CR document

Gosub INIT_ETAT From TRTX3ETA

WARP_NBRCPY=1

WARP_RPTCOD(0)="Your CR document"
WARP_NBRCPY=1
GYEXPL=1
Call ALIM_ETAT(1,WARP_NBRCPY,WARP_RPTCOD,WARP_NUMREQ,WARP_NUMLIG,WARP_SEQREQ) From TRTX3ETA
Call PRINT_ETAT (1,WARP_NUMREQ,YDESTINATION) From TRTX3ETA

I hope that helps
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Stacey Orrock over 2 years ago in reply to Fariss

Thanks so much for your reply

Currently we are using the below code in Sage X3 to autocall the crystal report while delivery is created from an external web development.

Local Char TBPAR(30)(1..100),TBVAL(30)(1..100)
[L]TBPAR(1) = 'DeliveryNumber'
[L]TBVAL(1) = [M:SDH0]SOHNUM
[L]TBPAR(2) = 'CustomerCode'
[L]TBVAL(2) = [M:SDH0]BPCORD
# To auto print the report from other System
Call ETAT("Report Code","Destination","ENG",0,"",TBPAR,TBVAL) From AIMP3

It was working in PU9 and failing in V12

we can see log as well after creating the delivery, but there is no output to printer

...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Benjamin Eich over 1 year ago in reply to Stacey Orrock

Hi Stacey Orrock

Have you ever received a reply since then? I'm currently struggling with the same behaviour, code does not throw any exception but there is no output. It's too bad that this "community" isn't a little bit more alive :-\

I hope you could solve your print issue in the meantime.

Best regards, Benjamin
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 GHARIB mohammed 3 months ago in reply to Stacey Orrock

Hi BENJAMIN EICH

I'm currently struggling with the same problem

if you did solve this ,could you please assist me
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Benjamin Eich 3 months ago in reply to GHARIB mohammed

Hi GHARIB mohammed Unfortunately, I didn't find the ultimate answer/solution. In my case I found out that the print server itself was causing the problem. Depending on the count of pending jobs in the printer queue, some print jobs just randomly never got printed (without any error in any log I know). This problem still exists until today...
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 GHARIB mohammed 3 months ago in reply to Benjamin Eich

Thank you BENJAMIN EICH for the feedback
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

Unable to Autoprint the Crystal Report in Sage X3 from web application

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING