ITrack/Enterprise/Work Order Accounting - Revision history

Dillon Sadofsky: /* GL Accounting Timeline */

2016-12-13T17:11:46Z

GL Accounting Timeline

← Older revision		Revision as of 12:11, 13 December 2016
Line 128:		Line 128:
	\| inventory.glcategory		\| inventory.glcategory
	\| Work Order Production		\| Work Order Production
	\| ~~Sum of all job~~.~~cost~~		\| workordermasterpart.averagecost + workordermasterpart.averagecorecost
	\| X		\| X
	\|		\|
Line 138:		Line 138:
	\| inventory.glcategory		\| inventory.glcategory
	\| Work Order Production		\| Work Order Production
	\| ~~workorder~~.~~price~~		\| workordermasterpart.averagecost + workordermasterpart.averagecorecost
	\|		\|
	\| X		\| X

Dillon Sadofsky: /* Tips and Tricks */

2016-08-26T19:52:33Z

Tips and Tricks

← Older revision		Revision as of 14:52, 26 August 2016
Line 152:		Line 152:

	<br>		<br>
	See also: [[Accounting ~~(Enterprise)~~]]		See also: [[ITrack/Enterprise/Accounting]]

	[[Category:ITrack/Enterprise/Concepts]]		[[Category:ITrack/Enterprise/Concepts]]

Dillon Sadofsky: /* Tips, Tricks, and Gotchas */

2016-08-26T19:51:09Z

Tips, Tricks, and Gotchas

← Older revision		Revision as of 14:51, 26 August 2016
Line 144:		Line 144:
	\|}		\|}

	==Tips, Tricks~~, and Gotchas~~==		==Tips and Tricks==
	* Work in progress accounting isn't required. If you chose not to use it, simply leave those parts of configuration empty. This will appear to create 'unbalanced' accounting configuration, but essentially the lineitems on the WO will take value out of their specific accounts for the amount of their cost, and the master parts will put the job total amount into its own account, which should balance out.		* Work in progress accounting isn't required. If you chose not to use it, simply leave those parts of configuration empty. This will appear to create 'unbalanced' accounting configuration, but essentially the lineitems on the WO will take value out of their specific accounts for the amount of their cost, and the master parts will put the job total amount into its own account, which should balance out.
	* If you want to use WIP accounting, make sure you use the same WIP account for all items. If you have multiple WIP accounts, they will end up with a net value in them because value will get put into Used Parts WIP, and value will be taken out of Vehicles WIP, which are never balanced against each other.		* If you want to use WIP accounting, make sure you use the same WIP account for all items. If you have multiple WIP accounts, they will end up with a net value in them because value will get put into Used Parts WIP, and value will be taken out of Vehicles WIP, which are never balanced against each other.

Dillon Sadofsky at 19:49, 26 August 2016

2016-08-26T19:49:21Z

← Older revision		Revision as of 14:49, 26 August 2016
Line 143:		Line 143:
	\| Only if the work order is 'work on inventory'		\| Only if the work order is 'work on inventory'
	\|}		\|}

			==Tips, Tricks, and Gotchas==
			* Work in progress accounting isn't required. If you chose not to use it, simply leave those parts of configuration empty. This will appear to create 'unbalanced' accounting configuration, but essentially the lineitems on the WO will take value out of their specific accounts for the amount of their cost, and the master parts will put the job total amount into its own account, which should balance out.
			* If you want to use WIP accounting, make sure you use the same WIP account for all items. If you have multiple WIP accounts, they will end up with a net value in them because value will get put into Used Parts WIP, and value will be taken out of Vehicles WIP, which are never balanced against each other.
			* If you check 'Estimate' on an open WO or void a WO, all current accounting (including WIP accounting) will get backed out and netted to $0. If this happens on a different day/period than the original document date, its possible you'll end up with corrective entries on a different day.
			* If you open and save an existing document that had any accounting errors, the net difference between the correct totals and the current totals will be added to the accounting queue with the current date. Its possible this will create corrective activity on a different period.
			* Changing gl category/context configuration after a WO document has been created/closed may not affect that document. Recreate the document if you are testing and want to make sure the new settings affect that document.

	<br>		<br>

Dillon Sadofsky: /* GL Accounting Timeline */

2016-08-26T19:21:43Z

GL Accounting Timeline

