Skip to main content
Question

Printing customer invoice

  • December 2, 2024
  • 3 replies
  • 83 views

Forum|alt.badge.img+4

Hi,

 

Is anyone aware of this error, I had 3 cancelled invoices and I want to print 2 invoice so that status changed from preliminary. error is as below

 

Error [Oracle Error 01427: Subquery for one row returns more than one row] in

Report method [CUSTOMER_ORDER_IVC_RPI.Report_Invoice]

3 replies

Abdul
Superhero (Partner)
Forum|alt.badge.img+20
  • Superhero (Partner)
  • 543 replies
  • December 2, 2024

Hi Shantanu,

Please report this issue with your technical team. There is an issue with one of the fields in Customer Invoice layout. Some additional conditions need to be add.

 

Regards

Abdul Rehman


Forum|alt.badge.img+4
  • Author
  • Sidekick (Customer)
  • 16 replies
  • December 2, 2024

Hi Abdul,

 

This shall be the issue in the report itself right?

I am from Functional background and I have to get this resolved.

Is there a work around to that?

also, a point to note, there is already a Customer invoice in preliminary stage cancelled, i suspect this might be issue, but I cant delete that 


Abdul
Superhero (Partner)
Forum|alt.badge.img+20
  • Superhero (Partner)
  • 543 replies
  • December 2, 2024

Hi Shantanu,

Reported error is very generic and often comes for customised reports. It is not possible to identify the reason without debugging the report rpi.

Let me try to explain, this error comes when system getting more than one values for a report field when one single unique value can be printed. e.g., only single value can come in Currency field in report output, however, system somehow getting two different currencies and therefore, unable to decide which Currency would be considered for report layout. 

You would need some technical assistance to understand where is the issue exactly.

 

Regards

Abdul Rehman