Forum Discussion

TanyaBennett's avatar
TanyaBennett
Experienced Cover User
4 months ago

Inventory Adjustment

Hi, We have made an inventory adjustment to reduce down items that have become obsolete or damaged. We went through the inventory adjustment & did a minus for the full amount, with the correct cost ( $11.89 per unit ) the total adjustment qty was 259. Resulting in cost amount to write off is $3,079. However, the journal transaction did the 259 x $3,079, resulting in a $727,034 adjustment, effecting the profit & loss. Can you please advise why it would do this & also how I correct it. Screen shots attached. Thanks 

4 Replies

  • Isaiah_C's avatar
    Isaiah_C
    MYOB Moderator
    4 months ago

    Hi TanyaBennett,

     

    Thanks for the detailed info. Really appreciate you attaching the docs too, super helpful! It does sound like something odd's happened there with the adjustment amount showing way off what you were expecting. If you cost per unit was $11.89 and you adjusted out 259 units, you're spot on. The write-off should've been $3,079. But seeing $727,034 pop up definitely isn't right. This might've happened if the item's average cost was off or if there was a historical transaction that's affecting the numbers. Also, if the product was still linked to a sales invoice or open order, it could cause some weird behavior. Best thing to do now is make sure no sales or purchases are linked incorrectly to that item during the same period. If you're still seeing that inflated amount, it might be worth reversing the adjustment and redoing it once the costings and links are sorted.

     

    If it still looks strange, flick this to our support team directly by jumping onto our live chat support through our virtual assistant, MOCA so they can have a closer look at your file.

     

    Regards,

    Sai

  • TanyaBennett's avatar
    TanyaBennett
    Experienced Cover User
    3 months ago

    My apologies for the late reply. WIth the linked information, are you saying this is linked/used in a sale, which their will be numerous or linked to a particular income chart of account? Or do you suggest we just reverse first & redo & if it does the same thing look for the linking? Thanks