automatic po creation from item assembly within quickbooks - repost

CLOSED
Bids
12
Avg Bid (USD)
$668
Project Budget (USD)
$250 - $750

Project Description:
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.

Additional Project Description:
03/09/2013 at 4:51 IST
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 required:
Database Administration, HTML, PHP, Quickbooks & Quicken
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 699
in 14 days
Hire consus
$ 750
in 15 days
Hire ValueCoders
$ 600
in 20 days
$ 750
in 10 days
Hire KavitaBhimani
$ 700
in 30 days
$ 750
in 45 days
$ 750
in 20 days
$ 420
in 5 days
$ 750
in 15 days
$ 600
in 15 days