Would anyone have any idea how I can create and ed...
# advancedpdf
m
Would anyone have any idea how I can create and edit one central field (basic text) to display on all Advanced PDF Invoice templates? Kinda like a companyinformation field
It's really just to list basic upcoming price increase notifications and i want another user to be able to edit the contents ongoing
m
Customization > List/Records/Fields > Other Record Fields > New
1
in the record type choose Company
(unless you have subsidiaries, then choose Subsidiary)
The field will appear on each subsidiary record
OR if you choose company it will show up under Setup > Company > Company Info
THen you can use this field on all your ADV PDF templates
either as ${companyinformation.custfield1} OR ${subsidiary.custfield1}
m
Awesome thank you. Looks like I’ll need to give that trusted employee access to Company Info section
Are you aware of any other central locations that isn’t necessarily tied to the company info section?
m
Yes, we can do a "hack" with a custom record too
but it's kind of involved
Do you have subsidiaries enabled in your account?
m
no subsidiaries 🙂
m
For the custom record to work we need to add some list/record field that will have a consistent value that is the same as all your invoices
I'm thinking Currency
but are your price change notifications specific to any segment? Like you would send different text based on different locations? Or classes? or anything?
But let's assume we will use Currency as that is probably most consistent for you. Here are the steps 1. Make a custom record (Customizations > Lists/Records/Fields > Custom Record Types > New) 2. Call it "Price Update Text" (or whatever you want) 3. Uncheck Include Name 4. Uncheck Show ID 5. Keep whatever other settings you want (probably don't need Mail Merge or Attachments) 6. After you save this add 2 fields to this custom record. 1 called "Text" or "Message" (make this a Text Area field) 1 called Currency (make this a list record field and choose Currency as the list) 7. After you save this go and create 1 instance of this new record. In the text field enter "Test Message" (or wahtever message you want) 8. Set the Currency to USD (assuming all your invoices are in USD) 9. Then make a saved search based on your new custom record type. 10. In the criteria set "Inactive = FALSE" 11. In the results add your Message Field with a Summary Type of Maximum 12. In the avialble filters add your Currency field 13. Make it public and save the search (give it a name like Price Change Update Text for ADV Tempaltes) 14. The results of this search should just be 1 single summarized value which should be your Message 15. Create a custom transaction body field 16. Name = PDF Price Message 17. Type = Text Area 18. Store Value = FALSE 19. Under Validating and Defaulting tab choose your saved search you just made in the search field. 20. Then choose Currency in the FIeld Field.
image.png
Then update your ADV PDF template to include this new transaction body field wherever you want it shown
Then give your person access to just this 1 custom record type and they can update it anytime
just type in the new message in the same message field
With this method you can also do fun things like 1. Create an "effective date" so they can add a new pricing message but make it effective at some date in the future, but adding more criteria to your saved search 2. Show different pricing messages based on Invoice segments/classifications/customers/customer types/customer categories
Let me know if you have any quesitons
m
amazingly detailed! thank you so much. my only snag at this point is we don't have multiple currencies enabled either. do you think there's anything else consistent?
m
I think the criteria for using a summary search to source a field value is that it needs to have at least 1 filter
Maybe instead of adding the currency field
just add 1 field to the customer record called "message"
then in your saved search maybe add "date created" as the filter?
And just skip the whole currency idea
and don't add anything in the field field at this point when you make the custom field
It might work...but I really feel that it needs some sort of list/record field as a filter on the saved search to work
Actually do you need to save historcial price change messages?
m
no need to save historical, no
m
So for instance if the price change message said "12345" on 3/31/25 but then changed to "9876" on 4/1/25. If you go back and print an invoice created on 3/30/25 do you need it to say 12345 or 9876
m
9876 is fine. we email pdfs of the invoices to customers each delivery so that's a hardcoded date if we need to reference it for some reason
m
ok
then try the date created filter like i mentioned and remove/skip everything i said about currency for now
if the field doesn't display a value when you view the invoice then you know it didn't work
I can try to think of another list field to use. (if we need to we can always make our own, just for this purpose, but it's kind of "wasteful" lol)
m
damn i really thought this was going to work but i'm getting a blank value on the template. the saved search itself returns a value. i used Internal ID as the filter so it would appear as in the saved search list for the body field
come to think of it i do something similar for printing an item quantity on forms
m
Do you want to give this person access to edit custom fields?
m
this particular field yes, but i can be all if it has to be
i can see the saved search being executed by -System- when I refresh an invoice record but it just won't return the result
and I can generate an error when i select a Filter it doesn't like
oops just got it
had to use Internal ID (Number), not just Internal ID
so with that in mind, thank you very much! i would never have thought to use this method
eyeing off a few of your bundles too 😉
m
oh, thanks....let me know if you have any questions about any of them
🙏 1