Dear,
I’m JBLee and working at the AXi4CNS as MS Dynamics AX local Partner
We have a critical issue of the inventory closing perfomance based on the AX4.0
Our customer has dissatisfaction of inventory closing process and duration.
Detailed inform is as follows:
-
Monthly Inventory Closing duration: more than 15days
-
Inventory transaction: more than 60,000 transaction
-
Inventory settlement : more than 2,500,000
-
Server Org & Spec
4.1 DB Server
Hardware: Dual core Cpu 4,Memory 4GA, Disk 6EA (Data part : Raid 1+0)
Software: OS - Windows 2003 Enterprise
DB - Windows SQL Server 2005 STD
4.2 Application Server: Multi AOS
1st AOS: Normal Service
2nd AOS: Only Inventory Closing -
Data Size: 11GB
-
Inventory closing option
-
Maximum throghputs: 100
- Minimum throghputs adjustment: 0.01
- Minimum settle qty percentage: 0.01
- Minimum settle amount: 0.01
7 Symptom of Inventory closing after recalculation
7.1 Begining: about 100 settlements/sec
7.2 after 1hour: 30 settlements/sec
7.3 after 3hours: 3~4 settlement/sec
As time passes the inventory closing performance comes to be slow.
Also Some data is conflicted when we run the M.I.C
- We tried some solutions
8.1 Index rebuild
8.2 M.I.C
8.3 Clean up the Settlement
This appendix is about inventory settlement of Oct. inventory closing
You can see, the settlement is happened that Aug. PO receipt transactions(Same InventtransID).
Maybe, If the inventory closing logic of MS Dynamics AX4.0 is right, as time passes, Number of settlement is more increasing,
and the closing needs a lot of time.
To improve the inventory closing performance, Pls, give me solutions or advices ASAP.
we and our coutmers are eagerly waiting for your apply.
if you want to receive the detailed information & file, pls let me know your e-mail address.
Thanks
Appendix 1)
select InventTransId,count() Closing date : 2009-10-31
from InventSettlement
where transdate >= ‘2009-10-01’
and transdate < ‘2009-11-01’
and cancelled = 0
group by InventTransId
order by count() desc
InventTRansId Count
00209460_054 8093