I have a product category 'Computers' and I configured its Account Properties and Accounting Stock Properties.
And I have selected the following configuration under Settings -> Configuration:
- Warehouse -> Accounting -> Generate accounting entries per stock movement.
- Purchases -> Purchase Order -> Compute product cost price based on average cost.
Then I confirm a sales order for a product under 'Computers' category, create and validate the invoice and deliver the products.
I want to see:
- DR my Debtors account with the sales price.
- CR my Sales Income account with the sales price.
- DR my Cost of Sales account with the cost of goods sold.
- CR my Inventory account with the cost of goods sold.
But I can see only the two entries related to the sales journal. What am I missing in configuring the system to pass the stock journal entries?
Thank you zbik for trying to help me. I tried this with the demo data as well, and it contained the 'Cost of Goods Sold' account. Therefore, I don't think it is something related with account_anglo_saxon.
Thank you too Ivan, for your answer. I knew that the stock journal is related with the delivery orders, not with the sales orders. That is why I went through the workflow upto delivery: Confirmed the Sales Order -> Validated the Invoice -> Delivered the Products. But my stock journal related accounts were not updated and I wanted to figure out what I was missing in the configuration. After seeing your answer I looked in the stock moves records too. But I couldn't see any journal records there.
Finally I found out the answer.
In the product form, I have to set the Inventory Valuation in Accounting tab as 'Real Time (Automated)'.
Then the stock journal entries are displayed in Accounting -> Journal Entries -> Journal Entries in 'Unposted' status. I can select the record and post it to the general ledger.
If I want to skip that step and post the stock journal entry directly into the general ledger, I can edit the stock journal (Accounting -> Configurations -> Journals -> Journals) and select 'Skip 'Draft' State for Manual Entries' option.
The stock journal is not linked to the sale order or sale journal. It is linked to the develiry order. From Warehouse >> Traceability >> Stock Moves menu (the menu structure may differ from yours as it depends on the modules installed), search for the stock move that has References set to the sale order's number. Open that stock move and you can see the Journal Item table at the left bottom corner.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 12/22/14, 2:21 AM|
|Seen: 2694 times|
|Last updated: 3/16/15, 8:10 AM|