We are looking for an experienced Quickbooks Web Connector developer that has used VTiger Open Source CRM system. We are going to be switching over from using Quickbooks and then syncing to VTiger for CRM purposes to doing all work in VTiger and syncing to Quickbooks for accounting only. These are the functions we are looking to have done.
Product Cost needs to be associated with an expense account for Quickbooks - COST OF GOODS SOLD for example
Bring in product name, product model, retail cost from website including attribute options.
Need to input a field for Paying out orders using Paypal, Wire Transfer, Check, Cash, BML, Net Terms, other.
Credit Card - Need to integrate Authorize.net api and receive payment to customer account.
Paypal - Need Input for Amount Received, Transaction ID, and auto calculate paypal fee for recording in Quickbooks
The Invoice can only be created when payment or deposit is applied. Orders with balances need to show in a OPEN Order report. We need to have Payments Applied and Balance Due under GRAND TOTAL.
Payments or open balance need to be calculated and shown in the customer MORE INFORMATION history.
Once a Sales Order is Paid, it goes into a Queue or use Status like we do in QB waiting for manager approval to become an official Invoice. After approval and invoice is generated, related Purchase Orders or Internal Ready to Ship can be made or selected. This process discussed below.
Purchase Orders -
Next to each item on the Sales Order will be a check box for either VR Stock or Dropship.
When the item is checked with VR Stock, this brings up the item info and shipping type to the Shipping Manager in a Queue so he/she knows what to ship.
When the item is checked with DROPSHIP, when the order becomes an invoice, a Button that Says GENERATE PO will appear next to the line item and the manager approved invoice will then allow sales rep to create a PO to the assigned vendor(s). We need to have the ability to change vendors if need be or change shipping type on this automation.
If multiple items per invoice using multiple vendors, we need to create a shipping line for each PO with information on shipping type.
Certain things will not allow the document to be created if field is set to required and not filled in. IE Price.
Purchase Orders will popup in a Queue that can either be emailed as a batch or 1 by 1 to the vendor.
The Purchase Order must be associated back to the Invoice corresponding line item like we do now in qb and in the customers MORE INFO section.
The Purchase Order needs to be tagged/stamped like Quickbooks with SENT once emailed.
Sales Orders, Quotes, Invoices Product Details -
Need a input field between Product Name and Stock called Attributes where text can be entered.
I need to have a field or drop down for shipping to select service that we input values. 2day, 3day, Overnight, Ground, Freight, etc. Also the Carrier Type: Fedex, UPS, USPS, Freight. This amount will be manually entered in and not calculated.
Returns or Credits need to be its own form. This would be a negative affect to customers account so we would have to be able to run credits with authorize.net if possible. We could also have an option for this to be "Store Credit". This would require saving the $$$ amount to the customer account so if they ordered again, it would show how much credit they have to use. If they use over the credit amount, a DIFFERENCE would be shown This would have to have manager approval.
RMA's would be a form to generate a return authorization back to Vivid. This form would have the item information, a reason for the return, and instructions to be printed out.
The biggest challenge here is writing all this data back to the appropriate fields in Quickbooks a couple times a day for accounting purposes. This will have us using VTiger as the main function for processing orders and payments.
Additional Project Description:
12/12/2012 at 5:58 EST
You can contact me via skype at vividracing or AOL IM evolvedaz to discuss the project.