Skip to Content
0
Former Member
Mar 12, 2009 at 01:56 PM

Account manage

38 Views

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