Question

Failing to create collective Invoices

  • 22 April 2021
  • 5 replies
  • 280 views
A
Rank
Userlevel 4
Badge +9
  • Arend
  • Sidekick (Customer)
  • 76 replies

Hi All,

 

Using IFS10, UPD7 (on verge of changing to UPD9)

 

We are using shipments to deliver shipments and Order Flow settings are set to create the Customer invoice automatically. Shipments are done between two sites, belonging to two different companies.

The problem that we are facing, is that (to us) randomly Collective Customer Invoices are generated and for other orders nothing is generated. For those where nothing is generated, we can manually create a Customer Invoice.

We did change settings on the Customer to allow Collective Invoices, but this is not changing anything. Same with changing it to manual creation of Invoices. (E.G. stop the flow before the Invoice is created)

When we look in the PL/SQL developer, we actually can see that a preliminary invoice get created, but the actual invoice is not generated. 
 

Anyone has faced a similar issue and can assist on where to look?

 

Thanks.

Arend

 

This topic has been closed for comments

5 replies

MadushaDissanayake
Rank
Userlevel 7
Badge +17

Hi @Arend,

 

Were you able to resolve this issue?

Creation of collective invoice is determined by the drop down value in Customer window > Order Tab > Misc Customer Info Tab > Type

 

Could you please let me know the status of Customer Order and the result you are getting when you query for Customer ID > Create Collective Invoice Per Order?

 

Further, you have stated “When we look in the PL/SQL developer, we actually can see that a preliminary invoice get created, but the actual invoice is not generated.”, 

Could you please elaborate this finding more?

 

Thanks and Best Regards

Madusha

 

 

X
Rank
Userlevel 7
Badge +20

Hi Arend,
 

Are there any customizations or modifications involve in code level ? or SQL event actions connected to invoice creations?

A
Rank
Userlevel 4
Badge +9

 

Hi MadushaDissanayake

 

We have switched between settings on Type of Invoice back and forth, but that doesn’t seems to have any impact. 
We found an error in the background job, stating: “There are no customer order lines available to create the collective customer invoice”

A
Rank
Userlevel 4
Badge +9

Hi Xavier,

 

No customization or SQL Events linked to creation of Invoices.

 

Arend

MadushaDissanayake
Rank
Userlevel 7
Badge +17

Hi @Arend,

 

Thank you for your response.

Could you please go to Create Collective Invoices > query for Customer ID > Right Click and select Create Collective Invoice Per Order? Can you see the relevant customer order records?

 

Anyway, I have found a probable fix ( 157102 ) that might resolve this reported issue. Please note that this fix is applicable if there’s a GET extension applied.

 

Here’s the Test Plan related to the fix

 

1. Create a Customer Order 
Make sure Shipment Creation is set to "at order release" under delivery information tab
2. Release the order > RMB on header > go to shipment info
3. Access the shipment created > RMB > Reserve > create pick list > report pick > complete > deliver > close
4. The shipment will be in closed state. Go back to the CO and it'll be delivered.
5. Go to "create shipment invoices" window > query the shipment id > create shipment invoice
6. Check the relevant background job.
Error text "There are no customer order lines available to create the collective customer invoice"

Is the test plan similar to your issue?

I think it would be better to raise  a case to IFS Support to do further investigations on this

 

Thanks and Best Regards

Madusha

 

Terms & ConditionsCookie settings