• Registered: 10/07/2011
  • Posts: 7

Topic: How to manage inventory by KG and number of bages

Dear Sir,

One of our client want to manage its inventory by KGs and number of bags. Can FA help both one time. eg; he wants to know the quantity of inventory by KGs and number of bags at a time.

Waiting....

....
Salman

  • tom
  • Senior Member
  • Offline
  • From: USA, FL, Tampa
  • Registered: 03/24/2009
  • Posts: 288

Re: How to manage inventory by KG and number of bages

You can define  your own units for each inventory item.

I maintain bulk inventory in LBS of which I 'manufacture' bags of 1/4, 1/2, 3/4 and 1LB, so it sounds a lot like what they need.

I buy things in 50lbs or 20kg buckets and use the purchasing pricing and UOM conversion to restock myself.

tom

tom's Website

  • Registered: 10/07/2011
  • Posts: 7

Re: How to manage inventory by KG and number of bages

Sir,

can we define tow different UOM for one item eg; we want to see for one item in number of bags and in KGs as well.

...
Salman

  • tom
  • Senior Member
  • Offline
  • From: USA, FL, Tampa
  • Registered: 03/24/2009
  • Posts: 288

Re: How to manage inventory by KG and number of bages

Not for the *same* item, but I do have for example

STONE Bulk with UOM 1LB and
4LB Stone with UOM each

The Bulk stone is my purchased inventory and the 4LB Bag is a Manufactured Item.

Here is the general flow of a given Raw Material:

1) Buy 50lb box of Lab Stone (Supp Unit 50lb Box, Conversion factor 50)
2) STONE Inventory Level becomes 50
3) Sell 5 Units of Stone Bulk
4) STONE Inventory Level becomes 45
5) Get an Order for 3 4LB Bags of stone
6) Manufacturer 3 "4LB Bags"
7) STONE Inventory Level becomes 33

You can have different versions so long as you can manufacturer the secondary items.

tom

tom's Website