Xero

Top  Previous  Next

Xero ( www.Xero.com ) is a cloud-based accounting system.

Usage Notes

®When testing a new macro or when you have entered a lot of data on a Xero form (an invoice, etc.) it's a good idea to save the form's data, then run the macro. Then if the macro works differently than you expected you can revert or cancel the form to get your original data back.
® Xero's header fields are not accessible to FullSpeed macros at this time. Calculations are limited to the line items area of Xero forms.

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

Web browser notes