Jiwa

We have created a plugin to add a custom search window that includes the Description field from the batch header as a custom search column which works fine. In the .SQLStr we have included a filter where ReceiptPayment = 0, which works well for Cashbook Receipts, however the same custom search appears in Cashbook Payments and our custom search still shows only Cashbook Receipts. How can we modify the plugin so that our custom search shows only Receipt transactions in Cashbook Receipts and only Payments transactions in Cashbook Payments?

JohnBiddick wrote:We have created a plugin to add a custom search window that includes the Description field from the batch header as a custom search column which works fine. In the .SQLStr we have included a filter where ReceiptPayment = 0, which works well for Cashbook Receipts, however the same custom search appears in Cashbook Payments and our custom search still shows only Cashbook Receipts. How can we modify the plugin so that our custom search shows only Receipt transactions in Cashbook Receipts and only Payments transactions in Cashbook Payments?

Hi John,

Can you attach here a plugin showing how you added the custom search? I can modify it to demonstrate what you require - without knowing precisely how you added the custom search it's a bit tricky to explain how as there are several ways to add a custom search.

Mike

Morning Mike

File attached
Thanks

Hi John,

Attached is a modified version of your plugin which I think does what you want. I simply altered the query to examine the FilterNo and adjust the SQL accordingly - Cash Book Receipts is FilterNo 550, Payments is 551.



Mike

Hi Mike

Trevor here using John's login.

We have loaded your amended Plugin without success. It doesn't matter whether I go into Cashbook Receipts or Cashbook Payments the custom search plugin is showing both payments and receipts. What we require is just receipts for cashbook receipts and payments for cashbook payments.

Are you able to see where we are going wrong?

Kind regards
Trevor

Hi Trevor/John,

Modified plugin attached - just needed to add a WHERE clause to include the receipt type check.



Mike

Thanks Mike

That works well.

Regards
Trevor/John