What is the usage of Value Entry Relation table?

selece28selece28 Member Posts: 316
Hi Nav masters,
I want to ask something. What is the table Value Entry Relation used for?
Can i delete it if i don't use item tracking on my items?

Thanks in advance
______________

Regards,
Steven

Comments

  • garakgarak Member Posts: 3,263
    This table is used to relate value entries to the posted document lines when carrying item tracking.

    It manages the posting and lookup of such item tracking entries and works in parallel with the Item Entry Relation table.

    These tabes is only filled, when u use item tracking in your items.
    Delete the table :?: [-X

    Also used when use item tracking is the tabe Item Entry Relation.

    This table is used to relate item ledger entries to the associated posted document line when carrying item tracking.

    An "ordinary" posted line not carrying item tracking will always be related to only one item ledger entry, and this relation is managed by registering the entry number in a field on the posted line, for example the Item Shpt. Entry No. field on a posted sales shipment line.

    However, from one posted document line carrying four serial numbers, there will be four item ledger entries and, therefore, the Item Entry Relation table is needed to manage the one-to-many relation during posting and lookup.

    The "ordinary" relation field on the line will be empty if the document line carries item tracking.


    Regards.
    Do you make it right, it works too!
Sign In or Register to comment.