URGENT - abs_mstr question

nate100

Member
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
 
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.
 
Back
Top