Find Jobs
Hire Freelancers

Write some Software

min $50 USD / hour

I përfunduar
Postuar about 7 years ago

min $50 USD / hour

Summary of Deliverables: Adjusting, Mapping and visualization of the product sales and license data structure at Vectorworks Inc. This will use relationships within the sales ordering and accounting information systems, with historical detail of sales and adjusting items as scripted. We currently have a working model. Would like to a partner in a Scrum methodology, with a T&M basis, to add functionality and usability with this file/database over the next year. Executable program / script which: - performs targeted queries and updates data and calculations for monthly adjustments - provides summary reporting and tie-out checks for reconciliation/auditing - ongoing custom reporting as the process matures Statement of work Vectorworks is a Software company that sells its product as a standalone license as well as with a subscription option to purchase an access to new developments and knowledge. Due to the nature of this product, bundling discounts are offered to entice buyers to purchase both items. These purchases are tracked via a license number that is applied to the sale. These sales need to be reallocated from the actual sale item and booked and reported over this license by type, country and period based on a weighted average of the actual list price. Accounting guidelines require the total sale price of any discounted product bundle to be allocated amongst the individual items within the bundle based on a weighted average of their full list price. Calculation and reporting of this process and adjusting allocation by license type, country/distributor, and period is required. Other breakouts can occur (I.e. 24 mo. items). The data sources and specific fields necessary for these requested outputs will be provided, and will include a combination of our accounting and sales order database systems. Targeted queries of the extracts of current period data is required to update our calculations and reporting each month. Overall improvement to access and extract files will be updated as the system matures. Fields will be derived from our accounting system via a database extract. Show extract in basic form can be Access or Excel. Monthly download will be updated into the Access file allowing for a YTD recalculation. Filters will be needed for this pass-through (period). Basic example of what will happen. Feb sale Lic # 41645 Retail Type Total Paid Retail % Allocate Paid Adjustment needed BNN-P1-AVX-SXXZ-BB 800 SW 346.97 57% 255.09 (91.88) BSA-P1-AVX-SXNX 176 VSS 23.47 13% 56.12 32.65 BSA-P1-NEW-VXNX 417 VSS 73.73 30% 132.96 59.23 0 VSS - 0% - - 0 VSS - 0% - - 1393 444.17 100% 444.17 0.00 We need to calculate the allocated and Paid adjustment need (not a good picture here). Output will include: 1. Visualization of the License build up information and allocation. 2. Recalculated Sales by country and type showing the old, calculated adjustment and new amounts a. both for the current period (month) and YTD. Help will be needed on format issues with the data. Future options will allow the VSS calculated filed to be allocated over specific months from a derived field. Basic Data Item SKU Doc # Month BP (Customer) Country License Number Retail Price Selling Price Units sold Item identification
ID e Projektit: 13182422

Rreth projektit

16 propozime
Projekt në distancë
Aktive 7 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
My passion is building Access Databases. I have built well over 250 custom databases in the past 16 years. I have taken all classes from beginner to expert 97 to 2013. I have samples and more reviews at [login to view URL] Databases I have built includes, Production and Inventory, Scheduling, time-clock, Book-Keeping, and many custom databases. The latest for a major hospital in Oklahoma 5 buildings. I created a facilities management database. This database stored order assignments, Invoice forms, Employee data and all other features to run a facilities management business. I can start today. I am submitting bid for your Access project because I believe my past training and education has prepared me well for it. My strong desire to become one of the best in my field is my motivation to excel as an Access Developer and I would appreciate the opportunity to put my skills and experience to work for you.
$50 USD në 40 ditë
4,8 (31 përshtypje)
0,0
0,0
16 freelancers are bidding on average $53 USD/orë for this job
Avatari i Përdoruesit
Hi there, I'm a full stack developer and have developed a number of data management and visualization applications. I've just gone through your project description and I think after discussing the specifies, we can build a web application that would allow you to feed in data that our app will alter and also visualize the results. We can then build various filters on data (e.g Time Range, Quarterly Reports etc). We can go over the details via chat.
$55 USD në 50 ditë
4,1 (2 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$50 USD në 40 ditë
4,9 (86 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi, I'm a professional Ms Access and VBA developer with strong background in developing and implementing information systems with databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I have done similar assignments previously, so check my profile for details. I'm looking forward to hearing from you. Regards,
$50 USD në 40 ditë
4,9 (62 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
$50 USD në 20 ditë
4,7 (27 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I’m an Access/VBA programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$55 USD në 40 ditë
4,6 (44 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore your needs, which will yield a clear picture of implementation phase. Prior undertaking project, I want to show demo of the work done previously. Apart from demo, I will be sharing following documentation which will turn your project into Quality and Successful delivery: - Technical Project Proposal - Designs - Flow chart for this Project - Execution plan
$51 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Dear Sir, I have read your project description & interested to discuss further, so can you spare some times for an online conference call with my technical team lead? Look forward to hearing from you & start further discussion thru' private chat. Regards, YK LEADconcept
$55 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.
$55 USD në 40 ditë
5,0 (1 review)
0,0
0,0
Avatari i Përdoruesit
Hi I Would like to work with you in this project. I has a solid experience in POS Software in stores, Pharmacies, optics, and so on. I has a solid experience in VB, VB.Net, C# and a good knowledge in c and VC++. I Work in database using SQL Server , Access, Oracle, FoxPro. using Reports tools (DataReport in VB6, .Net ReportViewer , Crystal report, Printing) I Work hard and with solid system and good testing.
$55 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I have expertise in this domain. Client's satisfaction is my first priority and believe in long-term relationship with clients.
$50 USD në 40 ditë
5,0 (5 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
Columbia, United States
5,0
6
Mënyra e pagesës u verifikua
Anëtar që nga nën 30, 2016

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.