I am having a serious issue with an application I developed in Alpha Five v.10.5
I created a one-to-many set, one for an Invoice_Header (parent), and the other as Invoice_Body (child).
I have a numeric "invoice_total" field in the Invoice_Header, that I am needing to calculate the totals from the Invoice_Body.
I tried numerous ways to make this happen...
A) Trying to make "invoice_total" a calculated field that took the total from invoice_body... but Alpha Five error'd and didn't like this calculation.
B) I then tried posting any amount to calculated in the invoice_body and having it post to the "invoice_total" field in the invoice_header. This worked as long as you entered the data in invoice_body perfectly--but if you choose the wrong product number, and then go back and edit the product code (for the item being sold), and then the price changes, although the line item in the invoice_body changes, it does not like to consistently post (add the new, and subtract old line item) from the "invoice_total" field.
I'd prefer not to use the post function at all, and would rather just have some sort of calculation so that it the totals remain kosher at all times...
I did create a calculated field within the Invoice form (which does calculate perfect 100% of the time) but I have not found a way to make that number then post into the "invoice_total" field within the invoice_header field.
Any ideas? I feel like this is too complicated for something so easy.
Thanks in advance.
I created a one-to-many set, one for an Invoice_Header (parent), and the other as Invoice_Body (child).
I have a numeric "invoice_total" field in the Invoice_Header, that I am needing to calculate the totals from the Invoice_Body.
I tried numerous ways to make this happen...
A) Trying to make "invoice_total" a calculated field that took the total from invoice_body... but Alpha Five error'd and didn't like this calculation.
B) I then tried posting any amount to calculated in the invoice_body and having it post to the "invoice_total" field in the invoice_header. This worked as long as you entered the data in invoice_body perfectly--but if you choose the wrong product number, and then go back and edit the product code (for the item being sold), and then the price changes, although the line item in the invoice_body changes, it does not like to consistently post (add the new, and subtract old line item) from the "invoice_total" field.
I'd prefer not to use the post function at all, and would rather just have some sort of calculation so that it the totals remain kosher at all times...
I did create a calculated field within the Invoice form (which does calculate perfect 100% of the time) but I have not found a way to make that number then post into the "invoice_total" field within the invoice_header field.
Any ideas? I feel like this is too complicated for something so easy.
Thanks in advance.
Comment