Inventory As At Reporting - Quantity & Value

[hartleyk]

Hi all,
I'm new to both Jiwa and the forums so I hope I am posting my query in the right area!
I came across an archived post on here which is identical to the problem I am facing at the moment and was wondering if there was any further progress on this:-

"Re: Inventory As At Reporting - Quantity and Dollar Value
Postby SBarnes » Wed Dec 10, 2008 9:15 am

Whilst I agree with all the comments made about issues to do with inventory as at reporting, one other issue that needs to be considered is also the inventory control reporting.

Currently you can only run it as the present date which means that when you do your end of year processing you can only get a snapshot at that point in time, if anything changes after the fact you can not prove that inventory is reconciled to the GL, it would be hand if the control report could work the same as the debtor and creditor versions ie given year and period range.

Stuart Barnes.
Regards
Stuart Barnes
[email protected]"

I have just started with a new company who use Jiwa and one of the main reasons for my employment is to maintain and "clean up" the system.
Unfortunately, in the past, Jiwa has not been used correctly end efficiently or to its full potential - and, as such, there are several reconciliation issues, one being that the Stock-on-hand GL account is $4m different to the stock on hand value from inventory (according to the inventory reconciliation report run as at today).
My issue is that I am trying to reconcile 30 June 2018 and clean up the system so as we have a clean slate moving forward. However I cannot pull a report that shows me the stock on hand value as at 30 June 2018.
I asked our support people about this and was told "Unfortunately with stock you are not able to go back in time to run an as at with dollar values – it will always be as at today’s date".
I am just a little lost as to how I even begin to reconcile stock on hand and clean up the system when I can't even get an accurate stock on hand figure as at the end of the financial year.
How do other companies work around this? What is the best way to approach this?
Any help would be greatly appreciated.

Thank you,
Katherine

[beth.blok]

Julie - this question is best handled on our Helpdesk system. Please follow this link to register and use this system https://docs.jiwa.com.au/display/J7UG/H ... a+Helpdesk

Beth Blok