If one of the warehouses is marked as a warehouse, where you want to post inventory by retail prices, then posting material consumption is a little more complex. Not only do you have to post the inventory account and its contra account, but you also have to post the sales price (VAT excluded), the imputed gross margin and the VAT imputed to the retail price.

Posting by retail prices, which is different from other methods of costing, where each document (in detailed report) or any other document type combination - the item type (in summary report) represents one record in the statement report and two posts in journal entry (one for posting to the debit and the other for posting to the credit side) - requires a more comprehensive statement of account and a more comprehensive posting.

In such cases calculation of posting data and the preparation of the report takes more time!

The example of the material consumption report by using predefined document types together with the data from the example as described in the topic Examples - Inventory Costing - Inventory Posting by Retail Price:

Detailed Report by Documents

Data summary is performed by individual documents.

Summary Report by Document Types

Data summary is performed on the level of document and item type over the entire selected posting period.

Journal Entry for Detailed Posting: