The Customer Statement of Account report appears to duplicate the customer PO number from the line below it when the first entry (in our case a Collective Invoice) doesn’t have a customer PO number directly attached to it in IFS. The Collective Invoice will show a PO number but when the Statement of Account runs it won’t pull that and will instead fill it in with the one below. Does anyone know what might be going on here?
Question
Customer Statement of Account giving wrong Customer PO Number
So there appears to be a bug in CUST_STMT_ACCT_RPI. The customer_po_no_ variable never gets cleared in the FOR LOOP. It retains its value from the previous record. Adding the highlighted line corrects this issue. BTW, it is exposed by COLLECTIVE INVOICES because the CREATORS REFERENCE is empty for these.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.