|
An ERP system is a huge project to tackle, and if it is to be a generic system, where the user can configure the ERP in a way that suits his business, then the complexity becomes multiplied. Having worked a lot with ERP systems, you are going to have to dedicate several years to it if you are working on your own.
The practical solution would be first to buy a ready-built accounting system with APIs to hook into. Then you need to think deeply about the clients business, and decide what functions he will require - sales and order management, inventory management, inventory obsolescence, parts supercessions, labour billing, JIT ordering, bin location systems - the list is huge, and unless you are deeply familiar with the client's business, it is several months work on its own, before you even start to design the project.
In the last five years I have seen three major ERP projects fail due to a failure of the vendor to understand the client's requirements, so think very carefully before you take this on.
|
|
|
|
|
I am very gratefull to you Chris. Your advice is very handy and I will keep these points in mind during analysis phase.
Thank you so much 
|
|
|
|
|
One other thing for you to keep in mind, which latches onto MDL=>Moshu's comment - at all costs try to avoid inter-process communication, and make everything database-centric. If not, when you have to redesign a module, you will find the changes rippling through just about every other module that the first one touched. Modding the DB and a couple of modules is easy compared with a major rewrite.
|
|
|
|
|
Totally agree. I mean we created separate let's call them apps, for moving a product(s) from one location to another,
from Quality to Scrap from prod to qual ....
The apps were available as some small asp.net web apps for desktops and as a "desktop" app(.net compact framework) for the wireless scanners/pc(windows ce).
Specialized to the max. No big huge thingy.
All the best,
Dan
|
|
|
|
|
Yeah just like Pete said.
But sooner or later the day will came when you'll need to modify almost everything at least in a module
if not all. Situations like:
Up till now you(not you personally, the company/people) moved a product from an area to another eg from production to warehouse for example.
Then they decide that they want a more detailed transaction so instead of moving from production to warehouse you will
have to move them from the production line to the warehouse. Or the other way around meaning that management decided that they don't need such detailed transactions. Such modifications are bound to affect many reports/modules.
So the best thing you could do is make it pluginable(sorry if the word doesn't exist) and try to design the app/modules
with such modifications in mind. Even then someday you(the team) will have to modify large bits of code.
After all an ERP system is meant to accommodate the businesses of a particular company/plant.
If/when that changes you'll have to change it too.
I've done something like this a little while ago. Fortunately I was familiar with the business process and I
anticipated some of the possible changes. But not all of them.
Best of luck.
All the best,
Dan
modified on Tuesday, December 28, 2010 10:10 AM
|
|
|
|
|
I am gratefull to you Dan for a very good piece of advice. It's very handy to have suggestions from the ones who have already done the work on ERP.
Thank you so much.
|
|
|
|
|
You're welcome.
Oh, and it's not that hard really. Just a lot of work(huge if just one person) and most importantly carefully design of the businesses process.
If you're not familiar with it, I suggest you take some time to familiarize yourself with it and then start
designing/developing the app.
All the best,
Dan
|
|
|
|
|
Umair Feroze wrote: It covers inventory mangement, sales and purchase, an Accounting System, an HR system including payroll system.
Although I am developing all these as individual projects but the thing which is worrying me is how to join all these in a way that incase of adding another system I dont have to change the code for my project. I just create another project compile it and just plug into the system
This is would be a large project even for a relatively small company.
The larger the company the more complexity involved in the integration. A simple example is a company might want to manage contractors as personal (human resources) while paying them as a project expense rather than a payroll expense.
An inexperienced developer is unlikely to get the functionality of the individual components correct much less correctly architecting/designing the cross project needs correctly. As an example of this corrrectly implementing point of sale taxes for a retail company is a very complicated task.
Not to mention of course that any cross project needs are directly dependent on the business needs of the company itself. Thus the first step is to learn the needs of the company.
|
|
|
|
|
Hi,
How can i insert a button inside a textbox in the same column in datagridview control.
|
|
|
|
|
I think for accomplishing Button inside Textbox this previous thread in same forum HERE[^] might help you.
After then there's not hard to make it involved in datagridview.
I hope you want button inside textbox. NOT button with a textbox in same column.
|
|
|
|
|
thanks Hiren ,
i want a cell in datagridview that contain a button inside a textbox,when i press the button i get some value and i put it in textbox.
if there is a solution plz send it to me.
Regards,
|
|
|
|
|
That will take a lot time of yours 'cause you need to make custom control or need to use third party control for that, And it's time consuming and task of R&D.
If design doesn't matter at all then you can achieve same thing using TextBox with Button outside, Your cell can contain multiple control there's not any restriction to only one.
|
|
|
|
|
no,I'm obligated with that design,thanks anyway.
Regards,
ahmad115
|
|
|
|
|
When I google the topic I got many suggestions like this one: http://blogger.nilanka.net/2010/08/split-web-application-into-multiple.html
Is this the only way to do it? We have a big Web application project (ASP.NET 3.5) and we use VS2008. Does VS2010 have any support for splitting a web app into multiple projects or do we have to do this workaround?
_____________________________
...and justice for all
|
|
|
|
|
d00_ape wrote: Does VS2010 have any support for splitting a web app into multiple projects or do we have to do this workaround?
You'll have to split it yourself; Visual Studio cannot "guess" what pages make up a (child) project.
I are Troll 
|
|
|
|
|
Ok, then I'll give it a try!
_____________________________
...and justice for all
|
|
|
|
|
in my application i try to identify if the sql express server is running in a remote pc, before starting my local service.
i use servicecontroller class and it gives the status as running, but through my service when i'm trying to access the DB in that sql server it returns the DB is not there, i used a thread sleep and then tried , it worked well then.
so seems to be there is a problem with sql service status and the real starting , is there any solution i can do instead of thread sleep.
|
|
|
|
|
I doubt ServiceController is a good idea.
Some reasons why it isn't a good idea.
- In a standard data center set up box A is not going to have permission to access the database box.
- Detecting that the service is running doesn't diagnose all possible failures.
The simple solution is to just do a do nothing query like the following
select 1
A better one might be to verify that at least one of your tables exists, but still a do nothing query like the following.
select 1 from mytable where 1=0
|
|
|
|
|
thanx... If the sevicecontroller is not a good solution is there any other class that i can use instead of it.
thanx in advance.
|
|
|
|
|
prasadbuddhika wrote: If the sevicecontroller is not a good solution is there any other class that i can use instead of it.
That doesn't make sense.
If you need to insure that a remote service is up AND you have permissions to access services then you would use ServiceController.
Expanding on what I already said.
- In a standard data center set up you will not have those permissions.
- Normally in any client server (database) set up it is outside the problem domain of the application to verify that the database service is running. It doesn't matter if the service is running. What matters is if the database is accessible.
- Not all failure scenarios can be verified using ServiceController. You could very well find that the service is in fact up but be unable to connect because your app has permissions to access the service but doesn't have permission to connect.
|
|
|
|
|
Visual Studio 2005, using SQL Express, I have stored SQL procedure to insert a row into my database. The return code from ExecuteNonQuery is 1 indicating a row was added, but when I check my database, there is no new row. When I run the procedure from the IDE, it inserts a row.
When debugging I do get Method may only be called on a type for which Type.Is Generic is true.
Here is the code block
using (SqlConnection conn = new SqlConnection( sqlConnection1.ConnectionString))
using (SqlCommand cmd = new SqlCommand("dbo.insertIntoCustomerTable"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@companyName", ""));
cmd.Parameters.Add(new SqlParameter("@unitSection", ""));
cmd.Parameters.Add(new SqlParameter("@streetAddress", ""));
cmd.Parameters.Add(new SqlParameter("@city", ""));
cmd.Parameters.Add(new SqlParameter("@zip", ""));
cmd.Parameters.Add(new SqlParameter("@buissnessContactName", ""));
cmd.Parameters.Add(new SqlParameter("@buissnessContactPhone", ""));
cmd.Parameters.Add(new SqlParameter("@buissnessContactEmail", ""));
cmd.Parameters.Add(new SqlParameter("@buisnessContactEmailBad",false));
cmd.Parameters.Add(new SqlParameter("@groupEmail", false));
cmd.Parameters.Add(new SqlParameter("@isbAnaylist", ""));
cmd.Parameters.Add(new SqlParameter("@requestorCode", ""));
cmd.Parameters.Add(new SqlParameter("@toCustomer", false));
cmd.Parameters.Add(new SqlParameter("@toCustomerDate", ""));
cmd.Parameters.Add(new SqlParameter("@fromCustomer", false));
cmd.Parameters.Add(new SqlParameter("@fromCustomerDate", ""));
cmd.Parameters.Add(new SqlParameter("@toPST", false));
cmd.Parameters.Add(new SqlParameter("@toPSTDate", ""));
cmd.Parameters.Add(new SqlParameter("@iacUpdated", false));
cmd.Parameters.Add(new SqlParameter("@sft", false));
cmd.Parameters.Add(new SqlParameter("@vpn", false));
cmd.Parameters.Add(new SqlParameter("@epnVendor", ""));
cmd.Parameters.Add(new SqlParameter("@epnPackage", false));
cmd.Parameters.Add(new SqlParameter("@dlInquiry", false));
cmd.Parameters.Add(new SqlParameter("@abstractUpdate",false));
cmd.Parameters.Add(new SqlParameter("@juryExtract", false));
cmd.Parameters.Add(new SqlParameter("@bulkExtract", false));
conn.Open();
cmd.Connection = conn;
int rows = cmd.ExecuteNonQuery();
MessageBox.Show("" + rows);
cmd.Connection.Close();
}
|
|
|
|
|
do you by any chance have two databases, one you are looking at, and then being copied when launching your app (and being updated as expected)? Seems like having Visual Studio add a database to a project creates such a trap...
|
|
|
|
|
I double checked and the connection is to the SQL express database, so that does not appear to be the problem, my guess is I don't know how to insert a nullable field for the date fields and or the boolean fields.
|
|
|
|
|
IMO that does not match with your earlier statement.
However, if null is your problem, probably this[^] holds the solution.
|
|
|
|
|
Luc, I don't know if it is my problem or not.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
