Forum Discussion

KatieMcL's avatar
KatieMcL
Experienced Cover User
4 years ago
Solved

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 Partner

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

KatieMcL's avatar
KatieMcL
Experienced Cover User
4 years ago

Hi,  No Multiple Locations or currencies..!  Cheers

 

 

  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    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 Cover 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,

      • Steven_M's avatar
        Steven_M
        Former Staff
        3 years ago

        Hi KatieMcL 

         

        If required, I'll be happy to arrange the necessary inventory scripts for you. Would need for you to confirm the following information to arrange that for you:

         

        • Where the company file is stored i.e. online or local
        • What the LAST FOUR DIGITS of the serial number is - Setup>>Company Information
        • What is the company file ID - Help>>About AccountRight