Automatic Posting of Material Consumption

Automatic Posting of Material Consumption

When posting stock by retail price, automatic posting of material consumption is somewhat more demanding.

For an example of reports of material consumption calculations and journal entries created on the basis of data shown here, see Posting by Retail Prices in Material Consumption.

for an issued invoice

Date	Document	Quantity	Valuation price	Value of Stock	Included Gross Margin	Included VAT
08.03.02	02310000003	1	105	216	75	36

With the predefined values from document type 310 a journal entry where the contra-account is the value of the stock of goods by retail price minus included gross margin and VAT, is created, and an expense account with the purchase value of the goods.

Account	Description	Debit	Credit	Setting
6630	Inventory account - retail		216	Inventory account (CREDIT) from settings in Issue document type
6690	Included gross margin- retail	75		Included gross margin (CREDIT) from settings in Issue document type
6640	Included VAT - retail	36		Included VAT (CREDIT) from settings in Issue document type
7110	Purchase value of goods sold	105		Purchase value of goods sold (DEBIT) from settings in Issue document type

 Consumption will be calculated the same way for POS issues.

For transfer TO retail warehouse

Date	Document	Quantity	Valuation Price	Value of Stock	Included Gross Margin	Included VAT
11.03.02	02200000003	1	105	216	75	36

With the predefined values from document type 200, a journal entry, where the debit contra-account is the value of the stock of goods by retail price minus included gross margin and included VAT, and the stock account is from a different warehouse.

Account	Description	Debit	Credit	Setting
6600	Inventory account - wholesale	105		Inventory account at destination warehouse (DEBIT) from transfer document type
6630	Inventory account - retail		216	Inventory account of issuing warehouse (CREDIT) from transfer document type
6690	Included gross margin- retail	75		Included gross margin of issuing warehouse (DEBIT) from transfer document type
6640	Included VAT - retail	36		Included VAT of issuing warehouse(DEBIT) from transfer document type

 

For transfer FROM retail warehouse

Date	Document	Quantity	Valuation Price	Value of Stock	Included Gross Margin	Included VAT
11.03.02	02210000002	1	105	216	75	36

With predefined document type 210, a journal entry similar to the one for an issued invoice is created. Only in this case, the debit contra-account is the stock account of a different warehouse.

Account	Description	Debit	Credit	Setting
6600	Inventory account - wholesale	105		Inventory account of destination warehouse(DEBIT) from settings in Transfer document type
6630	Inventory account - retail		216	Inventory account of issuing warehouse (CREDIT) from settings in Transfer document type
6690	Included gross margin- retail	75		Included gross margin of issuing warehouse (DEBIT) from settings in Transfer document type
6640	Included VAT - retail	36		Calculated VAT of issuing warehouse (DEBIT) from settings in Transfer document type

 

For change of retail price

Date	Document	Quantity	Current Retail Price	Included Gross Margin	Included VAT	New Retail Price	Change of Retail Price	Change of Included Gross Margin	Change of Included VAT
31.03.02	02SC000001	1	216	75	36	240	24	20	4

 

Calculation:

- (CSP) change of sale price: 240 - 216 = 24

- (CTB) change of tax base = change_of_sale_price/tax_factor: 24/1.2 = 20

- (CVAT) change of included VAT= CSP * tax_rate/tax_factor: 24 * 0.2/1.2 = 4

- (CGM) change of included gross margin = CGM - CVAT: 24 - 4 = 20

 

The journal entry created with predefined document type SC0.

Account	Description	Debit	Credit	Setting
6630	Goods account	24		Inventory account of destination warehouse (DEBIT) from settings in Price Change document type
6690	Included gross margin		20	Included gross margin (CREDIT) from settings in Price Change document type
6640	Included VAT		4	Included VAT (CREDIT) from settings in Price Change document type

 

---