GAURAVGUPTA9
7th January 2003, 07:58
Hi all
i am a developer not functional guy. i want to know if i develop a session to update some table (eg update warehouse of items in BOM table). should i go ahead. i am afraid of that this is a standerd table. may there b any problem in standerd session. can u help me out.
Regards
Gaurav Gupta

OmeLuuk
7th January 2003, 09:26
Of course any update on Baan tables not using the functional restrictions may cause problems with data integrity. An ERP system is a relational application: for example changes in the Bill Of Material may need a revision on the Item, because of material changes in the components that are contained in the item:

A computer with a newer CPU, graphical board, etc does have other specs and may need an update on the documentation.

In your example: if the warehouses are changing, then inventory levels in these warehouses should be sufficient too. Also planning constraints may be there to allocate based upon the BOM warehouse data.

So best way in your case: search for the functional session that can do the same as you want (I cannot imagine that there is none) instead of creating your own.

Paul P
8th January 2003, 03:30
Dear Gaurav,

OmeLuuk is right. There's a lot of logic involved in altering almost any data in BaanERP. You'd want to mimic the associated logic when creating your own session to alter a data in BaanERP. There are 2 ways to do it:
Mimic the program script of the session associated with changing the particular data you want to change
Use AFS (BaanERP's API) to make BaanERP update the data using the associated session in background. There's a forum here in BaanBoard specifically for AFS. Please feel free to ask more question about it

Rgds,
Paul

OmeLuuk
8th January 2003, 09:57
And these two options are open in Baan IV too...

In iBaanERP there is also a special protection in the Data Access Layer (DAL) that forces some data integrity. This concept is not available in Baan IV c4 or lower.