freight pay code

[randva]

Macola 7.5.102e; Pervasive

Is it possible to add a "T" as a freight_pay_code and a literal to print on an order header that says "3rd Party Bill"? If you have done this, are you willing to share?

Thanks in advance for any advice.

 

[maccrystal]

Use designer and change a OE header UDF to hold the values. Then change forms to use this field instead to the freight_pay_code.

http://www.appstratinc.com

 

[fullonpbod]

We had done for us precisely what you request. Using designer, "UnHide" the Col/Ppd field on the Basics tab. Right-click this field and choose "values". Then type what you wish in list form. We use:
C=Col
P=Ppd
T=3rdParty
A=Ppd&Add

We do not use "Project" so we have hidden that field to make room for the frt_pay_cd on the Basics tab.

Then on our Crystal Pick tickets and Invoices, we use the following:

if {OEORDHDR_SQL.frt_pay_cd} = 'P' then 'Prepaid' else
if {OEORDHDR_SQL.frt_pay_cd} = 'C' then 'Collect' else
if {OEORDHDR_SQL.frt_pay_cd} = 'A' then 'Prepaid & Add' else
if {OEORDHDR_SQL.frt_pay_cd} = 'T' then 'Third Party' else ' '

 

[randva]

Thank you fullonpbod!

Your suggestion worked fine. I found it was necessary to modify the OE Order Entry screen for every user. (We use a Macola form for our orders, so we can only print out the first letter - but I think it will work for us.)

Thank you for your assistance.

 

[abaldwin]

Just a suggestion but if you have a modification to a Macola form and you want to make it the same for all users you can copy the form in designer to a user called MACOLAED and then modify it. This in effect makes it the "default" form for ALL users in the system. That way you only have to maintain one version of the form and not have to modify 100 copies of the form everytime you make a change or remember to copy the form when you add a new user.



Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[crystalreporting]

Andy is spot on - the MACOLAED screenset makes life much easier when you have a global change that you want all users to get. However, to be 100% accurate - you can't modify the MACOLAED screenset - you must make your changes to another screenset (SUPERVISOR for example) then copy that screenset to MACOLAED.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.srhconsulting.com

 

[dgillz]

Also to expand on Andy's and Peter's comments, if the individual user does have a modified screenset, Macola will use it first, then MACOLAED, then the unmodified original. So if you want to use the MACOLAED model, be sure to delete the individual user's screensets as well.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?