Saving invoice totals to Header

[Jeff, Richards]

I have been using the following code to save an invoice total to the Order amount field in a table called orders.
I use it on an onpush event on a button.
I would like it to execute automatically before I enter a new invoice. I tried it on an Can SAve Event on the invoice form. But I can't get it to work.
Any Ideas?

dim hdr as p
hdr=table.current() hdr.change_begin() hdr.orderamt=Total.value
hdr.change_end(.t.)total.refresh() 'refreshes the total field in the form body
end

[Peter.Wayne]

RE: Saving invoice totals to Header

try the OnSaveRecord event for the table, or the OnSave event for the form.

[drgarytraub]

RE: Saving invoice totals to Header

Jeff,

I usually do this as follows, which always works for me:

If the orderamt field on your form is called orderamt, then put this in your button:

orderamt.value=total.value
parent.commit()

[Jeff, Richards]

RE: Saving invoice totals to Header

I don't want to use a button.

[Jeff, Richards]

RE: Saving invoice totals to Header

neither one works. Returns a "0" value in orders.
Any other ideas?
Thanks.

[drgarytraub]

RE: Saving invoice totals to Header

First, see if you can get it working in a button. Once that works, you can use the Btn.push() method in any event that will push the button behind the scenes ...

Good luck

[Tom Cone Jr]

RE: Saving invoice totals to Header

Jeff, the message board messes up our formatting sometimes so it's hard to tell if your script is an exact copy of what you have in your database or not. If it is, then you need to break it into many separate lines. Right now you have lots of commands on a couple of lines. Needs to be one command per line. Ok.

-- tom

[Peter.Wayne]

RE: Saving invoice totals to Header

the OnSaveRecord event for a table fires after the record is saved. if your form is based on a set, however, then the parent record is saved *before* any detail records are entered. you can't make the invoice total be saved automatically to the parent record by coding something for the parent's OnSaveRecord event, because at that point your Total field probably has a 0 value in it.
there are examples of how to post from child records to parent records at www.learn alpha.com, also in Application Programming in Alpha Five, and probably also in Alpha Sports. You have to write some code for the OnSaveRecord event for the *child* table.

[Jeff, Richards]

RE: Saving invoice totals to Header

Gary,
Thanks for the help.
Yes it does work on a button.
I was thought that there might be a command that would push the button behind the scenes.

[drgarytraub]

RE: Saving invoice totals to Header

Jeff,

Why don't just put the code in a button, hide the button, and then use the Btn.push() method to push the button behind the scenes ...

Gary

[Jeff, Richards]

RE: Saving invoice totals to Header

How do I set up the button.
I can't find an example of btn.push()
Wnere do I put the button name?
Example please.
Thanks.

[drgarytraub]

RE: Saving invoice totals to Header

Go into the properties of the button and name it something that makes sense, like CalcBtn. Then, the Xbasic to push this button "behind the scenes" is simply:

CalcBtn.push()

[Mike Konoff]

RE: Saving invoice totals to Header

My invoice SUBTOTAL field is setup as a calculated field in the field rules. I use a DBSUM function to accomplish what you're trying to do.

DBSUM("invcline","invlin1",INVNO,"linetotal")

To get the function to fire, I put the following on the OnArrive, OnDepart, and OnRowchange events of the browse line items:

t=table.current()
t.change_begin()
t.change_end(.t.)

This suggestion came from someone in the message boards.

Mike

[Bill Parker]

RE: Saving invoice totals to Header

There is a Post field rule that does what you want. You would put this rule on the invoice items table to post the amount to the invoice header. This rule handles changes and deletes to invoice items.

There is an issue with the post rule when a form displays both the invoice items and the invoice total. If a detail item is added or changed, the correct value is posted to the invoice total in the table, but the form does not show the updated invoice total. Refreshing the form or object does not show the new value. The workaround I use is to create a calculated field on the form and set it to the value of invoice total. Then display the calculated field. The calculated field automatically shows any updates to the total. Go figure. Alpha has said they don't consider this a bug, so I have to call it an "issue".

Bill.