erp

SDLC: Managing changes in a 'Closed System' (M1 - ERP)

I am working with a client who has an ERP system in place, called M1, that they are looking to make custom changes to. I have spent a little bit of time investigating the ERP system in terms of making customizations. Here is a list of what I have found with regards to custom changes: Custom changes cannot be exported/imported. There...

Batch updation in SQL server 2008

hi friends..... I have an application run on an enterprise having head office and branches. Each branch has separate local server and DB. The master server and DB is updated daily by batch updation . How can i overcoming the id conflict in such situation. Eg: i have a record with ID 10 on branch A Also a transaction with referen...

How should I model a group relation in the database and in OOP?

I have instances of Item that I would like to have in groups ItemGroup. But if an Item is moved to another itemgroup, I would like to keep track of the change for accountability reasons. E.g. I need to know if an Item was in one ItemGroup in October and another in September. How should I model this in the database? How should I model th...

Account, inventory integration with existing web application.

I have a midsize ERP which is very much domain focused. Now, I need to have typical ERP features like Accounts, inventory, purchase etc etc. I see a lot of applications already available for these. So I am thinking of reusing any of the existing available package and integrate it with my app. So the question is : Can anyone refer me su...