{"id":941,"date":"2019-12-11T16:56:10","date_gmt":"2019-12-11T16:56:10","guid":{"rendered":"http:\/\/sagefinancialsknowhow.com\/?p=941"},"modified":"2019-12-11T16:59:40","modified_gmt":"2019-12-11T16:59:40","slug":"fix-for-bank-matching-filters","status":"publish","type":"post","link":"https:\/\/sagefinancialsknowhow.com\/fix-for-bank-matching-filters\/","title":{"rendered":"Christmas Fix for Bank Matching filters"},"content":{"rendered":"

\"\"<\/h2>\n

What is the problem?<\/h2>\n

If you use the [Pay] feature to mark Purchase Invoices as paid, you generate ‘Payment to Suppliers’ journals. Using Bank Matching feature in Sage Financials you can easily use [Match] to match a payment from you bank statement to the\u00a0‘Payment to Suppliers’ journal.<\/p>\n

\"\"<\/p>\n

So far so good, but unfortunately the ‘Filter by any words’ does not work on the most useful fields – Purchase Invoice Number, Supplier Name, or Supplier Ref (which is often in the bank statement description).\u00a0This makes it really difficult to match if you have a lot of supplier payments.<\/p>\n

\"\"<\/p>\n

The Fix<\/h2>\n

The fix\u00a0uses a Workflow Rule to set the Reference field in the Journal Items to a concatenated string with Invoice Ref, Purchase Invoice Number, and Supplier<\/em>. The great thing about ‘Reference’ is you CAN filter on that using the ‘Filter by other words’<\/p>\n

\"\"<\/p>\n

How the fix works<\/h2>\n

I have to give credit to Ram\u00f3n Guti\u00e9rrez Morera<\/em> from Sage for this fix. All I have done is clean it up and packaged it to make it easy to use.<\/p>\n

First you need a Workflow Rule based on Journal Item Tag:<\/p>\n

\"\"<\/p>\n

Then setup a ‘Field Update’ Workflow Action:<\/p>\n

\"\"<\/p>\n

But its Christmas!<\/h4>\n

So what I’ve done is package this up into a simple\u00a0Unmanaged Package for you to download for free:<\/p>\n

https:\/\/login.salesforce.com\/packaging\/installPackage.apexp?p0=04t1r0000018Wpa<\/a><\/p>\n

Unmanaged Packages deploy the configuration so you can edit it just as if you’d written it yourself. I’ve set it up so the Workflow Rule is deactivated, so you will need to Activate it in Setup before using:<\/p>\n

\"\"<\/p>\n

BACS files<\/h2>\n

The BACS Feeds I’ve seen that come pre-configured with Sage Financials do not include data for\u00a0‘Beneficiary reference’. If you want to make it easier for your suppliers to match your payments to your invoices, its a good idea to include the supplier’s invoice number in the\u00a0‘Beneficiary reference’. I’ve done this with the\u00a0‘Nat West RBS Format’ Feed Broker Rule. The BACS field si only 18 characters long, so by padding out the Reference with blanks, and using\u00a0LEFT(item.s2cor__Reference__c,18) you get just the Supplier Invoice Number!<\/p>\n

\"\"<\/p>\n

This is the code I’ve used for the ‘Format’ field:<\/p>\n

,,,01,,,,,{!invoice.Name},,,,{!payerBankAccount.s2cor__IBAN_Sort_Code__c}{!payerBankAccount.s2cor__IBAN_Account_Number__c},,,,{!item.s2cor__Amount__c},,{!=FormatDateTimeGMT(journal.s2cor__Date__c,”ddMMyyyy”)},,,,,,{!payeeBankAccount.s2cor__IBAN_Sort_Code__c},,,,,,{!payeeBankAccount.s2cor__IBAN_Account_Number__c},,{!payeeBankAccount.s2cor__Account_Name__c},,,,{!=LEFT(item.s2cor__Reference__c,18)}<\/span>,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,<\/p>\n

If you need any help on this or other Sage Financials solutions please fill in the Alpha Index enquiry form<\/a>\u00a0and we would be delighted to help out.<\/p>\n

That’s it for 2019!! More stuff on Bank Reconciliation and other goodies coming soon so please\u00a0register to receive regular updates from Sage Financials\u00a0knowhow<\/em><\/a>.\u00a0<\/strong><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

What is the problem? If you use the [Pay] feature to mark Purchase Invoices as paid, you generate ‘Payment to Suppliers’ journals. Using Bank Matching feature in Sage Financials you can easily use [Match] to match a payment from you bank statement to the\u00a0‘Payment to Suppliers’ journal. So far so good, but unfortunately the ‘Filter Read more about Christmas Fix for Bank Matching filters<\/span>[…]<\/a><\/p>\n","protected":false},"author":1,"featured_media":954,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[4],"_links":{"self":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/941"}],"collection":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/comments?post=941"}],"version-history":[{"count":0,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/941\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media\/954"}],"wp:attachment":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media?parent=941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/categories?post=941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/tags?post=941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}