Fields with Formulas

Copper Contributor

Hi gang,


I am using an accounting software called Xero, that has the ability to utilise custom templates I create in Word.


My restaurant chain has a Central Kitchen and a Bakery. Both invoices are added into Xero but need to be split up when I am sending the Statement (payments are made into separation bank accounts). The Statement feature currently consolidates all invoices (from both the Bakery and CK).


I need to find a way of splitting up the lines so that only the CK appears in the table; and visa versa for the Bakery.


A difference between the Invoices is the Invoice Number (field code: <<Description>>). All Central Kitchen Invoices start with a "CK-"; and the Bakery with "BK-". Is there a field code formula to only capture data that contains the above in its reference, including all of the subsequent data on that Line?


Perhaps you have another suggestion for this.


I have attached a document for you reference. I have 2 separate tables where I would like the data split.


Any help is greatly appreciated!


Thank you very much,



0 Replies