Forum Discussion

BrettP1's avatar
BrettP1
Experienced User
2 years ago
Solved

Hoping for a call

I have been a long time user of MYOB in various roles and companies for many years.  Always found it to be very user friendly and adaptable.  However I also never had a major issue that required assi...
  • Steven_M's avatar
    Steven_M
    2 years ago

    Hi BrettP1 


    Apologies for the delay in getting back to you

    We were looking into the situation and it may be just how the Item Register window showcases the information that is causing that unusual display. In short, it works backwards on-screen i.e. takes the current value and works up the transactions to determine the values.


    In saying that, we have arranged for the company file to be sent in for an investigation to see if there is nothing untoward occurring with that company file and its item history. You should have received an email outlining the process for that file investigation. This email contains all the information to get that file uploaded but do reach out if you have any questions on that process.

BrettP1's avatar
BrettP1
Experienced User

Thanks for the offer.

 

Background is we acquired a business that was not keeping perpetual inventory, when we started we carried on, however we would now like to establish a perpetual inventory system.

 

To do so a copy of the current file was taken end of September 22 and stored offline.  To this file we added all new inventory items.  To these inventory items we entered opening stock values as at 30 June 2022, which reconciled with the opening inventory value at 30 June 22.   Then went through and reentered all stock purchases against the new inventory items and deleted the original entry.  Then went through and reentered sales invoices and sales orders using the new inventory items.  Along the way established build items as required.

 

This all seemed to be working fine until went to recode a sale and came upon error saying insufficient inventory.  On investigation the issue as set out below has effected a number of inventory items but not all and  I have not been able to identify any patern to which items effected.

 

Below is screen shot of the Quanty On Hand screen from the List Items, Note Opening Inventory as entered was 5 however Quanty on Hand -6, there are no entries prior to that point.

 

The error is in the opening line where inventory taken up, and whilst the majory of effected items are less On Hand that Opening Quantity, it is not all, some are the other way.

 

The next screen is from Reports Inventory Detail, which is correct, finally is shot of Reports Inventory Summary, which shows 0 on hand similar to the Item List.

 

Just as an added issue, I have since tried to put this file online however keep getting a communication error, have tried turning off virus protection, restarting modem, restarting computer, tried from different location i.e. different wifi. So any suggestions on that issue also appreciated.  Thanks all in advance.

Item List_On Hand.jpgItem List_Register AC.jpgItem register report summary.jpg

Mike_James's avatar
Mike_James
Ultimate Partner
2 years ago

Hi BrettP1 , note that picture files etc should be added as attachments before they can be viewed by anyone. Your pictures will need to be approved by a mod first.

  • BrettP1's avatar
    BrettP1
    Experienced User
    2 years ago

    Hi Mike,

     

    Thanks for the notice, first time doing this.  Do I need to send the pictures again?  Should they be pictures or pdf?  I did try the attach file but wasnt sure if that was working but on review probably was.