Auto SUM cost of items in an invoice (child records)
So I have an app that is being used to build a quote for vehicles.
Initially the accessory options were added as check boxes and they would relate to a formula-numeric field that would add the cost of each selected.
This is now un-sustainable, as accessories change price often, so I built 2 new tables:
Accesory (Master) holds the information of all accessories currently offered (Item ID, Name, Description, Img, Price, etc.)
Added Accessories is related to both the quote and the Accessory (Master) table, and holds the price using a snapshot field.
Is there a way that when I am building a new Quote, and haven't saved it yet, I can see the total value of added accessories?
I'm using a Grid-Edit to add child records to the quote, but need to have the total price of accessories in order to validate whether it will need management approval or if the salesman can just print & submit.
Initially the accessory options were added as check boxes and they would relate to a formula-numeric field that would add the cost of each selected.
This is now un-sustainable, as accessories change price often, so I built 2 new tables:
Accesory (Master) holds the information of all accessories currently offered (Item ID, Name, Description, Img, Price, etc.)
Added Accessories is related to both the quote and the Accessory (Master) table, and holds the price using a snapshot field.
Is there a way that when I am building a new Quote, and haven't saved it yet, I can see the total value of added accessories?
I'm using a Grid-Edit to add child records to the quote, but need to have the total price of accessories in order to validate whether it will need management approval or if the salesman can just print & submit.
