I want to manage my finished goods items like this structure.
All Item Account Manage by Item Group.
1.-Finished Goods(BOM Parent Item)
1.1- Raw Materials (Child Item)
1.2- Packing Materials(Child Items)
1.3- Consumabels Materials(Child Item)
These Items have proper group and Mapped with Account.
1.The inventry Account of Raw Materials Group is Raw Materials in Asset Drower
2.The inventry Account of Packing Materials Group is Packing Materials in Asset Drower
3.The inventry Account of Consumabels Materials Group is Consumabels Materials in Asset Drower
All Inventry Account Have opening balance
Raw Materials 500 Rs. and Quantity is 5
Packing Materials 500 Rs. Quantity is 5
Consumables 500 Rs. Quantity is 5
we create a production order for finished goods with one quantity.
Issued for production
WIP Account Debited by 300
Raw Materials credited by 100
Packing Materials Credited by 100
Consumables Materials credited by 100
Received From Production
Finished Goods Account is Debited by 300
WIP Account Credited by 300
And Finally
Raw Materials 400 Rs. and Quantity is 4
Packing Materials 400 Rs. Quantity is 4
Consumables 400 Rs. Quantity is 4
Finished Goods Account Debited by 300 Rs. Quantity 1
Create a A/R Delivery Documents
Inventory Account of finished goods credited by 300
Cost of sold - Finished good Debited by 300
Now , according the upwritten scenario.
I want to get a report about Accounts that how much issued for production group wise
and how much i have Purchased the Child item before Issuing for production .
Please suggest the solution
thanks