Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Can you do conditional formatting of info onto a sales order/picking ticket?

Posted By C Lynch over 9 years ago

I have developed a UDF on the shipping address info to designate the FOB info specific to a ship-to address. On occasion we may have reason to override this. I would like to have our sales orders and picking tickets default the FOB from the ship-to address unless the FOB field on the order header has been filled in, at which point we'd like it to override the FOB default from the ship-to address screen. Is there a way to do this?

0 TomTarget over 9 years ago

This description assumes that you know how to use custom office to add the UDF to the printing work files.

Step #1 - Use custom office to add the UDF to the SO_Invoicewrk or SO_PickingSheetwrk file.

Step #2 - Open your form and do a verify database to pull in the UDF to the definitions in the crystal report.

Step #3 - Create a formula along the lines.

if len({SO_Invoicewrk.FOB})<>0 then {SO_Invoicewrk.FOB} else {SO_Invoicewrk.yourUDF}

Step #4 Place this formula in place of the existing FOB field on the form.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Can you do conditional formatting of info onto a sales order/picking ticket?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING