Is there any kind of document which explain all themandatory fields in NAV 5.0 in the following areas vendor, item ,customer, fixed assets, bank accounts, G/L account table [:D]
Sorry no, but not many depending upon what you want to do. The manuals and help files will explain the fields, but they will not define what is mandatory.
Almost all primary Id-fields are mandatory (Customer Account No, Item No, Location Code, …). And most Options-fields get a default value from option=0.
There is a table-field-property: NotBlank; but that is only used in primary-key-fields; only way to check for other mandatory field is in table’s OnInsert and OnModify.
From the very begining Navision was designed so, that user could go on working by filling in absolute possible minimum fields… the idea was, that some smart guy afterwards will add the missing data, but mass entry can be performed quickly buy low-qualified operator. So, accordingly to this approach, mandatory fields are kept down to minimum, as well as Default Values.
Sometimes (I would say rather often) it causes problems, when you suddenly find out, that some critical data simply can’t be added afterwards. (for example, Dimensions to posted transactions, but these can be set as Mandatory). You must take this into consideration, when planning a solution, and add the neccesary Mandatoriness or Defaultness [:)], where it can cause problems if fields are left empty.