Gross Profit and Cost Column Definitions - Revision history

Trevor at 00:22, 22 April 2009

2009-04-22T00:22:49Z

← Older revision		Revision as of 00:22, 22 April 2009
Line 1:		Line 1:
	Created: 14 April 2009. Last Reviewed: 14 April 2009		Created: 14 April 2009. Last Reviewed: 22 April 2009


Line 56:		Line 56:

	=== View vwSaleLine_GP Cost and Gross Profit Columns ===		=== View vwSaleLine_GP Cost and Gross Profit Columns ===
	This view combines sales data from table SaleLine with stock cost data from table StockMovement to provide the most accurate possible GP reporting. In the column descriptions below, “if available” means if a matching stock movement row is found for the SaleLine. In some cases the StockMovement row might be missing, for example in the ~~minimallyt~~ supported scenario where sales are recognised upon creation of a customer order or layby, but stock is not decremented until the order or layby is completed. In such case there is no StockMovement row to match the Sale, therefore no strictly accurate cost or GP is available.		This view combines sales data from table SaleLine with stock cost data from table StockMovement to provide the most accurate possible GP reporting. In the column descriptions below, “if available” means if a matching stock movement row is found for the SaleLine. In some cases the StockMovement row might be missing, for example in the minimally supported scenario where sales are recognised upon creation of a customer order or layby, but stock is not decremented until the order or layby is completed. In such case there is no StockMovement row to match the Sale, therefore no strictly accurate cost or GP is available.

Trevor at 00:20, 22 April 2009

2009-04-22T00:20:57Z

← Older revision		Revision as of 00:20, 22 April 2009
Line 24:		Line 24:
	'''FCCost'''		'''FCCost'''

	SQL Server stored procedure UpdateStock looks up the configuration for the branch to determine that branch's stock valuation configuration option – i.e. WAC or list cost. Based on this configuration, the current cost for the Branch/SKU is retrieved. If this is null of $0.00, uses BuyPrice1 for the branch/SKU.		SQL Server stored procedure UpdateStock looks up the configuration for the branch to determine that branch's stock valuation configuration option – i.e. WAC or list cost. Based on this configuration, the current cost for the Branch/SKU is retrieved. If this is null or $0.00, uses BuyPrice1 for the branch/SKU.

Trevor at 00:19, 22 April 2009

2009-04-22T00:19:03Z

← Older revision		Revision as of 00:19, 22 April 2009
Line 3:		Line 3:

	=== Table StockMovementTbl Cost and Gross Profit Columns ===		=== Table StockMovementTbl Cost and Gross Profit Columns ===
	The stock movement table contains a row for every movement of stock, including a row ~~assocaited~~ with every sale or return line item. Except in complex cases such as multi-packs and kits, there is a 1 : 1 relationship between rows in SaleLine and StockMoveTbl. However, not all stock movement rows have associated SaleLine rows – consider stock receipts, transfers etc.		The stock movement table contains a row for every movement of stock, including a row associated with every sale or return line item. Except in complex cases such as multi-packs and kits, there is a 1 : 1 relationship between rows in SaleLine and StockMoveTbl. However, not all stock movement rows have associated SaleLine rows – consider stock receipts, transfers etc.

Bevan at 00:49, 14 April 2009

2009-04-14T00:49:49Z

← Older revision		Revision as of 00:49, 14 April 2009
Line 87:		Line 87:

	SaleLine.FCExtendedNetAmount – SaleLine.FCExtendedTaxAmount – ExtendedAlternateGPCost.		SaleLine.FCExtendedNetAmount – SaleLine.FCExtendedTaxAmount – ExtendedAlternateGPCost.


			= See Also: =
			[http://theoracle.magentaretail.com.au/wiki/index.php/BDE_Versions ]

Bevan: New page: Created: 14 April 2009. Last Reviewed: 14 April 2009 === Table StockMovementTbl Cost and Gross Profit Columns === The stock movement table contains a row for every movement of stock, inc...

2009-04-14T00:49:11Z

New page: Created: 14 April 2009. Last Reviewed: 14 April 2009 === Table StockMovementTbl Cost and Gross Profit Columns === The stock movement table contains a row for every movement of stock, inc...

New page

Created: 14 April 2009. Last Reviewed: 14 April 2009

=== Table StockMovementTbl Cost and Gross Profit Columns ===
The stock movement table contains a row for every movement of stock, including a row assocaited with every sale or return line item. Except in complex cases such as multi-packs and kits, there is a 1 : 1 relationship between rows in SaleLine and StockMoveTbl. However, not all stock movement rows have associated SaleLine rows – consider stock receipts, transfers etc.

Note columns prefixed with FC are in the currency local to the branch (for EEE instances supporting branches in different countries). The Non-FC version of the column has the amount in the local currency of EEE as converted using user-defined exchange rates.

The population of cost and gross profit columns in table StockMovementTbl for stock movements associated with sales is:

'''Cost'''

FCCost * ExchangeRate

'''TotalCost'''

This is an SQL Server computed column: isnull (ActualTotalCost, Cost*Quantity)

'''FCCost'''

SQL Server stored procedure UpdateStock looks up the configuration for the branch to determine that branch's stock valuation configuration option – i.e. WAC or list cost. Based on this configuration, the current cost for the Branch/SKU is retrieved. If this is null of $0.00, uses BuyPrice1 for the branch/SKU.

Finally, any oncost amount passed back from POS is added to this cost, however for sales POS will always return oncost of $0.00.

'''FCTotalCost'''

This is an SQL Server computed column: isnull (FCActualTotalCost, FCCost*Quantity)

'''OnCost'''

This is populated with the unit on-cost amount passed back from POS, always $0.00 for sales.

'''ActualTotalCost'''

FCActualTotalCost * ExchangeRate

'''FCActualTotalCost'''

FCCost * Qty.

'''AlternateGPCost'''

Cost.AlternateGPCost except client code 22 which uses BuyPrice1 for warehouse branch

=== View vwSaleLine_GP Cost and Gross Profit Columns ===
This view combines sales data from table SaleLine with stock cost data from table StockMovement to provide the most accurate possible GP reporting. In the column descriptions below, “if available” means if a matching stock movement row is found for the SaleLine. In some cases the StockMovement row might be missing, for example in the minimallyt supported scenario where sales are recognised upon creation of a customer order or layby, but stock is not decremented until the order or layby is completed. In such case there is no StockMovement row to match the Sale, therefore no strictly accurate cost or GP is available.

'''ExtendedCostAmount'''

If available, StockMovementTbl.TotalCost else SaleLine.ExtendedCostAmount.

'''GrossProfit'''

If available, SaleLine.ExtendedNetAmount – SaleLine.ExtendedTaxAmount – StockMovementTbl.TotalCost else SaleLine.GrossProfit.

'''FCExtendedCostAmount'''

If available, StockMovementTbl.FCTotalCost else SaleLine.FCExtendedCostAmount

'''FCGrossProfit'''

If available, SaleLine.FCExtendedNetAmount – SaleLine.FCExtendedTaxAmount – StockMovementTbl.FCTotalCost else SaleLine.FCGrossProfit.

'''ExtendedAlternateGPCostAmount'''

StockMovementTbl.AlternateGPCost * SaleLine.Quantity. However if this is NULL, as will be the case when Cost.AlternateGPCost is null, then SaleLine.ExtendedCostAmount except for client code 22 which uses Cost.BuyPrice1 for branch 99 * SaleLine.Quantity.

'''GrossProfitAlternateGP '''

SaleLine.FCExtendedNetAmount – SaleLine.FCExtendedTaxAmount – ExtendedAlternateGPCost.