Forum Discussion

MYOB_rookie's avatar
MYOB_rookie
Contributing User
22 days ago

Inventory quantity incorrect when purchase orders are received as backorders/split deliveries

Hi MYOB Community,

I'm hoping someone can point me in the right direction regarding an inventory issue we're experiencing.

We are finding that when a purchase order is received in multiple deliveries (for example, due to a backorder), our inventory quantities don't seem to reconcile correctly.

A simple example:

  • We place an order for 6 tiles.
  • The supplier sends part of the order initially and the balance later.
  • Both deliveries are received into MYOB.
  • We then sell all 6 tiles.

At that point, we would expect the inventory quantity to be zero. However, MYOB still shows 6 tiles remaining in stock, as though an additional quantity has been added somewhere during the receiving process.

This doesn't appear to happen on every order, but it seems to be related to purchase orders that are received over multiple deliveries.

Has anyone experienced a similar issue, or can anyone suggest what we might be doing incorrectly when receiving split purchase orders/backorders?

Any advice would be greatly appreciated.

 

MYOB_rookie

 

1 Reply

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    19 days ago

    Hi MYOB_rookie​ , to answer this question we need more information. Are you able to attach the following:

    • item information (profile, sales & purchase tabs)
    • Item register detail covering the item history of purchase and sale (screenshot of display)
    • Screenshot of each purchase bill for an order with multiple deliveries

    Be sure to blank out confidential information as this is a public forum.

     

    Does your process include using Receive items?

    Do you sell before recording the purchase bill?

     

    You mention that 6 tiles appear to remain in stock. Is this per the item information display? What do you see if you run the item register detail report for this item? Same or different?