Skip to main content
Question

CUSTOMER_ORDER_IVC_REP data for credit for a charge

  • April 15, 2026
  • 2 replies
  • 11 views
M
Hero (Customer)
Forum|alt.badge.img+10

Hi

We have  Crystal Report layouts to print customer invoices and credits based on the CUSTOMER_ORDER_IVC_REP table.  The Crystal Report uses the order_no and other fields to pull in some additional data which we need to include on the printout.

We have a credit for a customer which is a credit for a charge, which is associated with a line on the customer order.

When we print that credit, the order_no is not populated in the CUSTOMER_ORDER_IVC_REP table.

We have tried this in both 23R2 and 25R1 with the same results.

Can anyone confirm if this is a bug or if there is some specific reason that the data is not populated?

Thanks,

MMck

2 replies

T
Superhero (Partner)
Forum|alt.badge.img+14
  • Tracy Norwillo
  • Superhero (Partner)
  • April 15, 2026

​@MMcK  Does the value populate in the standard IFS Operational Report?

If you have access to IFS Developer Studio and the report definition, (order/source/order/database/CustomerOrderIvc.rdf), check out the code that populates the charges section of the report.  I believe it’s on line 6468 and the cursor is called “get_charges”.

M
Hero (Customer)
Forum|alt.badge.img+10
  • MMcK
  • Author
  • Hero (Customer)
  • April 16, 2026

Hi ​@Tracy Norwillo 

Many thanks for the pointer to the right direction.  My Developer Studio doesn’t seem to show the .rdf files (only the .report files) but I found it in the core code folders.

It looks like the source of the problem is the ‘creators reference’ in the customer_order_inv_head (as used for the main header_rec) which comes from the invoice_tab.  The credit for the charge has a null reference, but a credit on the same order for an order line has the correct order number as the creators reference.

So it looks like it’s the way the invoice is created rather than a problem with the report data itself.

Thanks again

Terms & ConditionsCookie settingsAccessibility statement