Receiving Corrections from PL/SQL
Hi,
I want to do receiving corrections programmatically from PL/SQL. I figured out how it can be done with ROI using the Receiving Transaction Processor, but there is a problem when I try to diminish an item by more than I have received. In that case, Oracle raises an exception that tells me that I want to subtract too much, but after that the PO is broken and all its transactions are gone.
I want to do receiving corrections programmatically from PL/SQL. I figured out how it can be done with ROI using the Receiving Transaction Processor, but there is a problem when I try to diminish an item by more than I have received. In that case, Oracle raises an exception that tells me that I want to subtract too much, but after that the PO is broken and all its transactions are gone.
Is there an easy way to check for the maximum number I can subtract, or do I have to figure out the way it is done in Forms?
0