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

clement_blue

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

Prem

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