Skip to main content
Question

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

  • December 3, 2024
  • 2 replies
  • 14 views

Forum|alt.badge.img+2

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)
  • 1142 replies
  • 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+2
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • 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. 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings