Buying Furniture for different departments

ERPNext Asset Management
#1

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.

#2

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.

#3

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

#4

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

#6

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.