URGENT - abs_mstr question

[nate100]

I need to make sure that when a user does a sales order detail and tries to modify the site, that if there already exist a shipper/preshipper, it does not allow them to modify it.

In the abs_mstr table, how do I check to see if there is a preshipper/shippper for for a specific line item?

From what I see I would do the following:

Find first abs_mstr where abs_order = sonum and abs_line = linenum no-lock no-error.
If available abs_mstr then display
'There is a pre-shipper/shipper for this sales order number/line item'.

Please let me know if this is accurate.

Thanks

 

[W.Wulmsen]

Hello Nate100

Yes this is correct. The coding should look like

FIND FIRST abs_mstr
WHERE abs_domain = global_domain /* in case of eB2.1 */
AND abs_order = sod_nbr
AND abs_line = string(sod_line) NO-LOCK NO-ERROR.

William W.