Share
Report
1,110I have a very serious problem regarding Finished Goods inventory stock. A batch of Production is posted by a user on 3 Jun 2014, but after that when I go through the smart list inventory transaction then that batch is there in posted state, but when I double click on any item of that batch it opened window "inventory transaction inquiry window" and all is fine. but when I opened Financial -> Summary or detail of that item ,and go to the debit of that month, and by giving specific date (3 Jun 2014) then it shows nothing, mean no any entry of production shows there, and also item quantity did not effect after entering that batch. now I ran reconcile of those items which are in that batch, after reconciling quantities of that item changed of all month. it effects all previous months, and changed stock of that item and now that item stock is showing in negative (in historical stock status as well as in inquiry window).
is there any way to undo the reconcile, or any other options so that inventory becomes match with actual. (according to account /store officer inventory quantities are OK until this reconcile but after this reconcile it effects the quantities of al months, including the previous fiscal years.
as test, I restore the backup of 2 Jun 2014 on a test server, and run reconcile of those items, but it did not effect any item quantity, but when I restore the db of 3jun 2014, and ran reconcile, it effects all inventory quantities.
i go through to mohdaoud.blogspot.com/.../mismatched-inventory-quantities.html but problem is, how i can undo / correct last years quantites, which were OK.
now I am in big trouble as fiscal year is near to end, any quick solution will be highly appreciate able, thanks....
*This post is locked for comments
All responses (
Answers (
