Question

Customer Repayment SQL statement for Laser Check

  • 1 February 2022
  • 2 replies
  • 115 views
E
Rank
Userlevel 4
Badge +6

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

This topic has been closed for comments

2 replies

T
Rank
Userlevel 7
Badge +18

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

E
Rank
Userlevel 4
Badge +6

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

Terms & ConditionsCookie settings