GET Item No.

koderman · 2015-10-29

On a Form I need to look at a Warehouse shipment line and pull the Item No. to compare whether that Item No. has an Item Packing Rule or not. So far I want to use IF WhseShptLine."Item No." = ItemPackingRule."Item No." THEN BEGIN... but I am not getting an Item No. Any suggestions on how to get the Item No.?

mohana_cse06 · 2015-10-30

you need to get the Item record first like
Item.Get(WhseShptLine."Item No."); //I hope you have value in WhseShptLine."Item No."

then you have to check like

IF Item."Item Packing Rule" <> '' THEN

koderman · 2015-10-30

What is Item representing? I am on the Warehouse Pack Scanning Form and calling the Tables: WhseShptLine(Warehouse Shipment line) and ItemPackingRule(Item Packing Rule).

mohana_cse06 · 2015-10-30

Item is a record type variable calling Item table.
Do you want to check whether Item Packing Rule field on Item table has a value or not?

Or please provide more details about the requirement

koderman · 2015-10-30

I am trying to get each item number in the Warehouse shipment Line and see if each of them exist in the Item Packing Rule.

mohana_cse06 · 2015-10-31

Then you have to repeat the

ItemPackingRule.SETRANGE("Item No.",WhseShptLine."Item No.");
IF ItemPackingRule.FINDFIRST THEN
...

you have to repeat the WhseShptLine to check for all records.

GET Item No.

Comments

Categories