Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi everyone,
I've just started using QuickBooks Advanced, and I've encountered a challenge with stock management. We need to accurately track our on-hand stock, but some of our suppliers require upfront payment before shipping. When an invoice is assigned to a purchase order, QuickBooks changes the status from 'on order' to 'on hand,' even though the stock hasn't arrived yet. Since our shipments are international, it can take days or weeks for the stock to actually be on hand. This makes it difficult to know what stock is truly available for us to send out.
I've spoken with the support helpdesk, but they couldn't offer a solution. I'm wondering if anyone else has faced a similar issue and found a way to resolve it? Would a stock inventory add-on help, or would it face the same issue since it pulls invoice details from QuickBooks?
Any advice or suggestions would be greatly appreciated. Thanks in advance!
Hi JB_amba_01 Thanks for reaching out to us here on the Community. You could create the purchase order as you normally would, you could then create a bill payment (enter billpayment after qbo.intuit.com/app/ in the url) or create an expense, to account for the payment to your supplier, and use the creditors/accounts payable in the category column, enter the amount paid. When your stock does arrive you can then copy the purchase order to the bill, select make payment and add/link the bill payment or the expense to the bill.
Please note that as we're not accountants we recommend that you contact an accountant to qualify the above or there maybe an accountant or experienced Community member that reads this post and they're able to verify the above or offer an alternative solution.
We have also submitted your feedback to our developers and hopefully in the future they maybe able to implement a more robust stock tracking system that would enable customers to have an option to not affect the quantity on hand when copying a purchase order to a bill. I would also recommend that you leave feedback from within your product by selecting the cog/gear icon > Feedback.
@JB_amba_01Unfortunately the stock handling in QBO is terrible and hasn't improved one jot since I moved over from the Desktop version three years ago.
For some reason Intuit seems to think that it's a low priority in company's workflows. About the only thing it can handle is split deliveries against a PO, but other than that you may have to create an external stock list in a spreadsheet I'm afraid.
I tried a suggestion on the ‘Ideas Exchange Forum’ (link below) to try and improve the stock handling. But, it was closed because Intuit are useless and implementing anything in the product and in these forums. Welcome to the club of either putting up with it and making it work, or finding another product I’m afraid.
Until they realise that stock handling is equally important and sales handling, then we are stuck with it.
Looking back at TradeGecko's fate after their acquisition, don't expect too much that they will improve their inventory management features. You should consider having a third party application to integrate with QBO.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.