Inventory Reconciliation - Revision history

Chanson: /* Products */

2023-10-26T18:03:33Z

Products

Chanson: /* G/L Transactions */

2023-10-26T17:57:10Z

G/L Transactions

Chanson: /* See Also */

2023-10-25T18:17:57Z

Chanson: /* See Also */

2023-10-25T18:17:43Z

Chanson: /* G/L Transactions */

2023-10-24T19:24:27Z

G/L Transactions

Chanson: /* G/L Transactions */

2023-10-24T19:03:00Z

G/L Transactions

Chanson: /* G/L Transactions */

2023-10-24T18:56:55Z

G/L Transactions

Chanson: /* G/L Transactions */

2023-10-24T18:13:31Z

G/L Transactions

Chanson at 18:12, 24 October 2023

2023-10-24T18:12:22Z

Chanson: /* G/L Transactions */

2023-10-24T16:10:31Z

G/L Transactions

@@ Line 27: / Line 27: @@
 ===Products===
-In addition to the Sales G/L and Cost of Sales G/L you will need:
+In addition to the Sales G/L you will need:
 *Inventory G/L
 *A/P Clearing G/L

@@ Line 98: / Line 98: @@
 | L || Last Cost || . || . ||  || Actual || Last Cost from Purchase Reciept or PO Inventory Receipt or Previous Last Cost Record
 |-
-| D || Production Receipts (No Components) || INVENTORY_GL || PRODUCTION_GL_IN || Standard || Standard || Item is produced without any components.
+| D || Production Receipts (No Components) || Inventory GL || Production In GL || Standard || Standard || Item is produced without any components.
 |-
-| M || Miscellaneous || INVENTORY_GL || Manually Entered || Standard || Running Avg. || Useful for unrecorded COGS, Inventory Adjustments and lost amounts.
+| M || Miscellaneous || Inventory GL || Manually Entered || Standard || Running Avg. || Useful for unrecorded COGS, Inventory Adjustments and lost amounts.
 |-
-| R || Purchase Receipt (unlinked to AP/PO) || INVENTORY_GL (D) || APCLEAR_GL(C) || Actual || Actual || The AP Clearing account amount from purchase receipts should wash against the AP Clearing amount from AP Vouchering.
+| R || Purchase Receipt (unlinked to AP/PO) || Inventory GL (D) || AP Clear GL(C) || Actual || Actual || The AP Clearing account amount from purchase receipts should wash against the AP Clearing amount from AP Vouchering.
 |-
 | I || PO Inventory Receipt (linked to AP/PO) || . || . || Actual || Actual || Related G/L created when linked to invoice and invoice posted. For Stocked items this is a Debit to Inventory, Credit to A/P, For Non-Stocked items this is Debit to Inventory and credit to Cost of Goods Sold.
 |-
-| S || Sale || INVENTORY_GL (C) || COSTOFSALES_GL (D) || Standard || Running Avg. || Record costs of Stocked Items.
+| S || Sale || Inventory GL (C) || Cost Of Sales GL (D) || Standard || Running Avg. || Record costs of Stocked Items.
 |-
-| P || Physical || INVENTORY_GL || Manually Entered || Standard || Running Avg. || When Reconcile crosses a P entry, it will determine the qty difference between the physical inventory record and the current running inventory calculation. The G/L entry will be based on the current running avg. cost and this calculated qty.
+| P || Physical || Inventory GL || Manually Entered || Standard || Running Avg. || When Reconcile crosses a P entry, it will determine the qty difference between the physical inventory record and the current running inventory calculation. The G/L entry will be based on the current running avg. cost and this calculated qty.
 Do not backdate before last Reconciled Transaction!
 |-
-| V || Production Rcpt Out (No components) || INVENTORY_GL (C) || PRODUCTION_GL_OUT || Standard|| Running Avg.|| Reduction of inventory to the components during production when these component do not consist of other compenents (bottom level).
+| V || Production Rcpt Out (No components) || Inventory GL (C) || Production Out GL || Standard|| Running Avg.|| Reduction of inventory to the components during production when these component do not consist of other compenents (bottom level).
 |-
