CRMGT041 - FX Creditors Listing - Transaction Due Date is ignoring the FX Creditor Only parameter

Problem

Checking the tick box FX Creditors Only is ignored and all creditor transactions were printed.  Applies to 7.00.175, 7.01.00, 7.02.00 and 7.02.01.

Solution

SQL skills required

A working knowledge of SQL Management Studio is required to complete this task

Download and apply the attached stored procedure to the database. The criteria FX Creditors Only is now applied.