Is there an easy way to see value of SOH for EOFY reporting in Neto? Pretty much the only report I need but can't see any simple way of seeing this information.
Hi Matt. Welcome to the Community.
Unfortunately, no method is available to retrieve the historical value of SOH (Stock On Hand) for a specific date. However, you can easily access the current value of SOH by navigating to the Reports section of the Control Panel and selecting Stock Valuation reporting.
If you have any further questions or need assistance with any other matter, feel free to let me know. I'm here to help!
If that seems crazy to you, that's because it is. Neto's developers don't have a good understanding of bookkeeping or the real-world requirements of business. Neto Inventory isn't viable for a business of any significant size that keeps accurate books unless it's connected to a real accounting package. And because there's no API for purchase orders, that's not possible in most cases.
I don't recommend using Neto Inventory unless you have it backed with a separate accounting package.
I would argue that even this is lacking as there is no functionality to search by supplier etc.
Hi Kellie. I apologize for the inconvenience. In this case, I would recommend submitting your suggestion through the ideas portal.
By submitting your request through the ideas portal, the product team will have the opportunity to review your suggestion and consider implementing it in future updates or releases of the software. While I cannot guarantee that the feature will be implemented, this is the best way to provide feedback and have it considered by the development team.
Thank you for bringing this to our attention. Once again, apologies for the inconvenience caused. Please let me know if you have any further questions or need assistance with anything else.
@Kellie Appleyard that way your idea can enjoy a sad, lonely death along with the other 1600 ideas on there that have been ignored. In the 6 years the portal has existed the ideas have hardly ever been sorted and never updated by staff.
To top it off, when Neto migrated systems last year they deleted all previous votes - because they don't actually care what ideas are proposed or popular.
As I've said repeatedly, the ideas portal is a disgrace and should be either fixed or shut down. @Pranay Shinde I'll beat this drum until the day that happens.
This is interesting, what would be the best way to approach managing the correct stock numbers/value for both Neto and accounting package, Xero in our case? @Erik Merkley
We use the Neto Advanced Inventory Module but are often left strung out when numbers don't line-up correctly, thinking we have stock when we've actually run out?
The most important decision when you're setting up an inventory integration is which system becomes the "source of truth" - where stock levels are assumed to be correct. Every other system becomes a slave to this, simply adjusting its levels to stay in sync.
That's where getting Advanced Inventory to play nice with accounting systems is hard. Advanced Inventory assumes it is the source of truth. *Without* Advanced Inventory enabled, Neto can work in either mode because it's much easier to adjust stock levels.
I don't have experience with Xero directly, but we use Saasu (a similar platform) with a custom Neto integration. We don't have advanced inventory enabled because there's no API to access purchase orders. Saasu is our source of truth. POs are created in Saasu, and all sales orders are pushed from Neto to Saasu. Every night, inventory levels are adjusted in Neto to match Saasu, effectively bringing in newly receipted stock, but also correcting any differences between the systems.
While it sounds simple in theory, real-world inventory is really complex and there are so many places it can go wrong. Returns, mis-ships, backorders, laybys, supplier returns and human error can all lead to subtle errors in inventory counts. The big problem is these compound - an error made today will cause stock for that product to be out from now until the next stocktake. The errors build up over time.
There's no silver bullet. Make sure you know your systems exceptionally well, so you can predict what the Xero integration will do in every case (what if you delete an order? Cancel one? Re-pick a line? Change a SKU? Delete a payment?). Pick one example of an inventory error and use every report you can to trace what happened and where the error came from. It isn't always possible. Good luck!
Wow, I really appreciate the detailed answer, thank you. Though I'd say I've got a relatively good understanding of the systems between Neto and Xero and how they sync up there are just some quirks that leave me a bit baffled. I guess not having API access to POs in Neto and not having sales orders in Xero doesn't help with using Xero as the main source of truth.
We definitely need to sharpen up our returns process, picking accuracy and avoiding excessive returns due to the customer ordering the incorrect items. Also managing how payments work for backordered items is painful too in xero, due to no sales orders available in Xero. I've looked into other accounting problems but then learning the ins and outs of a new system doesn't appeal either.
