Inventory Value Rec out of balance

[FMC2291]

I am finalising my FY21 accounts, however have an issue with the Inventory Value Reconciliation being out of balance. There is a negative amount in the value of one item, although this item has nil stock on hand. Also, I only set this item up recently (i.e. in FY22) so I dont know why there would be a negative value against it in the year before it was first set up. NB, the negative value is the exact amount of the first auto build I did of this item in FY22.

I have looked at the items register for the period and no transactions are showing against the item. I have also confirmed the correct accounts are set up for the item. I also tried to delete and rebuild the item, but I cannot delete the first auto build as it tells me this will leave me with a negative value for the item.

Please advise how this can be fixed.

Thanks
Fran

[FMC2291]

@Komal_S are you able to help with this. I think it is similar to the issue you helped me with previously, but this one crosses financial years. Thank you!

[FMC2291]

https://community.myob.com/t5/AccountRight-Sales-and-purchases/negative-inventory-balance/m-p/668261...

[FMC2291]

Hi there, I think I need the script run over my account that clears negative inventory balances. In my case, an item I created and built in Oct 2021 has a negative balance before, I did the build, at 30 June 2021.

Can someone please assist? I tried to call support but the wait time was 80+ minutes.

Thanks
Frances

[Yanike_S]

Hi @FMC2291 

Thanks for your post.

Could you please send me your serial number and company data file ID in a Private Message?

[FMC2291]

Thank you Yanike, I have just sent you a private message.

Cheers

Fran

[Yanike_S]

Hi @FMC2291 

I have run those scripts over your file. Let me know if this solved it for you.

[FMC2291]

Hi Yanike

No, unfortunately I still have the issue of an opening negative inventory balance. Any other suggestions?

Thanks
Fran

[Yanike_S · Accepted solution]

Hi @FMC2291 

I am sorry to hear you are still having issues with your opening inventory balance. Could you send me screenshots via Private Message:

• Inventory Value Reconciliation
• Item Register of the item
• Item information Profile tab
• Item information Auto build tab

Note: click on Photos to send me image files. You can take screenshots of the windows by using a snipping tool. In Windows 10 you can use the Windows-key+shift+s.

Once I have received these I will be able to investigate this further for you.

Solved by sending file in for Datafile Repair.