Share
ReportHi,
We have a client who recently moved to GP from QuickBooks where they had 4 separate invoice forms. Now in GP they have to combine them into the one invoice (SOP Blank Invoice Form) so I created Doc IDs for the 4 types (the IDs are: Equipment, Invoice, Rental, and Waste). Now the trick is they want these names to print on the top right corner depending on which part they are using.
I created a few calculated fields and was able to get them to print but the problem is they're using Word Templates so I have to link these together into one Calculated field instead of the 4 I have so they do not print in different spots on the Template.
This is the chain of calculated fields I have so far that do print the correct name with the invoice:
First Calculation:
Name: Equipment
Result Type: String
Expressions Calculated: "Equipment Invoice"
Second:
Name: *Equipment
Result Type: String
Expression Conditional: COP_HDR_WORK.Document ID = "EQUIPMENT"
True: Equipment
False: ""
Third:
Name: **Equipment Test
Result Type: String
Expressions Conditional: SOP_HDR_WORK.Document ID = "EQUIPMENT"
True: *Equipment
False: ""
Fourth:
Name: ***Equip
Result Type: String
Expressions Conditional: SOP_HDR_WORK.SOP Type = 3
True: **Equipment Test
False: ""
I have them set up this way for all 4 Doc ID names I just used one for the example above.
Is there a calculated field to link all of these together so it is not 4 different fields?
I have not been able to figure this out.
*This post is locked for comments
All responses (
Answers (
3