Skip to main content
Question

What field is Credit/Corr Invoice No in the backend?

  • December 3, 2024
  • 2 replies
  • 18 views

Forum|alt.badge.img+5

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!

2 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • December 4, 2024

@blake.hamlin you may wanna query the view: return_material_line.

There you will see credit_invoice_no and debit_invoice_no columns.


Forum|alt.badge.img+5
  • Author
  • Do Gooder (Customer)
  • December 4, 2024

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.