Filemaker Script to Create Summary Database

完了済み 投稿 7年前 着払い
完了済み 着払い

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個の提案 リモートプロジェクト アクティブ 7年前

アワード:

lingasamy

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 もっと

$100 USD 1日以内
(9レビュー)
4.0

4人のフリーランサーが、平均$105 で、この仕事に入札しています。

ausprofreelancer

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 もっと

$180 USD 1日以内
(11件のレビュー)
5.8
imranshaukat

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 もっと

$61 USD 7日以内
(0件のレビュー)
0.0