Hi Dear Experts,
in the Invoice line table i need to implement the below conditions on the quantity field. first make sure quantity is not exceed than a certain amount and the total line amount for all the invoices for the customer don't exceed 10000.
Please help as my subqureies don't seem to be working.
Many thanks in advance.