add field to form from another table, form 7339

We always ship one sales order on one shipment and therefore it would be much easier for us to see the sales order number and customer name in the shipment list. How can i add these two fields to this form?

Nav 6.0

Hi

The fields which you wnat in the posted sales shipment list is already available.if it is not visible then Right click on the coloumn header and select show coloumns and select the required fieds.Also reffer the attached picture

1411.PostedShipments.bmp (364 KB)

Thanks

Marshal.J

If You need sales order number and customer name in the form 7339 then it ill required bit customization

Thanks

Jerome marshal.J

Hi

Step1:


Create below fields in Warehouse Shipment header table

ID Name Data Type length

99998 Sales Order No Code 30
99999 Customer Name Text 50

Step2:

Create below record type variable in form Warehouse Shipment

Name Data Type SubType

WhsShipmentLine Record Warehouse Shipment Line

Step3

Create below record type variable in form Warehouse Shipment

Name Data Type SubType

SalesOrder Record Sales header

Step4

place the below code at the Get Source Documents menu Item of Menu button Functions of form Warehouse Shipment form

WhsShipmentLine.reset;
WhsShipmentLine.get(’“rec.No.”’);
if WhsShipmentLine.find(’-’) then
begin
if WhsShipmentLine.“Source Document” = WhsShipmentLine.“Source Document”::“Sales Order” then
begin
SalesOrder.reset;
if SalesOrder.get(WhsShipmentLine.“Source No.”) then
begin
rec.“Sales Order No”:= SalesOrder.“No.”;
rec.“Customer Name” :=SalesOrder.“Customer Name”;
rec.modify;
end;
end;

end;

Step5:

Open the form no 7339 in design mode and add the two newly added fields to the screen

Thats alllll

Thanks
Marshal.J

Thanks for the help this will take care of it.