Forum Discussion

KatieMcL's avatar
KatieMcL
Experienced User
4 years ago

Inventory Control Issues AR 2021.3

We have run full inventory control for >20 years.  We have inwards stock, then build finished items in the form of Liquid Product, Jar, Lid Label for 250gm units to 30 KG units in the main, but also ...
  • Mike_James's avatar
    Mike_James
    4 years ago

    Hi KatieMcL , that eliminates one possibility.

     

    This program has been completely rewritten from the old v19 program, which can be misleading, because whilst it looks the same, the behaviour is not always the same.

     

    You'll note from the forum that that there are quite a number of issues around inventory. 

     

    The closing qty and value balances of both the on-screen item register and the item register detail report are taken from the onhand qty/value per the item card. Then prior balances are worked out backwards. 

     

    If the closing values of the register detail report and the item register display do not agree to the item card, and there are no future dated transactions in the file (?), then you may need to have a script run over the file to correct the history. (There are a number of such scripts). A moderator can advise further.

Mike_James's avatar
Mike_James
Ultimate Cover User
4 years ago

Hi KatieMcL , do you by any chance use multiple locations?

  • KatieMcL's avatar
    KatieMcL
    Experienced User
    4 years ago

    Hi,  No Multiple Locations or currencies..!  Cheers

     

     

    • Mike_James's avatar
      Mike_James
      Ultimate Cover User
      4 years ago

      Hi KatieMcL , that eliminates one possibility.

       

      This program has been completely rewritten from the old v19 program, which can be misleading, because whilst it looks the same, the behaviour is not always the same.

       

      You'll note from the forum that that there are quite a number of issues around inventory. 

       

      The closing qty and value balances of both the on-screen item register and the item register detail report are taken from the onhand qty/value per the item card. Then prior balances are worked out backwards. 

       

      If the closing values of the register detail report and the item register display do not agree to the item card, and there are no future dated transactions in the file (?), then you may need to have a script run over the file to correct the history. (There are a number of such scripts). A moderator can advise further.

      • KatieMcL's avatar
        KatieMcL
        Experienced User
        4 years ago

        Hi Mike,

         

        Really appreciate your input and now have further understanding on the inner workings of the inventory balances.   I checked for forward entries and there were none up to the year 9999..!  I will contact MYOB to get a script run over it - they did not reply with that idea last time I contacted them regarding virtually the same thing.   Just said to start a new stock card.

         

        Many thanks again,

        Cheers,

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.