Filemaker Script to Create Summary Database
$10-100 USD
着払い
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.
プロジェクトID: #13561725
プロジェクトについて
4人のフリーランサーが、平均$105 で、この仕事に入札しています。
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 もっと
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 もっと