Sending an invoice by email

[Himitsu]

I am very new at scripting and wanted to know if anyone could give me a hand on the calculation that I would need to send an invoice. I have a sales table, lineitems table, and a customers table. I would like to send an invoice to the customer. I know some easy calculations like:

"Dear " & sales::cust_name & ","&"

[Lee Smith]

This topic has come up several times in the past. A search of the "All Forums", using

+email +Invoice and a Period "1 year", should provide you with an abundance of information.

Note: The [color:"blue"](Advanced search tips), it's blends in and is hard to see, but is located above where you type in the Keywords, it can be helpful for finding past posts on your subjects.

HTH

Lee

[Himitsu]

I did look a lot before I posted this. I usually don't like posting questions that have been answered before, but this time, I looked again for more than an hour and went back more than a year. There was some info, but mostly about body content using fields. I thought about using a summary field but I can't see how to take all the lineitem records associated to the sales id and put them into a summary. I thought summaries where used to calculations of numbers or boleens... I used to have an old fm4 file that would send invoices, but it must have gotten erased on one of the many times my computer crashed while running that super OS, Windows ME!!!

[Himitsu]

I have been at it all morning. What I tried was to export the record to html format then attach it. But it is exporting all records even if I group them by sales id. I am really stumped on this one. My experience isn't good enough...

[Himitsu]

Ok, here is what I have come up with. Thanks to a lot of help from Fenton, we did a set field to a global and gathered the customer name and id. Then when to go to related records on the line items through sales id and on the set field, we set it to the same global but then in the calculation, the first field is its own global it is setting to. That will keep the past information entered while putting in the new information. that is where my problem was.

set Field[sales::invoice_body; sales::invoice_body & sales::invoice_global_name & line items::product price]

Sales::invoice_body is my global and I am writing to it, then gathering it before it is written. Then after going to the related records entering a loop and setting the fields. I used a invoice_global_name global and just put a tab space into it. So the information will be spaced.

My next area I will just add a thanks message and address global, so later if we want to change the thanks message, we can and it will pull that info. too. Thanks everyone for the push. And Lee, I am sorry for that double post. Won't happen again.

[Himitsu]

Ok, here is what I have come up with. There's a lot of Japanese in it, but if you anyone wants to play around with it, they can add anything.

reciept.zip