Closed

automatic po creation from item assembly within quickbooks - repost

Looking for someone to create a utility to automatically create purchase orders in Quickbooks Premier Manufacturing and Wholesale Edition.

User will select desired Item Assembly to perform the automatic creation of POs.

The utility will tree walk through the item assembly, create a list of vendors using the preferred vendor field, then populate a purchase order (for each vendor represented) with the items for that vendor.

In addition, an Excel spreadsheet is to be generated with the list of purchase orders created, along with the Vendor name.

Source code and IP to be granted to the purchaser.

Programmer must provide the instructions to install the utility.

Overview:
- Standalone utility on Windows XP PC to automatically create purchase orders in Quickbooks from Item Assemblies.
- Premier Manufacturing and Wholesale Edition of Quickbooks is being used.

User Interface:
- User will select database name by browsing to database file location.
- User will enter username and password.
- User will select desired Item Assembly from a drop down list of all top level Item Assemblies (from the QB database).
- The user will select a default Preferred Vendor from a drop down list of all Vendors (from the QB database). This value will be used where no Preferred Vendor has been assigned against a part.
- User will be able to browse location and enter a filename for the Tracking Report. Default filename will be the Item Assembly Name if not entered by the user.
- The user will select a desired (validated) ship date for all the purchase orders that will be created. It will default to two weeks from system date.
- The user will select a shipping address from a drop down list of Drop Ship addresses (from the QB database).
- The user will select a shipping via from a drop down list of from the QB database.
- Tracking Report Only Mode – the user will have the option of selecting a Tracking Report Only Mode check box. In - - Tracking Report Only Mode, Purchase Order won’t be created, just the Tracking Report.

Processing:
- The utility will tree walk through the selected Item Assembly, including all its’ sub-assemblies.
- It will gather a list of unique vendors Ids using the Preferred Vendor field of each Item in each sub assembly. If the default Preferred Vendor is not represented in the list, that will be added as well IF there are some Items that don’t have a Preferred Vendor defined.
- It will then create a purchase order for each vendor in the gathered list. It will use the “ship date” entered by the user, the user defined “shipping address” and the “ship via”.
- It will populate each purchase order with the items for that vendor, along with the quantities that are allocated in the Item Assembly.

Tracking Report:
- An MS Excel spreadsheet (.xlsx) to be generated, after the creation of the Purchase Orders in the Quickbooks database, containing with the list of purchase orders created, along with the Vendor name. One row per PO. PO and Vendor name in separate columns.

IP:
- IP for the utility is to be granted to the purchaser.

Documentation:
- Programmer must provide the instructions to install the utility.
- Programmer must provide instructions on how to run the utility.
- Programmer must provide source code and instructions on how to compile the utility.

Skills: Database Administration, HTML, Intuit QuickBooks, PHP

See more: automatic quickbooks, quickbooks premier 2013, manufacturing spreadsheet, c# assembly, pos for net, install quickbooks, excel spreadsheet programmer, select item from, c assembly, automatic, create purchase order, populate excel spreadsheet spreadsheet, quickbooks purchase order net, net spreadsheet, 2013 excel visual basic, purchase order spreadsheet, repost automatic, excel 2013 visual, source list creation, automatic purchaser, populate excel spreadsheet, visual basic excel 2013, creation excel, excel utility, pos excel

About the Employer:
( 4 reviews ) Calgary, Canada

Project ID: #4308059

11 freelancers are bidding on average $674 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$699 USD in 14 days
(220 Reviews)
7.7
consus

Hello Sir We are quiet experience in developing add on application for Quickbooks we have sucessfully deployed more than 35 projects with Quickbooks on [url removed, login to view] you can visit our customer testimonials please c More

$750 USD in 15 days
(37 Reviews)
7.2
ValueCoders

Hi, Experts team of SEO/Wordpress/PHP/joomla/Drupal developers and designers. Thanks Gaurav

$600 USD in 20 days
(96 Reviews)
6.5
exoticsolutions

Hello Sir. We are integration experts and worked with Quickbooks APIs many times. Lets discuss in PM for complete details and information flow. Thanks

$750 USD in 10 days
(5 Reviews)
4.9
KavitaBhimani

Hi, I have developed similar functionality for couple of clients. Please refer my completed projects and comments from them. Please read the PM form more details. Thanks, Kavita

$700 USD in 30 days
(1 Review)
3.2
aptecpymefree

We can work in your automatic po creation from item assembly within quickbooks. I am a leader of the team expert in several tecnologies like PHP, .NET, Oracle, SQL, Movil applications. I have 14 Years of experience in More

$750 USD in 45 days
(2 Reviews)
3.1
WeExcelwebsol

Dear Sir, Greetings! We are WeExcel Technologies Pvt. Ltd. with 10 years of experience under our belt. We are really interested to work on your project. Please see PM. Thank you. Regards, WeExcel.

$750 USD in 20 days
(1 Review)
2.9
pythonshell

Expert Solution here. Check PM

$420 USD in 5 days
(8 Reviews)
2.8
mikedelrosario

Pm me if interested. Have a nice day!

$500 USD in 2 days
(0 Reviews)
0.0
acopies

Hi there, Greetings!!! We went through your project and much interested in moving on into the project with the skills that require to completing it. We are very much sure about the quality and the time period as well More

$600 USD in 15 days
(0 Reviews)
0.0
blackgrapes3

It's an easy task for [url removed, login to view] have gone through your requirements and we are ready to start the work immediately on your project. Please see the attached list of company's projects. Also please check the PMB.Thanks.

$700 USD in 21 days
(0 Reviews)
0.0
handmilkingsoft

- Located at Costa Rica, we are your best nearshore outsourcing choice. - Excelent timezome GMT -6 - We have 5 years of experience in the main web and desktop technologies. - We are a team of 4 developers wich can p More

$750 USD in 21 days
(0 Reviews)
0.0
fahimgolani

Hello , I have developed similar software. Please check PM

$750 USD in 15 days
(0 Reviews)
0.0