how to join abs_mstr?

[benedictine191]

hi all,i'm a newbie in mfgpro...
i am now developing report in mfgpro...
the report which i must built was "Sales Order Shipment report"...i have a trouble to display abs_mstr table...may i ask,which table i must used to show abs_mstr field?


PS: now i used table so_mstr,sod_det,pt_part,cm_addr

which table i must join with abs_mstr?and can you tell me what attributes between those table i must connect?

thanks

regards,

felix

 

[tamhas]

Posting on the MFG/pro forum might be a good start.

 

[sgs.prasad]

In abs_mstr there is one field which stores the sales order number. Please check the table fields of the abs_mstr.

 

[daranroo7]

Hi,
As said above you can try it in MFG/PRO forum...
anyways let me share what i know... abs_mstr in MFG/PRO is a tricky table wherein header and detail records be in the same table.

for example: lets say we have a scenario like below;-
Shipper number: Shipper1
Sales order number : SO1
Item numbers which are with this shipper: item1 of qty 50
item2 of qty 60
item3 of qty 70.

the query has to be like below..

define buffer abs for abs_mstr.
for each abs_mstr no-lock where abs_shipfrom = <ship-from-site>
and abs_id = "s" + "Shipper1":
disp abs_id abs_order ------------------------------------> this gives the shipper number (shipper1) and Sales order number (SO1)
for each abs no-lock where abs_ship_from = abs_mstr.abs_ship_from
and abs_par_id = abs_mstr.abs_id no-lock:
disp abs.abs_item abs.abs_qty ---------------------------> this gives you the item and its quantity
end.
end.

if you further want to proceed to another level, do a for each of another buffer with parent id as first buffer's abs_id.

Hope this clarify ur doubt.

Thanks and Regards,
Daniel Ranjit.R