UserTable Docentry

[Former Member]

Hello All,

I do have a question to the UserTable as Object. (master data)

There ist Code (indexed as Primary), Name as standard and as well the Docentry.

The Docentry is managed by B1 it self ok thats clear so far. There are 2 Questions.

1. what is b1 doing with it? (not just numbering)

2. why there is no index on it and as I know there is no option to set an index from api to it?

3. why does the Masterdata Lines do not have the Docentry as a key?

This just to understand the things right.

Best Regards

Oliver

[Johan_H · Accepted solution]

Hi Oliver,

My thoughts on these questions, based on experience with Business One almost-pre-SAP:

1. B1 uses DocEntry in general as a unique permanent identifier for system use. It is not really meant to play any functional role for the user. That said, my guess is, that it is part of a longer term development plan.

2. Indexes take up space, and (as far as I know) DocEntry (in master data anyway) is not used in any active capacity that would warrant an index.

3. Good question. Looking at some suggestions on the SAP Business One Idea Place, perhaps SAP will introduce such a key binding at some point in the future.

My best guess is, that the DocEntry field is relatively new in the B1 master data tables. The original design structure appears to bind all header - row tables using ItemCode and CardCode.

In other words, it developed this way, it was not designed this way from the start.

Regards,

Johan

[Former Member · Accepted solution]

Hi Johan,

thanks for input. I will see if I finde some thing to it...

The only thing I see is, that the Docentry numbering is done through B1...  an this is a second parameter... but according to what??? I have no Idea  what they would like to do with it...

Best Regards

Oliver

[Johan_H · Accepted solution]

Hi Oliver,

If I understood your question correctly, as far as I know the DocEntry number is a simple running number. However, I guess it does not start at 0 or 1, but what the logic for the starting number is, I am not sure.

After that the DocEntry is a unique identifier for the given object, be it document or master data. So usually it is the combination of DocEntry and object type that makes for the unique identifier system-wide.

Regards,

Johan

[Former Member · Accepted solution]

Hi Johan,

yes I know. The question for the Docentry at master data... was not so clear to me, For Documents.. ok, the lines are bound to it and this makes sense... but not for the Masterdata.  In case of eding a Line to Masterdata Object, there is no relation to the docentry... but why??? programmatically it is not the best way doing something with the Docentry... if so, you have to catch Data Add after... getting the Lines adding the Docentry or do something with SP...  And the Docentry in this case is a UserField....

That is the thing I really do not understand... (the Idea behind it)... And I was thing about the docentry, what I could or have to do with it.  And this compliantly unclear to me...

Best regards

Oliver

[Johan_H · Accepted solution]

One thing that comes to mind, is serial numbers and batches maybe ?

[Former Member · Accepted solution]

yes may be... but what happens with Code??? this is the Primary key...??? I really don't know...

But anyway it is like it is 😉