• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Physical location

hissam78

Active Member
Dear all,
we have 3 stores (Dry, Frozen, Fresh) each store have bins, we want enter the physical location of Item in Jde, for example we have following item CP Espresso Capsules 50gx10 located in Dry Store on bin No. 10.
so how we can define in JDE.

so that we can search the item in Jde, actually where our item exist in Warehouse physically.


please help!!!!


best regards

shafiq malik
 

Rauf

VIP Member
To define a location, you can use P4100 (Location Master). Then you can use P41024 (Item Location Information) to enter the quantity.
 

hissam78

Active Member
Dear Mr. Rauf thanks for reply, Location master and Item Location information is defined and lot Serial no. also defined in P4108 but what i requested is, Our stock on Dry store having location of Item, on bin # 10. so bin number 10 and dry store, where we will enter for reference. so that we can print a report and can see where physically this item exist in the store?

For example like WMS, we scan and can come to know that item exist on Dry Store and on Bin # 10. we do not have WMS therefore we want to enter the physical location of our item in JDe. so that we can see from the jde where physically our item exist.


best regards
 

Rauf

VIP Member
shafiq,

Please let me know how did you define the entities (Dry, Frozen, Fresh) . Are they defined as Branch/Plants or ...?
 

hissam78

Active Member
Dear Mr. Rauf,
for example we have one Item having Code = 10-058-001 Semi Dried Tomatoes 1Kg,
in this code 10 means FROZEN item defined in Category codes SRP1 in Item Master,
058 means brand OLIVES defined in Category Code SRP2 in Item Master.
and 001 is the serial Number of Item.

Our Branch Plant is 80800 for Our UAE Location
for each branch plant we enter the Item branch plant.
for example in Item Branch plant for code 10-058-001 having Branch plant 80800, so we can sale and purchase this item from 80800 BP.
and each Item Code have a lot number that defined in Lot Master.
For Each Item we add the Location in P41024 with Branch Plant 80800 and Location selected from Location Master. e.g.(FZ01 for FROZEN ITEMS)


Now request is, how to find the physical location of Item 10-058-001, where actually it resides. either it is in DRY store or in FROZEN store,
if in FROZEN store so what is bin # etc. so BIN # and FROZEN STORE we want to define somewhere so that we can get the report and find the exact physical location of our item 10-058-001

thank you
 

Rauf

VIP Member
Then, we have to create 'Location' for Frozen, Dry, Fresh using Location Master application. We can use the category code (LA03, LA04 etc) for this.
 

hissam78

Active Member
Thank a lot Dear, I have found the LA03 and LA04 in Location Master but it is defined at Branch plant level, in One branch plant we have thousands of items so for each item we need a physical location and bin #. so Location or Bin number we need to define at Item Level not at branch plant level.

thanks
 
Last edited:
Top