On the Return Material Authorization Lines screen in IFS Cloud, I am wondering what the DB field is called for this column in the front end: “Credit/Corr Inoivce No”
I See a credit_invoice_no field on RETURN_MATERIAL_JOIN_UIV view but the value does not seem to be synonymous with the value in the screenshot above. Any insight is appreciated for this!
There you will see credit_invoice_no and debit_invoice_no columns.
Found the DB value for Credit/Corr Invoice No using the sql trace on the Return Material Auth Lines screen.
Credit/Corr Invoice No = (customer_order_inv_head_API.get_invoice_no_by_id(CREDIT_INVOICE_NO)) in the oracle backend.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.