Settings and activity
1 result found
-
65 votes
Hi team, while we don't have plans for adding a field for supplier to Inventory items, right now you could run the Payable invoice Detail report to see the purchases of items, and which supplier(s) they've been bought from.
You can also Group/Summarise the report by Item Code or Contact, depending on which you want to see together.
An error occurred while saving the comment
We have recently trialled a software that syncs with Xero and have since decided to solely use Xero. However, while trialling the other software we found they offered a great solution to our issue of not being able to enter suppliers invoices and capturing the inventory as we pay this supplier under one monthly statement. An example to hopefully make this easier to understand is, we purchase our inventory from Suppliers A, B & C (non-billers) throughout the month. We still receive invoices from them, but the costs are charged to our account with Supplier Z. We pay all of these suppliers at the end of the following month directly to Supplier Z (Biller). Because we don't pay suppliers A, B & C directly we can't enter their invoices into Xero to be able to see our running total with each supplier or enter the inventory purchased from them against our sales invoices. The other software we trialled aloud us to enter suppliers A, B & C's invoices and when Supplier Z's monthly statement came in we were able to check off suppliers A, B & C's invoices entered in Xero against their statement and it was paid directly to Supplier Z. Having this feature aloud us to see our running total for the month and enter our inventory used against each sales invoice. Once supplier Z is paid, all of the non biller invoices were marked as paid.
As of Mar 2023 I can see that my suggestion does not appear to have been looked at. This is still a critical feature for our business as we needed to look up a part we ordered from one of our A, B or C suppliers to see when we last purchased it. We couldn't use the inventory feature in Xero to do this as we are unable to capture this information so this meant we had to go back through months of Supplier Z's statements and then each individual invoice to track down the last time we purchased a particular part. A very time consuming process with such a simple fix for Xero to create. If were able to enter the part# in Xero's Products pageit would have brought up the invoice numbers that the part was purchased on, saving a lot of time.