Creating an "end of day" script

[Jredeemer14]

Hello, I have a basic invoice layout for selling items and I'd like to create something (I assume a script) that would allow me to take all the records that are sold in one business day and copy them into a another table/layout so we can track day to day sales. I've attached a few images of the layout I have right now, if it helps. Any input would be appreciated.

[Ocean West]

you have only one table for invoices or do you actually have TWO? one for the invoice and a line items table?

You could import records from your real table(s) into your "backup" table(s)

but there are other methods to compare day to day sales, with out having to replicate your data. You could setup access privileges to prevent modification of data if the invoice date is less than today.

Is your invoice line items *shudder* repeating fields?

[Jredeemer14]

I have one for the invoice table and a line items table.

The import/backup idea is interesting, I'll play around with that.

my line items are not repeating fields, they simply interconnect tables.

This is really helping, any other ideas would be appreciated.

[Ocean West]

I am just trying to understand the process. If you are trying to get day to day statistics. prevent editing of invoices after a certain day. Can you derive this data from the current tables - I am just questioning the need for replication?

[Jredeemer14]

I guess I really don't need to replicate the data, I just need a good way of displaying all the inventory items that sold that day, a report, done daily so that the data could be manipulated, such as daily total dollar amount, what sold during the past week and what not.

[Fenton]

What Stephen is saying is that it is entirely possible to do a "report" that shows this information, just using the current line items data. Whether you want/need to "archive" the data is another question; it would really depend on how many times the same item was sold as to whether it was worth it. If the same item had hundreds of transactions per day, then possibly so.

A FileMaker report, which can be viewed in Preview mode and/or printed, can have a Subsummary part (or parts). You must specify what the "break" field is; in this case a product ID (or name, but that's clunky). You would then Sort by that same field, using a scripted process, to view the results.

The quantity field in the Subsummary part would be a special type of field, a Summary field, with the option, Total of Quantity (regular quantity field).

You would delete the Body part from the layout. After sorting, in Preview mode, it would then only show each product once, no matter how many transactions, and would summarize the total sold.