589 results found
-
Expose Paidto / Paid from field Prepayment and Overpayemt API
I am working on Overpayments and Prepayments and when trying to fetch the Prepayments I am not able to get the 'Paid from' field in the API response (record image attached below).
below is the response that i get from the previewer for the attached record
{
"Id": "8b72a53f-5525-42e9-a959-56321ccc4ee0",
"Status": "OK",
"ProviderName": "Xero API Previewer",
"DateTimeUTC": "\/Date(1606125619612)\/",
"Prepayments": [
{
"PrepaymentID": "d7de4e66-02c6-4032-a3e0-7837a13a0cdc",
"ID": "d7de4e66-02c6-4032-a3e0-7837a13a0cdc",
"CurrencyRate": 1.000000,
"Type": "SPEND-PREPAYMENT",
"RemainingCredit": 0.00,
"Allocations": [
{
"Amount": 6559.30,
"Date": "\/Date(1479168000000+0000)\/",
"Invoice": {
"InvoiceID": "03300666-fa19-457b-a7ed-cf683850fb94",
"InvoiceNumber": "Inv.#. RG1620064",
"Payments": [],
"CreditNotes": [],
"Prepayments": [],
"Overpayments": [],
"IsDiscounted": false,
"HasErrors": false,
"LineItems": []
}
}…1 vote -
Line Items in Xero should be populate with default values of Item Inventory
When a line item is added to Xero invoice - it currently do not created with default values. It doesn't make sense to not default to Item Inventory defined in Xero.
If this is a breaking change and break for other customer then a new field which will let us populate line items using default values.
If not, we will need to sync Item inventory in our end before creating any invoices via API.
1 vote -
Quotes with lineAmountTypes=inclusive returning wrong unitAmount
Unlike invoices, if lineAmountTypes='INCLUSIVE', quotes return the items with unitAmount having the tax deducted.
Example (invoice):
1. Invoice created with lineAmountTypes=Inclusive with 1 item with unitAmount=100, quantity=1.
2. GET invoice returns the invoice with the item. unitAmount field is correctly showing 100Example (quote):
1. A Quote is created with lineAmountTypes=INCLUSIVE with 1 item of unitAmount=100, quantity=1.
2. GET quote returns the quote with the item's unitAmount=86.96 (86.96+15% GST = 100) which is wrong.1 vote -
Ebay Manged Payment Bank Feed
Hi, eBay announced a new payment method called "eBay managed payment", not using PayPal anymore and basically eBay doing the same job with PayPal. Now, we need to define eBay as a new bank account and need to import transactions automatically.
1 vote -
Add Contact address information for Quates endpoint
There is no contact address information in the quotes endpoint
1 vote -
Auto invoice number and references
If you leave the reference field blank on an ACCPAY invoice then the invoice number is automatically generated using the defaults INV-00381 etc. But if you give a reference 'August 2020 travel charges' and leave the invoice number blank then the API copies the reference and makes the invoice number 'August 2020 travel charges'. I want auto-generated invoice numbers but to be able to give an independent reference.
1 vote -
Default Tracking option for line items
Hi, the Xero api offers creation of Tracking options against line items but is missing a way to add Default Tracking option for line item so that the generated line item will have this option as preselected. Currently we have to ask our customers to go and set the proper tracking option themselves. Maybe if we can have an endpoint to associate a certain option as default for the line item that would be great and save our clients the work to assign it manually.
1 vote -
Make it possible to run a report featuring all account codes including those with zero balcance
When one is running a Cash Summary or Profit & Loss, why not make it possible to view & export the report featuring all active account codes?
This would save a lot of time formatting excel sheets if the rows lined up every time. And it seems like a simple fix, just add the checkbox:
"Run report featuring zero balance active accounts"
1 vote -
Linked Transactions via API - multiple in one call.
Linked Transactions are limited to one per call via the API. This results in having to make a great many API calls unnecessarily. For instance linking the invoice line items to a project after several invoices with many lines are added via API will require many more calls than are allowed. For now I will have to put in place a costly work-around to trickle in the linked transaction calls.
1 vote -
Offer the Account Transactions report as an ODBC table
I would like to be able to select a table in the ODBC connection that is the same as the Account Transactions report. This allows me to create financial statements and analysis based upon the full 'general ledger' of a company's transactions data set.
1 vote -
Allow more than one contact with the same name so API does not overwrite existing data incorrectly.
We have had several 'David Smiths' buy from us via our website. As the API feed sends the data to Xero - Xero looks for a 'David Smith' and then automatically overwrites existing address and phone number etc with the new info.
The result is data that is totally incorrect. Furthermore I recently sent a product to the wrong client which was costly and embarrassing.
The simple solution is for Xero to have a 2nd and 3rd 'identifier' i.e. email address, post code. For example:
If the name + the email address and/or the postcode are a match then =…
1 vote -
Return account & bank connection status
It would be valuable to be able to obtain a status or timestamp of the last successful sync with the bank account. This way, we can inform customers if there is a problem with their bank or if their transactions or accounts are out of date.
1 vote -
Allow bulk retrieval of all outstanding balances by grouped contact
Currently we can get the amount owing by querying individual contacts. However, given the API limits this becomes impossible to do on a daily basis for reporting once a reasonable number of customers is being queried.
While it's possible it's better to do it in a web-hook-update kind of way when new information comes into Xero and is pushed externally, it would make more sense to me to have an endpoint that simply allows a contact summary to be obtained in a single API call which could have simple aggregates, like amount owing, shown.
1 vote -
Add the date a transaction is created/finalised to appear on all reports as an option
I have clients that do there own bookkeeping but are on partial exemption VAT and they are forever changing things in prior VAT periods. It would be useful to have a date of the transaction in all reports as it would be easier to make the required adjustments. This also relates to aged debtors/creditors and transaction reports as it would speed up the process of identifying any new transactions that were posted in earlier periods.
1 vote -
Contact search should be case insensitive via API
While creating the sales invoice via API, usually we check if the contact is already created or not, to search the contact the name/keyword must be used in the same case that is available on Xero, if its different then it will not search.
1 voteHi Swapnil,
Thanks for the post.
We currently have a work around for the issue you are currently facing which may be of use.
It is possible to include ToLower() in the where clause when quering the endpoint. ie. ?Name.ToLower()=="{name}’
See the following commultiy thread for more information: https://stackoverflow.com/questions/60265042/can-xero-contacts-be-filtered-by-name-case-insensitive
-
Search option for items not reconciled
Search functionality to go through items not yet reconciled in statements/bank accounts such as credit card.
1 vote -
Search option for credit card or bank transactions
Enable a search option to go through transactions on credit card that have not yet been entered
1 vote -
make xero identify duplicate bills import from another App eg Receipt Bank
it would be great for Xero to be able to identify duplication with synching data from other applications. Xero just can not rely on third party.
it's going to be better selling point for Xero .1 vote -
To generate OnlineInvoiceUrl while creating Invoices in single API call
Need to have a way to generate OnlineInvoiceUrl while creating Invoices in single API call so no need to do api calls twice to get the onlineInvoiceUrl using GET https://api.xero.com/api.xro/2.0/Invoices/9b9ba9e5-e907-4b4e-8210-54d82b0aa479/OnlineInvoice
1 vote -
Xero Projects - Schedule Calendar API
The ability to display all projects created in Xero Projects to a Calendar.
That way you can see who is doing what on each day,week or month.1 vote
- Don't see your idea?