Buying Furniture for different departments

Any suggestions on how should I go about the following scenario:

Purchase invoice received from Supplier as follows:

  1. Office Desk Exec 4x6 Qty= 6 @ 5000/- each. Total 30,000/-
  2. Office Desk Reg 3x5 Qty=2 @ 4000/- each. Total 8,000/-
  3. Office Chairs Exec Qty=24 @ 5000/- each. Total 120,000/-
  4. Office Chairs Reg Qty=8 @ 2500/- each. Total 20,000/-

Invoice total= 178,000/-

Office Desk/Chair Exec will be going to 4 different departments to 6 people. And Desk/Chair Reg will be going to 2 different departments to 2 people.

How should I create Dimensions and tag each desk and chair with an Asset number so we can track the asset? The supplier has given only ONE INVOICE.

I hope I have conveyed the problem statement properly.

Location field in the line item should be possible to use. After the assets are created, you can always relocated it to the correct dept.

Moving the asset to the right department does not always help distribute the furniture to the offices by different addresses

Hi,
In ERPNEXT you can’t have child table of a child table.
Yout PO has a header, lines, but no disttibution.
Line and dimension relation is one to one, unless you keep writing in a text field all story, I mean dept name, emplyee name and so on, it’s unstructured data in this case.
Other option to make new doctype for distribution, heder is po-line number, and child table will be dept name, employee name etc.
Hope I give some help to you

Nmami, thank you for your help. I guess I’ll create a separate doctype. It may be more comfortable to use it, I hope. We’ve bought about 30 chairs on eurekaergonomic.com, so it’s gonna be a real journey managing those “assets,” you know. Anyway, I hope I won’t get into the same trouble next time. By the way, what chairs have you bought? I wonder what furniture other companies buy for their offices. We mostly have IKEA and Eureka Ergonomic furniture. Let me know what furniture you have.