The solution was created for a company of digital electronic services (recharge of electronic air time) with 80 thousand points of sales.
The client had more than 2 years trying to integrate the operation of its POS for the financial accounting management in Dynamics NAV.
An automated and optimized tool was needed to be able to manage and consolidate more than 4 million weekly transactions for its financial cost & inventory control.
The requirements included the understanding of the business to design the final accounting transactions to control the financial cost of electronic inventory while controlling the recharge of hours. Also included the ERP upgrade from version 2009 to NAV 2016.
AkkETL is the solution we developed to extract, process and consolidate 4 million of POS transactions per week in 300 electronic sales invoices and client deposits as well as purchase invoices to manage the inventory hours and inventory cost.
Microsoft SQL Server
Microsoft Dynamics NAV C/AL
High volumen of data to manage, 4 million transactions per week.
High performance and scalability requirement.
Complexity of the business process needs. We had to define how to manage the operation into ERP.
Multiple consolidation rules
Daily, weekly, monthly process requirement.
Geographically separate data stores (Africa, USA, Mexico).
Non guarantee of transaction success at any data point.