Re-Printing old PO after its completion.

[ZABARVAN]

We tried to print an already completed PO but failed through all means, Is there any way to Print a completed PO....

Rg

Zab

 

[Jay Converse]

Only by customizing the form with Crystal Reports.

 

[ettienne]

The standard PO form will not reprint completed PO, you need to edit the report and remove the record selection criteria.

Sage 300 Certified Consultant

 

[ZABARVAN]

I didn't find any record selection criteria.... Can you please help with the same. what should be the record selection.

 

[ettienne]

Use POPOR04.RPT instead of POPOR01.RPT

Sage 300 Certified Consultant

 

[ZABARVAN]

Following is the selection criteria, please help which condition I have to modify...

Regards....



if {?SWDELMETHOD} = "1" then //Selection partly done in UI - sortto and sortfrom is the same
(
{POPORL.COMPLETION}=1 and
{POPORH1.PONUMBER} = {?PORFROM} and
(({POPORL.STPRINT}=0) OR (ToNumber({?DPRINTED})=1))
)
else // No selection in UI
(
{POPORL.COMPLETION}=1

AND ( (({POPORH1.PORTYPE} = 1) AND (ToNumber({?ACTIVE})=1))
OR (({POPORH1.PORTYPE} = 2) AND (ToNumber({?STANDING})=1))
OR (({POPORH1.PORTYPE} = 3) AND (ToNumber({?FUTURE})=1))
OR (({POPORH1.PORTYPE} = 4) AND (ToNumber({?BLANKET})=1)) )

AND ({POPORH1.ISPRINTED}=0 OR ToNumber({?PRINTED})=1)
AND ({POPORH1.PONUMBER} >= {?PORFROM})
AND ({POPORH1.PONUMBER} <= {?PORTO})
AND (({POPORL.STPRINT}=0) OR (ToNumber({?DPRINTED})=1))
AND ({POPORH1.ONHOLD} = 0) and
// if delivery method is 3, always select vendor
// else select vendors that have delivery method of mail
(
{?SWDELMETHOD} = "3" or
(
{?SWDELMETHOD} = "2"
and
{APVEN.DELMETHOD} = 0
)
)
)

 

[ettienne]

Comment out {POPORL.COMPLETION}=1

Sage 300 Certified Consultant

 

[ZABARVAN]

on selection of popor04, it is giving " ERROR ,load library'..... do we need to reinstall or some dll is missing....

 

[Jay Converse]

Comment out the DATAPIPE lines in PORPT.INI.

 

[ZABARVAN]

Shall I comment out following lines I found datapipes at lot of places..... which one I should search for....

[POHIST01]
type=DATAPIPE
..
..
..

datapipe query="potrhst.dll=ICTRHST\nY\n%ACCTMIN%\n%ACCTMAX%\n%ITEMMIN%\n%ITEMMAX%\n%YEAR%\n%PERIOD%\n%CALCBAL%\n"
datapipe path=..
Regards

 

[Jay Converse]

POPOR01

 

[ZABARVAN]

Commented out the COLPLETETION=1 but still printint blank... I modified selection criteria on popor04.rpt.

----------------- Modified the follwoing in popor04.rpt

if {?SWDELMETHOD} = "1" then //Selection partly done in UI - sortto and sortfrom is the same
(
//{POPORL.COMPLETION}=1 and ---jjj
{POPORH1.PONUMBER} = {?PORFROM} and
(({POPORL.STPRINT}=0) OR (ToNumber({?DPRINTED})=1))
)
else // No selection in UI
(
// {POPORL.COMPLETION}=1 and ---jjj

( (({POPORH1.PORTYPE} = 1) AND (ToNumber({?ACTIVE})=1))
OR (({POPORH1.PORTYPE} = 2) AND (ToNumber({?STANDING})=1))
OR (({POPORH1.PORTYPE} = 3) AND (ToNumber({?FUTURE})=1))
OR (({POPORH1.PORTYPE} = 4) AND (ToNumber({?BLANKET})=1)) )

AND ({POPORH1.ISPRINTED}=0 OR ToNumber({?PRINTED})=1)
AND ({POPORH1.PONUMBER} >= {?PORFROM})
AND ({POPORH1.PONUMBER} <= {?PORTO})
AND (({POPORL.STPRINT}=0) OR (ToNumber({?DPRINTED})=1))
AND ({POPORH1.ONHOLD} = 0) and
// if delivery method is 3, always select vendor
// else select vendors that have delivery method of mail
(
{?SWDELMETHOD} = "3" or
(
{?SWDELMETHOD} = "2"
and
{APVEN.DELMETHOD} = 0
)
)
)

 

[Jay Converse]

Keep at it. Don't forget that the quantity ordered in the data is now zero, so there may be some conditional formatting to adjust.

 

[ZABARVAN]

It prints nothing should print some text even without figures....

 

[Jay Converse]

Comment out everything in the selection formula except ({POPORH1.PONUMBER} >= {?PORFROM}) AND ({POPORH1.PONUMBER} <= {?PORTO})

 

[ZABARVAN]

Nothing ..... just blank sheet....

 

[Jay Converse]

Bummer

 

[ZABARVAN]

Thanks for your help....