Is there a way to check field's ID that is already used?

clement_blue
clement_blue Member Posts: 16
edited 2009-06-01 in NAV/Navision Classic Client
Due to I'm new in Nav, so I recently faced a problem about how to understand the table structure/relationship between tables. The situation in the following:

-> I Add a new field "Cancelled" in 'Sales Shipment Header', and DataType is 'Boolean' with ID=50013.
-> However the ID had been used by other field in 'Sales Header' table, and its DataType is 'Code'.
-> After user post D/O from SO, user received an error message:
The two fields below must have the same type:
Field: Cancelled <-- Sales Order No.
Table: Sales Shipment Header <-- Sales Header
Type: Boolean <-- Code20

I would like to know that is there a way to check the ID in order to avoid the repeated ID? Because I do not want to realize that after customer to see the problem. Thank You :)

Comments

  • Prem
    Prem Member Posts: 34
    Hi Clement,

    This is Happening because of the Transferfield Statement, lucky that you used Boolen, if the Datatype was code , you wouldnt have seen the error.

    When ever you add a field to Sales Header, You should always check for the field availability on the following Tables i mean the field ID's.

    Sales Shipment Header
    Sales Invoice Header
    Sales Credit Memo Header.

    You Can find the field id's used by going to the designing mode of these Tables.

    Cheer's

    Prem

Categories