KB: Managing Your Inventory: Difference between revisions

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Jump to navigation Jump to search
No edit summary
Line 17: Line 17:


===ODBC===
===ODBC===
*Using ODBC is very similar to the first option; however, instead of exporting and importing the information, you can have it automatically retrieved from CommitCRM directly into your inventory software, as long as your inventory software supports ODBC.
*Using ODBC is very similar to the first option; however, instead of exporting and importing the information, you can have it automatically retrieved from CommitCRM directly into your Inventory Solution, which will automatically adjust the quantities in your inventory accordingly, as long as your Inventory Solution supports ODBC. The ODBC driver handles all communication of data between your database and the 3rd party software you want the information to go to. The CommitCRM ODBC only supports information being '''read''' from the CommitCRM database.
*The ODBC is an advanced option, and should be used if you've have had experience with getting ODBC applications to talk to each other.


<br>
<br>
*For more information regarding CommitCRM ODBC, [[Commit_API_Developers_Guide#ODBC_Data_Retrieval|please click here]].
*For more information regarding CommitCRM ODBC, [[Commit_API_Developers_Guide#ODBC_Data_Retrieval|please click here]].


===QuickBooks===
===QuickBooks===

Revision as of 15:59, 24 December 2009

Introduction

When your business needs to maintain a product & part inventory, the needs arises to have CommitCRM have the ability to talk to your Inventory Solution software, in order to keep your inventory lists up to date. Using CommitCRM, you can have the system easily update your inventory without having to manually enter the information again into your inventory software.


Suggestions

The items stored in CommitCRM are only kept for billing purposes, and are not used in any inventory tracking capacity; however, the charges can be used to pass quantity information to 3rd party inventory solution software. For now, customers who also manage inventory have 3 alternatives that are usually enough.


Export

  • By exporting your charges, you can later import the charge list into a 3rd party inventory application, which will automatically correct the inventory list according to the imported list. This method can be done once a day/week, or even a few times a day.



ODBC

  • Using ODBC is very similar to the first option; however, instead of exporting and importing the information, you can have it automatically retrieved from CommitCRM directly into your Inventory Solution, which will automatically adjust the quantities in your inventory accordingly, as long as your Inventory Solution supports ODBC. The ODBC driver handles all communication of data between your database and the 3rd party software you want the information to go to. The CommitCRM ODBC only supports information being read from the CommitCRM database.
  • The ODBC is an advanced option, and should be used if you've have had experience with getting ODBC applications to talk to each other.


QuickBooks

  • QuickBooks has powerful integration options which also include issuing invoices from within CommitCRM. This allows QuickBooks to later take the charge info and pass it to the QuickBooks inventory module, and process it to automatically adjust your inventory list accordingly.



See Also