Fields with Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2089198%22%20slang%3D%22en-US%22%3EFields%20with%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089198%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20gang%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20an%20accounting%20software%20called%20Xero%2C%20that%20has%20the%20ability%20to%20utilise%20custom%20templates%20I%20create%20in%20Word.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20restaurant%20chain%20has%20a%20Central%20Kitchen%20and%20a%20Bakery.%20Both%20invoices%20are%20added%20into%20Xero%20but%20need%20to%20be%20split%20up%20when%20I%20am%20sending%20the%20Statement%20(payments%20are%20made%20into%20separation%20bank%20accounts).%20The%20Statement%20feature%20currently%20consolidates%20all%20invoices%20(from%20both%20the%20Bakery%20and%20CK).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20find%20a%20way%20of%20splitting%20up%20the%20lines%20so%20that%20only%20the%20CK%20appears%20in%20the%20table%3B%20and%20visa%20versa%20for%20the%20Bakery.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20difference%20between%20the%20Invoices%20is%20the%20Invoice%20Number%20(field%20code%3A%20%26lt%3B%3CDESCRIPTION%3E%26gt%3B).%20All%20Central%20Kitchen%20Invoices%20start%20with%20a%20%22CK-%22%3B%20and%20the%20Bakery%20with%20%22BK-%22.%20Is%20there%20a%20field%20code%20formula%20to%20only%20capture%20data%20that%20contains%20the%20above%20in%20its%20reference%2C%20including%20all%20of%20the%20subsequent%20data%20on%20that%20Line%3F%3C%2FDESCRIPTION%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you%20have%20another%20suggestion%20for%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20document%20for%20you%20reference.%20I%20have%202%20separate%20tables%20where%20I%20would%20like%20the%20data%20split.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20greatly%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDanny%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2089198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebookmark%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efield%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eformula%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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,

 

Danny

0 Replies