Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Dynamic header information on invoices

Dynamic header information on invoices

Dynamic header information on invoices

I'm looking for some guidance or opinions on invoices.

We have a DBA which sells a limited set of our inventory, and we want invoices for customers of this DBA to reflect the DBA information instead of the main company information. Every customer of this DBA will be a specific customer type, so I am thinking that based on the customer type, via Crystal I can change which Page header (or information in the Page header) is displayed on macoeinvfrm.rpt.

Has anyone tried this, or does anyone know if there is a better way to do this?

RE: Dynamic header information on invoices

Yes, add additional page header sections as needed to accommodate the DBA. You can even add the logos. Then conditionally suppress or display the old and new page header sections based on customer type. Customer type may not be in the set of fields currently passed to the macoeinvfrm.rpt, but you can add the arcusfil_sql view to the report and get to that piece of data.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:

RE: Dynamic header information on invoices

Don, Thanks for your reply. I did exactly that. I joined arcusfile_sql to the report via cus_no, added a page header, and wrote a suppression formula in the header if the customer type is not of a specific type. I haven't tested because I have been away from the office, but will be doing the same to quotes, then testing them all out.

Thanks again for your reply!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close