Find Jobs
Hire Freelancers

Write Summary Record Database Script in Filemaker

$10-75 USD

キャンセル
投稿日: 約7年前

$10-75 USD

完了時にお支払い
To a filemaker expert this is easily less than an hour project. Request & Facts: Each Day I upload a file that adds records to the Sales Database. It contains a record of every sales order based on a unique sales order id. It also has purchase date and payment date. It does not have any duplicate Sales Order ID’s. Each Day i upload a file that adds records to the SalesTranx Database. It contains detailed records of many types that are related to a specific sales order. It has record types such as order, refund, shipping services, and other types. Each record in this table has the sales order id along with a number of other important fields. Each record also has a type such as order, refund, shipping service as well as other types. These types represent the various transactions related to an order. The file also contains records that do not have a sales order id associated with them. These records need to be skipped. This database is the detail of each order. NOTE: The file information cannot be gathered in any other format. This is not my preference and is beyond my control. Do not ask about getting the data in any other format or structure because it is not available. The solution has to be structured off the data we get. What Do I want: 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. The purpose of this script is 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. 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. I have attached a image of it as well. Shipping Record: Data does not have a SKU associated with it Data sometimes has multiple records for the same order-id Data sometimes has single record for the same order-id Logic in my mind: Simply look at total shipping cost for the Order-id and count the number of SKU’s and apply an equal amount of shipping cost to each SKU. Looking to apply shipping charge per order-id and SKU. Refund Record Data does have a SKU associated with it. This means it can easily be tied to sales Order ID and SKU. It just needs to have a field in the new database with the appropriate amount. Order Record It has Data per SKU and is contains critical information. Data is a single Record when a Single SKU in multiple quantities when that is on the order. Data is multiple records when a multiple SKU in any quantity is on the order. Service Fee, Transfer or Adjustment - Ignore New Table Required Records: Sales Order ID (Should be unique in Sales Database) Sales Purchase Date (Must be pulled from Sales Database) Sales Payment Date (Must be pulled from Sales Database) All Records in SalesTranx All fields on layout 25
プロジェクト ID: 13544634

プロジェクトについて

4個の提案
リモートプロジェクト
アクティブ 7年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に4人のフリーランサーが、平均$101 USDで入札しています
ユーザーアバター
Hello I have over 28 years extensive experience with Filemaker Pro and have developed, deployed and maintained many instances from very large and complex down through to small more simple deployments. I have read through your project details you provided and looked at the attached images and structures, if I understand it correctly, you are looking for a script to populate a table, within the database, with summary data as per the project description? If you would like to contact me with some additional information, including which version of Filemaker Pro you are running and maybe I can get you to send through a copy of your database (sanitized if you prefer), so I can get a better understanding of exactly what you want to achieve, we can confirm a plan and I can provide a more accurate timeline/costings for completion. Thank you Darren
$250 USD 7日以内
4.9 (11 レビュー)
5.8
5.8
ユーザーアバター
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, SIMULINK, PSPICE, NS2, NS3 based IEEE papers. We can give remote support in Wintel, ADS, Unix, Storage, Backup, Network, Security tracks. Have experience in Active Directory, DNS, DHCP, FTP, IIS, SharePoint, CRM, SQL, WDS, ADRMS,ADFS,ADLDS, SCCM, Citrix Xenserver, Citrix XenApp, CRM,CRM Outlook connector IFD, Linux, Apache, My SQL, Postfix, VM Ware, Vcenter, VCO, VOIP (3CX)WHM, cPanel, H-Sphere, Hosting Controller, Plesk, DirectAdmin based web hosting support. We work in PHP, JAVA, ASP, DOT NET, Prestashop, Magento, woo commerce, OSCommerce, WordPress, Joomla, Web Hosting Panels Programming, LAMP, Android java development, Backend Server APIs, Android, Java, C/C++, Linux, PHP, MySQL, AJAX, JavaScript, C#, Visual Basic, PHP, MS SQL, My SQL, PHOTOSHOP, CSS, Bootstrap, HTML, JQUERY, JAVA, SCRIPT. We specialize in business, technical, academic, commercial, fiction, and Blog Writing, Dissertations, Academic papers, eBooks, Fiction, Sci-Fi thriller, Technical content, Articles, Web content, and blogs
$10 USD 1日以内
5.0 (1 レビュー)
1.0
1.0
ユーザーアバター
$88 USD 5日以内
5.0 (1 レビュー)
0.7
0.7

クライアントについて

UNITED STATESのフラグ
lexington, United States
5.0
4
メンバー登録日:2月 24, 2015

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。