Skip to main content

Does anyone have a SQL statement for the Customer Payment Check for the Laser Check.   We have a Crystal report that is only considering Supplier Payments.   I can get the check to print out on the IFS Standard Report so trying to figure out why the Crystal report is not printing the Customer Repayment Check.  The IFS Standard report looks like it uses tables Supplier_Checks, Suppplier_Check_Items, Supplier_Check_Item

Here is our Crystal Report SQL Statement.

 SELECT "SUPPLIER_CHECK_TRANSACTIONS_"."PAYMENT_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."DISC_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."FULL_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."CHECK_AMOUNT", "LEDGER_ITEM_SU_QRY_"."VOUCHER_NO", "SUPPLIER_CHECK_TRANSACTIONS_"."SUPPLIER_NAME", "ADDRESS_DEFINITION_V2_"."ADDRESS", "SUPPLIER_CHECK_TRANSACTIONS_"."PAY_DATE", "SUPPLIER_CHECK_TRANSACTIONS_"."CURRENCY", "LASER_PRINT_CHECK_REP_"."CHECK_NO", "LASER_PRINT_CHECK_REP_"."RESULT_KEY", "SUPPLIER_INFO_ADDRESS_PAY_LOV_"."DEF_ADDRESS"
 FROM   ((("IFSAPP"."LASER_PRINT_CHECK_REP" "LASER_PRINT_CHECK_REP_" INNER JOIN "IFSAPP"."SUPPLIER_CHECK_TRANSACTIONS" "SUPPLIER_CHECK_TRANSACTIONS_" ON (("LASER_PRINT_CHECK_REP_"."COMPANY"="SUPPLIER_CHECK_TRANSACTIONS_"."COMPANY") AND ("LASER_PRINT_CHECK_REP_"."PAYMENT_ID"="SUPPLIER_CHECK_TRANSACTIONS_"."PAYMENT_ID")) AND ("LASER_PRINT_CHECK_REP_"."IDENTITY"="SUPPLIER_CHECK_TRANSACTIONS_"."SUPPLIER_ID")) INNER JOIN "IFSAPP"."LEDGER_ITEM_SU_QRY" "LEDGER_ITEM_SU_QRY_" ON (("SUPPLIER_CHECK_TRANSACTIONS_"."COMPANY"="LEDGER_ITEM_SU_QRY_"."COMPANY") AND ("SUPPLIER_CHECK_TRANSACTIONS_"."INVOICE_ID"="LEDGER_ITEM_SU_QRY_"."INVOICE_ID")) AND ("SUPPLIER_CHECK_TRANSACTIONS_"."SUPPLIER_ID"="LEDGER_ITEM_SU_QRY_"."IDENTITY")) INNER JOIN "IFSAPP"."SUPPLIER_INFO_ADDRESS_PAY_LOV" "SUPPLIER_INFO_ADDRESS_PAY_LOV_" ON "SUPPLIER_CHECK_TRANSACTIONS_"."SUPPLIER_ID"="SUPPLIER_INFO_ADDRESS_PAY_LOV_"."SUPPLIER_ID") INNER JOIN "IFSAPP"."ADDRESS_DEFINITION_V2" "ADDRESS_DEFINITION_V2_" ON ("SUPPLIER_INFO_ADDRESS_PAY_LOV_"."SUPPLIER_ID"="ADDRESS_DEFINITION_V2_"."ID") AND ("SUPPLIER_INFO_ADDRESS_PAY_LOV_"."ADDRESS_ID"="ADDRESS_DEFINITION_V2_"."ADDRESS_ID")
 WHERE  "LASER_PRINT_CHECK_REP_"."RESULT_KEY"=3496493 AND "SUPPLIER_INFO_ADDRESS_PAY_LOV_"."DEF_ADDRESS"='TRUE'
 ORDER BY "LASER_PRINT_CHECK_REP_"."CHECK_NO"
 

Thanks

Hi, 

To answer the question the customer repayment checks are found in the customer repayment checks screen,. 

The customer repayment checks are in this screen. 

A better answer could be to show a screen that has both customer repayment and supplier checks. 

From the screens you can get the view and the attributes for your SQL.   

Best regards, 

Thomas

Thanks Tom!   I will take a look at those files.

Terms & ConditionsCookie settings