Dear All,
similar to my previous post on Inventory Closing having difference in inventory VS GL. I notice one more thing which I am going to share now. on same post not posted because of no reply coming to that.
when I close inventory for the month it adjust the value on all transaction but the value adjusted on Transfer Order ("Inventory Module--Periodic") giving discrepancy between subledger vs GL.
I am not getting why or its not consider as non financial transfer or may be I am missing any GL Account in Item group setup. I don't know.
did anyone face the same issue?
*This post is locked for comments
Hi Ludwig;
Yes. and if 365 (Both Cloud Base or on premises) covering all features of R3
You mean whether to upgrade to AX2012 R3 vs. upgrading/implementing MSDyn365FO?
Hi Ludwig;
yes I consider that and forward to management also but the issue is now we have 365 so what is best to go for and budget also as an issue.
Hi Sajjad,
We had a couple of customers who had problems with the R2CU7 environment and brought them all up to the latest R3 versions, which often fixed the problems.
I am not sure if this might help in your case and how much time and effort such an upgrade requires but maybe it is something you want to take into consideration?!
Best regards,
Ludwig
HI Ludwig,
this third option already I am using same. but issue is something else or maybe the report getting some bug. like there is fix but the issue is I am not able to apply this fix as it creating some other problem in my environment. I try to get consultant to apply the fix but no one ready to take a risk factor.
may be you know that or gone through. Inventory Aging report where for example if you have 5 items and let says 2 item have no qty and value then when you print I will show the Qty and Value for that item also as inventory Qty and value. the reason behind that is not clearing the variables and pass the value for empty stock item.
in short there is some classes or method ("Inventory Stock") which picking a wrong info and need to be apply patches or through developer to correct that.
Hi Ludwig;
thanks first two fix I checked also but now I am looking a third one you mentioned. I will get back on the result.
Hi Sajjad,
I see. Do you have a very concrete example where you identified a variance between GL and inventory that was caused by your transfer journals?
Can I also ask you to take a look at the following articles/fixes that I found on LCS and that might help?
Best regards,
Ludwig
Hi Ludwig;
I my self admin for the system and there is no modification which can change the posting rules. Transfer Journal post both Issue and Receipt same time but Transfer Order no it first ship then received two steps process. plus we can add a transport charges also.
Hi,
I am not sure what this means. Do you have a system admin guy around who knows whether a system modification has been made that might be responsible for this variance?
Transfer orders should actually not create variances because they post a receipt and an issue at the same time.
With the things that you described I am not sure whether your system behavior is caused by a bug or a modification that has been made.
Guess we need somebody from the technical platform side who can dig deeper at the database level.
Best regards,
Ludwig
Hi Ludwig;
I check there is no voucher generated. but on transaction ledger tab showing GL.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156