You’re offline. This is a read only version of the page.
310
Does any know how AX 2012 / D365 post transactions for WAVE / Work without posting journals ?
Thanks
Hariharan Marudan
*This post is locked for comments
Hi Hariharan,
Don't know of any other way, assuming same codebase was used in standard 'quantity adjustment' to avoid any issues. Thanks for providing details above. The core mechanism remains the same. E.g. if you look at journal, it still create records in inventTrans and then associated tables (inventDim,sum etc.).
Thanks,
Satish Panwar
Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.
Thanks Panwar,
That's the same approach we have right now in AX 2012, we generate adjustments transactions based on onhand and insert directly to InventTransOrigin and InventTrans, and now we are migrating to D365, so want to know is there any better approach to deal with. When we try different approaches, we see WMS - work transactions are also posted similarly.
Yes, your right the DB size is increasing quite faster and we have a regular custom purge routines to manage this as well with retention of one week transaction data (only for this process). For handling performance we handled through the multi-tasking not sequential. With Std., Journals we had lot of difficulties to deal with when it comes this volume of data.
Hi Hariharan,
On on-hand form, there is "Quantity adjustment" feature, see what it uses behind the scene. it's like create record and click ok and it post adjustments accordingly provided all dimensions etc. are provided.
Now given that you have mentioned 70K/hour, you may want to get a better approach to the solution as it will just increase your DB size, just calculate how many rows your system is going to add over a month and then year. based on that, plan for environment size as well. moreover as you continue to post, you may not see performance issues, but few months down, you may see issues with it.
Thanks,
Satish Panwar
Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.
Hi Hariharan,
There is no framework to post Adjustments or Counting transactions without a journal. Can you explain why you have 70K transactions every hour? This number sounds insane to me. What is the exact procedure/scenario here?
For example - WhsWorkExecute class is used to post work related inventory transaction (Pick & Put)..
Do we have any framework or classes in ax to post Adj / Counting inventory transactions without using journals, I have biz scenario need to post 70k Adjustment transaction for every hr. This is to replicate the Vender WHS in AX for planning purpose.
Looking for technical details... looking for any framework exists for posting inventory transactions (iAdj., Movement etc..) directly without using inventory journals.
Hi Hariharan,
What is the background of your question? What type of answer do you expect? A technical or functional?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (