Hi,
I would like to SUM the amounts received from the purchase order entity (related items) and show the results in the Shipments entity. When I use a regular function I am given the SUM amount for all records in the Purchase order entity and not just the related item records.
Any help would be appreciated.
Thanks!
SQL Formula Help - Related Items
- elviseras
- Investor
- Posts: 578
- Joined: 08 Feb 2017, 03:16
- Name: Elvix Sampedro
- Location: Galicia - Spain
- Company Name: novaTEK
Re: SQL Formula Help - Related Items
Hi Damien,
Could you share your CSS theme? I find it very stylish and beautiful ...
Could you share your CSS theme? I find it very stylish and beautiful ...
- dhickey76
- Posts: 85
- Joined: 27 Mar 2020, 20:45
- Name: Damien
- Location: Utah, USA
- Company Name: Techtop Canada
- Contact:
Re: SQL Formula Help - Related Items
Thanks Sergey I understood that I needed to use a function, I just wasn't sure how to set it up with a related item. For anyone else that needs to do something similar here are the steps.
Total Recd. field is summing the amount received from a separate entity using a related item (purchase order)
Function {17} - Purchase Orders entity
Total Recd. field is setup to pull the function but tied to the related item
Thanks again, case closed!
Total Recd. field is summing the amount received from a separate entity using a related item (purchase order)
Function {17} - Purchase Orders entity
Total Recd. field is setup to pull the function but tied to the related item
Thanks again, case closed!
- dhickey76
- Posts: 85
- Joined: 27 Mar 2020, 20:45
- Name: Damien
- Location: Utah, USA
- Company Name: Techtop Canada
- Contact:
Re: SQL Formula Help - Related Items
I use the default theme but with some custom styling. I've attached part of my custom css since most of it is tied to specific fields. But the general layout, fonts and button customizing is there. You'll need to add your own URL into the font face items since mine is loading from my site.
If I were you, I would only add small sections at a time. Test and then add some more
Good luck!
- Attachments
-
- Custom.css
- (3.57 KiB) Downloaded 89 times