Skip to main content
T
torben-stones
May 8, 2019
Solved

Is there a way to automatically update the purchase cost of stock items, when I raise a PO or Bill?

  • May 8, 2019
  • 2 replies
  • 0 views
Original commenter did not share additional details
Best answer by JamesC

Hey Torben-Stones,

 

Welcome to the UK community Page for QuickBooks Online.

 

Short answer, no - It won't Pull through from the bill, to the Product/Services screen automatically. You'll need to edit/update the product item if you want this to change on the products and services list.

 

As Rustler mentioned however, if you're more thinking about stock and cost price calculations and your reports - the FIFO process will kick in, based on the Purchase Date used on the Bill or Bills representing the stock purchases.

2 replies

Rustler
Rustler
May 8, 2019

a PO is non posting, it is just a memo of what you ordered

but the bill does record the purchase (qty and cost)

 

QBO uses FIFO so the first purchase date and cost is used when you sell, until that qty for that purchase date is gone, then the next purchase date is used

 

as a result the cost price on the item screen is not real accurate, nor  is the average cost shown in the inventory valuation report

JamesC
JamesCAnswer
May 8, 2019

Hey Torben-Stones,

 

Welcome to the UK community Page for QuickBooks Online.

 

Short answer, no - It won't Pull through from the bill, to the Product/Services screen automatically. You'll need to edit/update the product item if you want this to change on the products and services list.

 

As Rustler mentioned however, if you're more thinking about stock and cost price calculations and your reports - the FIFO process will kick in, based on the Purchase Date used on the Bill or Bills representing the stock purchases.

H
Hgill1
May 7, 2020

Why can't you make the bill pull the new price off a bill?  I used to use sage and they had this facility, this is definitely lacking in QB and is is time consuming and tedious having to two jobs when it could all be done in one go.  Surely this is something which could be done? Also the problem with not being to automatically set a customer or supplier discount so it isn't missed, or to be able to put a customer account on hold if non payment occurs, these are all things lacing in QB which are there with sage and other products like xero. When will these things be implemented into QB to make our process easier?

    Rose-A
    Rose-A
    May 7, 2020

    Hi, Hgill1.

     

    Allow me to provide some updates regarding product-related in QuickBooks Online.

     

    At this time, there isn’t a specific time frame as to when this feature be available. Our development team is constantly working to improve the product and appreciates the help of users in bringing things like this to their attention. 
     

    In the meantime, I'd encourage you to visit our QuickBooks Blog site for product updates as well as business tips from our accountant.

     

    Also, you can always visit our Help Articles page for QuickBooks Online in case you need some reference for your future tasks.

     

    Drop me a comment below if you need further assistance with QuickBooks. I'll be more than willing to lend you a hand. You have a wonderful day!

    Terms & ConditionsAccessibility statement