UOM Visual UPDATE

Savatage · 2005-12-08

sorry it's the best description I could think of at the time.

OK I have created a seperate tab for Unit Of Measure on my Item Card.

Example/
Base Unit of Measure : EA
Sales Unit of Measure : DL
Purch Unit of Measure : TR

What I would like to do is pull the "Qty. per Unit Of measure" for each corresponding code and show it in a text box or something.

So the final Result Would Look Like

Base Unit of Measure : EA [1]
Sales Unit of Measure : DL [6]
Purch Unit of Measure : TR [360]
[ ] being the text box

Help Thanks

DenSter · 2005-12-09

Lookup Flowfield into the Qty Per field of the Item Unit of Measure table where Item # = No, Code = Base UOM Code, or Purch UOM Code, or Sales UOM Code

Another way could be to program the OnAfterGerCurrRecord to get three Item UOM records with those values if they are not blank and setting the Source Expr of the textboxes to their Qty Per field.

Let me know if this doesn't make sense. I am very tired at this point, and I may not make very much sense

Savatage · 2005-12-09

i was thiniing of somthing totally different & complex - using GET - but this is much easier. Sometimes you can see the forest thru the trees - thanks

Savatage · 2005-12-09

{ 50050;  ;Base UOM Qty        ;Decimal       ;FieldClass=FlowField; CalcFormula=Lookup("Item Unit of Measure"."Qty. per Unit of Measure" WHERE (Item No.=FIELD(No.), Code=FIELD(Base Unit of Measure))); DecimalPlaces=0:0 }

    { 50051;  ;Sales UOM Qty       ;Decimal       ;FieldClass=FlowField; CalcFormula=Lookup("Item Unit of Measure"."Qty. per Unit of Measure" WHERE (Item No.=FIELD(No.),  Code=FIELD(Sales Unit of Measure))); DecimalPlaces=0:0 }

    { 50052;  ;Purch UOM Qty       ;Decimal       ;FieldClass=FlowField;  CalcFormula=Lookup("Item Unit of Measure"."Qty. per Unit of Measure" WHERE (Item No.=FIELD(No.),Code=FIELD(Purch. Unit of Measure))); DecimalPlaces=0:0 }

DOH!

DenSter · 2005-12-09

Does it work the way you want?

Savatage · 2005-12-09

PERFECTLY!

DenSter · 2005-12-09

Cool excellent \:D/

Marije_Brummel · 2005-12-09

Don't you just love Navision

:oops:

PS. remember to put a calcfields in the validate trigger.

O:)

DenSter · 2005-12-09

I do, it's so sophisticated and advanced \:D/

Marije_Brummel · 2005-12-09

Especialy the C/AL editor =P~

Savatage · 2005-12-09

The Bonus side is now i can divide the QOH by Sales UOM Qty so the warehouse people know exactly whats left on the shelf.

Say we had an item with 157 pieces in one box. We sell it as one display (1 box) of which we have 32 displays the. QOH would show 5,024 - not clear to the warehouse people. Now it show's the correct 32 displays.

I should have done it a while ago..but we just hired new people in the warehouse & they were screwing up the orders.

DenSter · 2005-12-09

If you have an Item UOM BOX with 10 EACH, then having 100 EACHes on hand does not always mean you have 10 boxes. You coud also add QOH flowfields in the units on the Item to calculate the quantity in the ILE filters on the right UOM

.

Savatage · 2005-12-09

don't really need to go crazy - everything is fine. It's just that 3 years ago I created a special screen just for the warehouse pickers. There are 5 computers scattered around the warehouse that can be accessed if they have a question about something. Note when they login it goes right the screen pictured in the link below.

just has: (VERY LARGE)
description
item number
Shelf-Bin
Qty On hand
...the basics
It hasn't been updated since then.
I happen to spend some time on it yesterday

Adding Picture
Check boxes of Discontinued Date (if so)
Vendor Item Number
& some other little chotzkies.

But the QOH always was in pieces because we set-up out UOM's with the smallest possible unit. It's nice for them to know what they are supposed to pic or if they are doing a cycle count.

Lol - i was gonna go crazy & start looking at the Unit of Measure Management codeunit & stuff. This was so easy I didn't see it.

http://www.geocities.com/navision_attain/WareScreen.jpg

UOM Visual UPDATE

Comments

Categories