Forum Discussion

LilyUltimate's avatar
LilyUltimate
Experienced User
2 months ago
Solved

Reversal of Received Items

Hi

I would like to know more about how "reversal of received items" journal is generated.

 

We don't believe this function is working properly.

When fewer items were received than originally ordered, we would process the receipt by keeping the ordered quantities unchanged and only entering the actual received quantities. As a result, the system automatically generated a second purchase order to offset the remaining balance of the original order.

However, this automatically created order did not accurately reflect the outstanding items. Instead, it included mismatched items and quantities, often appearing as negative values.

we are seeing inconsistent and incorrect inventory movements in MYOB 

 

Please can you let us know how this function works

 

thanks

Lily

  • Mike_James's avatar
    Mike_James
    1 month ago

    Hi LilyUltimate​ , the amount you've queried ($1833) is the amount in the Freight field. This is not subject to the same processing rules as inventoried items, in fact I'd suggest that using the freight field on purchase orders is something the program is either not designed to handle or is handling incorrectly. 

    If this freight cost is being charged by your supplier, I would suggest leaving it off the PO, or using an "I purchase" freight item and add a line to the PO.

    Ideally (per general accounting principles) you should be apportioning the freight cost across all your inventory items in this shipment, so that their cost in stock reflects the cost of bringing them into the warehouse. There are ways to achieve that in the transaction.

8 Replies

  • Isaiah_C's avatar
    Isaiah_C
    MYOB Moderator
    2 months ago

    Hi LilyUltimate,

     

    Thanks for getting in touch and for explaining what you’re seeing with the reversal of received items and the auto‑created purchase orders. What you’ve described, especially the negative quantities and mismatched items on the new PO, doesn’t sound like expected behaviour, and the way that journal is generated depends a lot on the exact setup and the specific transactions in your file. Because of that, we’ll need to take a closer look at your company file and some example transactions to work out what’s going on and make sure your inventory movements are correct. Reach out to our live chat support through our virtual assistant, MOCA, or submit a case via My Account.

     

    Regards,

    Sai

  • LilyUltimate's avatar
    LilyUltimate
    Experienced User
    2 months ago

    Hi Sai

    Here is a screengrab of account 2-1201 Trade Creditors as an example of a supplier "reversal of received items".

    I have also attached screen shot of order which shows original order and then the follow up with negative quantities.

     

  • LilyUltimate's avatar
    LilyUltimate
    Experienced User
    1 month ago

    Hi

    Has anyone had a chance to look into this one for me

    thanks

    Lily

  • LilyUltimate's avatar
    LilyUltimate
    Experienced User
    1 month ago

    here you go Mike

    thanks

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    1 month ago

    Hi LilyUltimate​ , the amount you've queried ($1833) is the amount in the Freight field. This is not subject to the same processing rules as inventoried items, in fact I'd suggest that using the freight field on purchase orders is something the program is either not designed to handle or is handling incorrectly. 

    If this freight cost is being charged by your supplier, I would suggest leaving it off the PO, or using an "I purchase" freight item and add a line to the PO.

    Ideally (per general accounting principles) you should be apportioning the freight cost across all your inventory items in this shipment, so that their cost in stock reflects the cost of bringing them into the warehouse. There are ways to achieve that in the transaction.

  • LilyUltimate's avatar
    LilyUltimate
    Experienced User
    1 month ago

    thank you Mike

    appreciate you coming back to me, I will speak to my team

  • LilyUltimate's avatar
    LilyUltimate
    Experienced User
    1 month ago

    Hi James

    I have spoken to our team, one question they had was has the inventory count of items been compromised by us using the above method - that is leaving the freight in freight field?

    thanks