ITrack/Pro/Quickbooks Screen - Revision history

Duff: Elaborating on what things get repushed to QB

2012-03-26T19:15:24Z

Elaborating on what things get repushed to QB

← Older revision		Revision as of 14:15, 26 March 2012
Line 19:		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.

	== ~~What happens when you export~~ stuff ==		== How stuff gets exported to Quickbooks ==
			When you save something new in ITrack, it will immediately show up in the Quickbooks Toolkit screen to be exported for the first time. Such items show up in black text.

			Every time you go to some screen, open up an existing thing, and hit the "save" button, that item is flagged to be repushed to ITrack. Such items show up in blue text in the QBToolkit.

			Re-saving an existing item flags it to be pushed again no matter what you changed. It doesn't matter if the one item you changed matters to Quickbooks, the whole invoice/payment/whatever is going to get re-pushed.

	=== Invoices ===		=== Invoices ===
	For new (black text) invoices:		For new (black text) invoices:

Duff: Moving setup information to ITrack/Pro/Quickbooks Screen/Installation, adding the "What happens when you export stuff" section

2012-03-26T18:59:06Z

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.
-==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]]!
 ==Colors==
@@ Line 27: / Line 19: @@
 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
-* Part type
+When updating previously-exported (blue text) invoices:
-* Category
+* Voided invoices are deleted from Quickbooks
 [[Category:ITrack/Pro/Extensions]]

Duff: /* Dependencies */ Added lineitem section

2010-02-24T16:08:56Z

Dependencies: Added lineitem section

← Older revision		Revision as of 11:08, 24 February 2010
Line 59:		Line 59:
	* Vendor		* Vendor

	=== ~~Invoice~~ ===		=== Quote ===
	* Customer		* Customer
	* Salesman		* Salesman
	* Tax item		* 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
			* Category

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

Duff: Added dependencies of QB objects

2010-02-24T16:04:06Z

Added dependencies of QB objects

← Older revision		Revision as of 11:04, 24 February 2010
Line 26:		Line 26:

	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 ==
			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.

			Here are the objects that can be exported to Quickbooks, followed by the objects that they depend on:

			=== 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

			=== Invoice ===
			* Customer
			* Salesman
			* Tax item


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

Codeman: Quickbooks is bad and it should feel bad. I removed all the the problems out of this page and gave them their own home.

2010-02-22T16:45:28Z

Quickbooks is bad and it should feel bad. I removed all the the problems out of this page and gave them their own home.

← Older revision		Revision as of 11:45, 22 February 2010
Line 27:		Line 27:
	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.

	~~==Problems/Solutions==~~
	~~'''Quickbooks is bad and it should feel bad'''~~
	~~===You/Someone marked something as "Ignore"===~~
	~~You shouldn't have done that~~

	~~'''Solution:'''~~

	* Go into the database
	* In the corresponding table(ex. invoice, payments), the qbid and qbes will probably be set to -1
	* Set them to an empty string
	* Tell them/yourself to never set something to ignore again

	~~===Object "220000-1168719388" specified in the request cannot be found. QuickBooks error message: Invalid argument. The specified record does not exist in the list. Code: 3120===~~

	~~'''Solution:'''~~
	In the case of a Invoice or Payment, you probably need to go to customer tab on the Quickbooks screen and double click the customer on the invoice/payment, then select the correct corresponding customer in Quickbooks. Then try to repush the invoice/payment to Quickbooks.

	~~===Error #3000 the given object ID '''' in the field list is invalid===~~
	~~'''Solution:'''~~
	~~One of the things on that document haven't been pushed to QB yet. For example, it could be that the customer on an invoice has not yet been pushed to Quickbooks.~~

	~~===Error 3140 - Invalid reference to Quickbooks AR Account <account name> in the invoice.===~~

	~~'''Cause:'''~~
	~~A setting in Quickbooks became unassociated with its value in ITrack.~~

	~~'''Solution:'''~~
	In the Quickbooks Tools Screen, go to the 'Config' tab and associate the relevant AR Accounts (Invoices, Payments, and Credit Memos), by double clicking on them and selecting the appropriate options in the list.

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

Codeman: Took a few Quickbooks Errors out of here and put them in their own page - I will clean the other pages up soon so that they conform to formatting

2010-02-19T21:04:44Z

Took a few Quickbooks Errors out of here and put them in their own page - I will clean the other pages up soon so that they conform to formatting

@@ Line 47: / Line 47: @@
 '''Solution:'''
 One of the things on that document haven't been pushed to QB yet.  For example, it could be that the customer on an invoice has not yet been pushed to Quickbooks.
 ===Error 3140 - Invalid reference to Quickbooks AR Account <account name> in the invoice.===

Codeman: A Quickbooks error I found

2010-02-12T21:59:05Z

A Quickbooks error I found

← Older revision		Revision as of 16:59, 12 February 2010
Line 77:		Line 77:
	'''Solution:'''		'''Solution:'''
	Log onto Quickbooks as an Admin (which will make this error go away), and set the configurations so that ITrack can automatically export, even if Quickbooks is not on (which will make this error stay gone).		Log onto Quickbooks as an Admin (which will make this error go away), and set the configurations so that ITrack can automatically export, even if Quickbooks is not on (which will make this error stay gone).

			===Error 3140 - Invalid reference to Quickbooks AR Account <account name> in the invoice.===

			'''Cause:'''
			A setting in Quickbooks became unassociated with its value in ITrack.

			'''Solution:'''
			In the Quickbooks Tools Screen, go to the 'Config' tab and associate the relevant AR Accounts (Invoices, Payments, and Credit Memos), by double clicking on them and selecting the appropriate options in the list.

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

Daytonlowell: /* Setting up on a client machine */

2010-01-14T17:41:11Z

Setting up on a client machine

← Older revision		Revision as of 12:41, 14 January 2010
Line 5:		Line 5:

	# Install the latest version of the Quickbooks SDK (currently [http://tools.isoftdata.com/QBSDK80.exe 8.0])		# 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)		# 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		# Make sure the ITrack Quickbooks Toolkit is pointed at the same company file as the one open in Quickbooks

Daytonlowell: /* Grey text */

2010-01-13T17:28:21Z

Grey text

← Older revision		Revision as of 12:28, 13 January 2010
Line 20:		Line 20:
	===Grey text===		===Grey text===

	Grey text means that it can't be sent to Quickbooks~~, Because~~ another item needs to be pushed to QB first (ie. Invoice can't be pushed because Customer ~~need to be~~ pushed ~~first~~)		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===		===Grey background===

Daytonlowell: /* Grey background */

2010-01-13T17:27:28Z

Grey background

← Older revision		Revision as of 12:27, 13 January 2010
Line 24:		Line 24:
	===Grey background===		===Grey background===

	~~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.

	==Problems/Solutions==		==Problems/Solutions==