We have moved over from Accountright v19, since then we have items that have units with very long decimals. Also if i try to adjust inventory to 0 it will actually change to a negative number, again with very long decimals.
I have attached a picture. The negative number should be 0.
I see others have had a script run on there company file.
Ours is online.
Go to Adjust Inventory as per below example;
Item Number - Location ID - Quantity - Unit Cost - Amount - Account - Job - Memo
AABBB - SYDNEY - 5 - $40.00 - $200.00 1-4000 Adjustment to correct SOH & Average Cost
The above adjustment is to correct the stock on hand and also average cost .
Hope it solves your issue.
That's fixed it. Thanks for the that.
Hi mikejenkin ,
Thanks for your detailed post.
This can be quite tricky. If you're still experiencing the same issue after following the solution provided by @esaumellie, please reply with the last four digits of your Serial Number and Company File ID. I'll take a closer look at this for you.
Looking forward to your response.
Regards,
Earl
Sorry esaumellie, i dont quite follow.
I have tried adjusting inventory, is that what your asking?
Hi Earl_HD,
Company File Id: 1
Last 4 Digits of Serial: 6100
Thanks
Hi mikejenkin ,
My apologies, but I can't find the serial number ending in (6100) registered to the email you're using here on the Community Forum. Could you please send me a private message with the serial number instead? Thank you!
Regards,
Earl
Hi Earl_HD,
How do i PM you, can't seem to find it.
UPDATE
Just Sent PM
Hi mikejenkin ,
Thanks for providing the information via private message. I've successfully arranged an online script over your file that should fix the issue. I recommend logging out and then logging back in to see if the issue persists.
If you have any further queries, please feel free to start a new post, and one of us will be happy to assist you.
Regards,
Earl
Hi mikejenkin ,
We're glad to hear that the script was able to fix your issue. If you have any more questions, please feel free to start a new post, and we'll be happy to assist you further.
Regards,
Earl
The script fixed the existing values but some of the time when i adjust to 0 i still get weird numbers with large decimal places.
I need to adjust to 0 quite often, is there a solution that would stop this from happening, instead of running the script everytime?
