Xero |
Top Previous Next |
Xero ( www.Xero.com ) is a cloud-based accounting system. Usage Notes
Xero Fields Data limitations of fields In Xero as in most applications, some fields accept a limited range of data. Xero is very "forgiving" in this regard, because instead of displaying an error message it may simply convert bad data into something it can accept. For instance if you type "1.23456789" in the Quantity column of an invoice, then press the Tab key, Xero will enter "1.2346" instead. The downside of this feature when running FullSpeed macros is that a macro can enter "junk" data without much complaint from Xero. So when creating macro formulas, keep in mind that you are in charge of how FullSpeed sends results to QuickBooks Online. When necessary, use FullSpeed's formatting features to control the format and number of decimal places of numeric results. Also, you can use spreadsheet functions like IF to prevent sending certain kinds of results which would produce errors—such as preventing negative numbers from being sent to a field which accepts only positive numbers. See also |