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
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