-|  || Production Rcpt Out (Components) || INVENTORY_GL (C) || PRODUCTION_GL_OUT || Matching Production In / Qty Out || Matching Production In / Qty Out || Reduction of inventory to the components during production when these component do consist of other compenents (Mid-Level).  The Total matching Production In cost is used as the Total Production Out cost.
+|  || Production Rcpt Out (Components) || Inventory GL (C) || Production Out GL || Matching Production In / Qty Out || Matching Production In / Qty Out || Reduction of inventory to the components during production when these component do consist of other compenents (Mid-Level).  The Total matching Production In cost is used as the Total Production Out cost.
 |-
-| W || Production Rcpt In || INVENTORY_GL (D) || PRODUCTION_GL_IN || Production Cost / Qty In || Production Cost / Qty In || Increase of inventory to the assembly product during production.
+| W || Production Rcpt In || Inventory GL (D) || Production In GL || Production Cost / Qty In || Production Cost / Qty In || Increase of inventory to the assembly product during production.
 |-
-| X || Transfer Out || INVENTORY_GL || AP_CLEAR_GL || Standard || Running Avg. || Inventory Reduction from Transfer Out.  Linked to Y record.
+| X || Transfer Out || Inventory GL || AP Clear GL || Standard || Running Avg. || Inventory Reduction from Transfer Out.  Linked to Y record.
 |-
-| Y || Transfer In || INVENTORY_GL || AP_CLEAR_GL || Transfer Out Cost / Qty In || Transfer Out Cost / Qty In || Inventory Increase from Transfer In.  Cost comes from X record.
+| Y || Transfer In || Inventory GL || AP Clear GL || Transfer Out Cost / Qty In || Transfer Out Cost / Qty In || Inventory Increase from Transfer In.  Cost comes from X record.
 |}
 ===Resulting Output===

@@ Line 195: / Line 195: @@
 ==See Also==
-[[Inventory Reconciliation Report Queries]]
+:[[Inventory Reconciliation Report Queries]]
-[[Inventory: Understanding Average Cost]]
+:[[Inventory: Understanding Average Cost]]

← Older revision		Revision as of 18:17, 25 October 2023
Line 196:		Line 196:
	==See Also==		==See Also==
	[[Inventory Reconciliation Report Queries]]		[[Inventory Reconciliation Report Queries]]
		+	[[Inventory: Understanding Average Cost]]

@@ Line 113: / Line 113: @@
 | V || Production Rcpt Out (No components) || INVENTORY_GL (C) || PRODUCTION_GL_OUT || Standard|| Running Avg.|| Reduction of inventory to the components during production when these component do not consist of other compenents (bottom level).
 |-
-|  || Production Rcpt Out (Components) || INVENTORY_GL (C) || PRODUCTION_GL_OUT || Matching Production In || Matching Production In || Reduction of inventory to the components during production when these component do consist of other compenents (Mid-Level).  The matching Production In cost is used as the Production Out cost.
+|  || Production Rcpt Out (Components) || INVENTORY_GL (C) || PRODUCTION_GL_OUT || Matching Production In / Qty Out || Matching Production In / Qty Out || Reduction of inventory to the components during production when these component do consist of other compenents (Mid-Level).  The Total matching Production In cost is used as the Total Production Out cost.
 |-
 | W || Production Rcpt In || INVENTORY_GL (D) || PRODUCTION_GL_IN || Production Cost / Qty In || Production Cost / Qty In || Increase of inventory to the assembly product during production.

@@ Line 96: / Line 96: @@
 | C || Standard Cost || . || . ||  || Standard || Created in product maintenance when std. cost changes. Used to determine prior values of std. cost.l
 |-
-| L || Last Cost || . || . ||  || Actual || Last Cost from Purchase or Previous Last Cost Record
+| L || Last Cost || . || . ||  || Actual || Last Cost from Purchase Reciept or PO Inventory Receipt or Previous Last Cost Record
 |-
 | D || Production Receipts (No Components) || INVENTORY_GL || PRODUCTION_GL_IN || Standard || Standard || Item is produced without any components.

@@ Line 89: / Line 89: @@
 ===G/L Transactions===
 {| class="wikitable"
 ! Trx Type !! Description !! INVENTORY !! OFFSET !! Default Cost(at time trx is created) !! Reconcile Cost !! Comment
@@ Line 123: / Line 120: @@
 |}
-====old====
+<!--
   {| border=1
   || . || Description         || INVENTORY || OFFSET || Comment
@@ Line 155: / Line 153: @@
 |-
 |}
 ===Resulting Output===