← Older revision		Revision as of 14:21, 26 August 2016
Line 23:		Line 23:

	==GL Accounting Timeline==		==GL Accounting Timeline==
	The following tables show detailed accounting information. The '''Item''' column describes the object that is being accounted. '''Timing''' describes the phase the accounting happens in (work in progress or finalization). '''Table''' is the database table that those objects are stored in. '''GL Category''' describes the gl category used to retrieve the accounts for accounting (if its in italics, that means the appropriate accounts are stored in the table, probably in the final...glaccountid or wip...glaccountid accounts). '''Context used''' quickly describes the gl context(s) used for accounting. WIP means Work In Progress, WOSold is Work Order Sold, and WOConsumed is Work Order Consumed (WIP..., WOSold..., or WOConsumed... mean either the context WIP, WIP Inherent Core, or WIP Dirty Core and so forth depending on the item type). '''Amount''' describes the value that will be accounted, which is normally the cost of the item for inventory account pairs and price of the item for transaction account pairs. Columns '''I''' and '''T''' simply describe which account pairs are hit in the accounting: inventory pair, transaction pair, or both.		The following tables show detailed accounting information. The '''Item''' column describes the object that is being accounted. '''Timing''' describes the phase the accounting happens in (work in progress or finalization). '''Table''' is the database table that those objects are stored in. '''GL Category''' describes the gl category used to retrieve the accounts for accounting (if its in italics, that means the appropriate accounts are stored in the table, probably in the final...glaccountid or wip...glaccountid accounts). '''Context used''' quickly describes the gl context(s) used for accounting. WIP means Work In Progress, WOSold is Work Order Sold, and WOConsumed is Work Order Consumed (WIP..., WOSold..., or WOConsumed... mean either the context WIP, WIP Inherent Core, or WIP Dirty Core and so forth depending on the item type). '''Amount''' describes the value that will be accounted, which is normally the cost of the item for inventory account pairs and price of the item for transaction account pairs. Columns '''Inventory''' and '''Transaction''' simply describe which account pairs are hit in the accounting: inventory pair, transaction pair, or both.

	{\| class="wikitable" border="1" cellpadding="1" cellspacing="1"		{\| class="wikitable" border="1" cellpadding="1" cellspacing="1"

Duff: /* Pertinent GL Contexts */ Fixing link that went to a redirect page

2009-10-20T17:23:33Z

Pertinent GL Contexts: Fixing link that went to a redirect page

← Older revision		Revision as of 12:23, 20 October 2009
Line 8:		Line 8:
	Work orders have several GL Contexts used in different situations, depending on the item being accounted and the item being accounted.		Work orders have several GL Contexts used in different situations, depending on the item being accounted and the item being accounted.

	* Work Order Production - used by the [[Work Orders ~~(Enterprise)~~#Master Part\|master part record]] on a work order for inventory (not on customer WOs).		* Work Order Production - used by the [[ITrack/Enterprise/Work Orders#Master Part\|master part record]] on a work order for inventory (not on customer WOs).
	* Work In Progress contexts - these contexts are designed to facilitate moving value into work in progress accounts. If a company doesn't use work in progress accounts, this context can be left empty. There are several specific contexts that are used depending on the item in question.		* Work In Progress contexts - these contexts are designed to facilitate moving value into work in progress accounts. If a company doesn't use work in progress accounts, this context can be left empty. There are several specific contexts that are used depending on the item in question.
	** Work In Progress - used by inventory items (and miscellaneous part items), labor, EPA charges, and shop fees when an open WO is saved. This context is designed to facilitate moving assets into a work in progress account.		** Work In Progress - used by inventory items (and miscellaneous part items), labor, EPA charges, and shop fees when an open WO is saved. This context is designed to facilitate moving assets into a work in progress account.

Duff: /* GL Accounting Timeline */ Updated to use Wiki table structure instead of HTML

2009-09-28T20:36:14Z

GL Accounting Timeline: Updated to use Wiki table structure instead of HTML

Show changes

Codeman at 18:37, 10 July 2009

2009-07-10T18:37:47Z

← Older revision		Revision as of 13:37, 10 July 2009
Line 42:		Line 42:
	<br>		<br>
	See also: [[Accounting (Enterprise)]]		See also: [[Accounting (Enterprise)]]
	~~[[Category:ITrack/Enterprise]]~~
	[[Category:ITrack/Enterprise/Concepts]]		[[Category:ITrack/Enterprise/Concepts]]

Codeman at 17:00, 10 July 2009

2009-07-10T17:00:24Z

← Older revision		Revision as of 12:00, 10 July 2009
Line 42:		Line 42:
	<br>		<br>
	See also: [[Accounting (Enterprise)]]		See also: [[Accounting (Enterprise)]]
	[[Category:Enterprise ~~Concepts~~]]		[[Category:ITrack/Enterprise]]
	[[Category:ITrack/Enterprise/Concepts]]		[[Category:ITrack/Enterprise/Concepts]]

Codeman at 16:08, 10 July 2009

2009-07-10T16:08:30Z

← Older revision		Revision as of 11:08, 10 July 2009
Line 43:		Line 43:
	See also: [[Accounting (Enterprise)]]		See also: [[Accounting (Enterprise)]]
	[[Category:Enterprise Concepts]]		[[Category:Enterprise Concepts]]
	[[Category:ITrack/Enterprise]]		[[Category:ITrack/Enterprise/Concepts]]