Difference between revisions of "ITrack/Pro/Quickbooks Screen"

From ISoft Wiki
< ITrack‎ | Pro
Jump to navigationJump to search
(→‎Dependencies: Added lineitem section)
(Moving setup information to ITrack/Pro/Quickbooks Screen/Installation, adding the "What happens when you export stuff" section)
Line 1: Line 1:
Quickbooks is an accounting software package that we are able to link with ITrack.
Quickbooks is an accounting software package that we are able to link with ITrack.


==Setting up on a client machine==
If you want details on how to set the screen up for the first time, [[ITrack/Pro/Quickbooks Screen/Installation|see this page]]!
We can not link Quickbooks and ITrack Pro until the customer has Quickbooks all set up (because we don't know - and shouldn't know - the inner workings of the customer's accounting methods). Once Quickbooks is set up according to their accounting methods just follow these steps:
 
# Install the latest version of the Quickbooks SDK (currently [http://tools.isoftdata.com/QBSDK80.exe 8.0])
##Requires a restart.
# Put Quickbooks into multi-user mode (File->Switch to Multi-User mode)
# Make sure the ITrack Quickbooks Toolkit is pointed at the same company file as the one open in Quickbooks
# Initiate communication with Quickbooks from the ITrack Quickbooks Toolkit
# Go back to Quickbooks, set it up to always be able to communicate, even when Quickbooks is not turned on


==Colors==
==Colors==
Line 27: Line 19:
Payments show up with a grey background, and COGS adjustments show up with a dark grey background.
Payments show up with a grey background, and COGS adjustments show up with a dark grey background.


== Dependencies ==
== What happens when you export stuff ==
You will not be able to push certain objects to Quickbooks until all of the objects that they depend on are successfully linked with Quickbooks.
=== Invoices ===
 
For new (black text) invoices:
Here are the objects that can be exported to Quickbooks, followed by the objects that they depend on:
* Invoices with a positive total are exported as invoices
 
* Invoices with a negative total are exported as credit memos
=== Invoice ===
* Customer
* Salesman
* Tax item
 
=== Check (a negative payment) ===
* Payment method
* Customer
* Account receivable
* Bank
 
=== Journal Entry ===
* Debit account
* Credit account
 
=== Part Type ===
* Income account
* Expense account
 
=== Payment ===
* Payment method
* Customer
* Account receivable
 
=== Purchase Order ===
* Vendor
 
=== Quote ===
* Customer
* Salesman
* Tax item
 
=== Lineitem ===
For invoices, quotes, or purchase orders.
 
These are not required, but if ITrack thinks that they exist in Quickbooks, it will attempt to reference them.


* Part type
When updating previously-exported (blue text) invoices:
* Category
* Voided invoices are deleted from Quickbooks
* Other invoices are deleted from Quickbooks, then pushed in as a new invoice


[[Category:ITrack/Pro/Extensions]]
[[Category:ITrack/Pro/Extensions]]

Revision as of 13:59, 26 March 2012

Quickbooks is an accounting software package that we are able to link with ITrack.

If you want details on how to set the screen up for the first time, see this page!

Colors

Blue text

  • If items show up with blue text that means something has been modified on that document (ie. Customer, Invoice, etc) and needs to be repushed
    • In the case of modified invoices, the quickbooks screen will remove the existing invoice from quickbooks and repush the modified one to replace it.
    • Every time an invoice is saved it will then show up blue to be re-pushed. If users want to just reprint an invoice its best to do it from the Customer screen > Sales tab since it doesn't require a save to print, like the sales screen.

Grey text

Grey text means that it can't be sent to Quickbooks because another item needs to be pushed to Quickbooks first (ie. Invoice can't be pushed because Customer hasn't been pushed)

Grey background

Payments show up with a grey background, and COGS adjustments show up with a dark grey background.

What happens when you export stuff

Invoices

For new (black text) invoices:

  • Invoices with a positive total are exported as invoices
  • Invoices with a negative total are exported as credit memos

When updating previously-exported (blue text) invoices:

  • Voided invoices are deleted from Quickbooks
  • Other invoices are deleted from Quickbooks, then pushed in as a new invoice