Filemaker Script to Create Summary Database

What is the requirements:

Provide a script that I can run daily to create a database and update it daily that contains a summary record for each unique Sales Order ID & SKU combination.

The records will primarily contain summary Price, Sales Tax, Shipping Fees Paid, Shipping cost, Product Cost and Profit for each record. This will allow me to sort and analyze data in the manner that I require.

Because the sales information that i have is detailed information, I am looking for a very simple Solution to provide Summary Data for each Sales Order ID and SKU. While the detailed information is very useful, Most of what I want to do requires the data to be summarized. Unless you have a very easy and simple solution that is easier than creating a summary database, I am asking for a simple script that creates a summary database that contains 1 summary record for each unique Sales Order Id and SKU. What does this mean. Sales Orders may have multiple SKU’s on each order. I would want a database that has summarized records based on the Sales Order ID and SKU. So the database could and will have multiple records with the Same Sales Order ID but not with the same Sales

Order ID and SKU combination.

You must comment the script sharing the detail of how the script works so that in the future i can understand it and possibly make minor changes.

I will provide existing two database structures and files already created. I have attached the relationship diagram. I also already have a layout that works correctly that has all the summary data on it if that is helpful.

Only Sales, SalesTranx, and salestranxsummary databases involved.

*** Information..
Please look at the new Database structure design document and the PDF that tells the details.

Habilidades: Programação de Banco de Dados, FileMaker

Veja mais: excel create database summary table, create script import database, create database registration php script, create database entry mssql script, database table create script php, create script backup database sql server, create database tables php script, script php create script mysql database, create database php realestate script, copy script vbs, outlook copy script, linux copy script, ksh safe copy script, copy script web site, vbs copy script, copy script text, youtube copy script, website copy script, linux ftp copy script, create script uninstall office 2003, database interface create website, ftp copy script, spanish voice copy script, best language simple file copy script, database search engine script

Acerca do Empregador:
( 4 comentários ) lexington, United States

ID do Projeto: #13561725

Concedido a:


Hello, This is Lingasamy having 4+ years of experience in Filemaker related technologies along with CWP. I can do this script within a day but the most important thing is you can't create another database/table throug Mais

$100 USD em 1 dia
(3 Comentários)

5 freelancers are bidding on average $96 for this job


Hello again We chatted yesterday in messages (on your other project page), I did try to contact you again through there, but it looks like the option is no longer available once the project is cancelled. I noticed Mais

$180 USD em 1 dia
(5 Comentários)

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, S Mais

$100 USD em 1 dia
(0 Comentários)

Hi...Can you please share up the ER Diagram as the attachment is shown getting shown. Will revert back to you in case of any doubts that would arise. I would try completing your project in minimal time.

$61 USD in 8 dias
(0 Comentários)

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with [url removed, login to view] mainly deal in web development, SEO, Android App, software testing and graphic design. Our vision is to b Mais

$77 USD in 7 dias
(0 Comentários)

Hi, I am an experienced developer with more than 7+ years of industry experience. I have been envolved in the design, development and implementation of ERP, Engineering solutions, CRM & Middleware systems. The techn Mais

$61 USD in 7 dias
(0 Comentários)