I’m exploring the Acc-Pac DB tables and I noticed in the PM… (or Project and Job Costing) table the CONTRACT value is always stored without a decimal.
e.g. 10042, 51891, 31311 . Within the AR… (or Account Receivable) tables the CONTRACT value is stored the decimal e.g. 1004.2, 5189.1, 3131.1 similar to the “FMTCONTNO” column in PMCONTS table.
The PM CONTRACT field should be able to record a decimal given values are stored as a string. Has anyone come across this issue before? I'm assuming its a bug in the system in how the entered information transfers from the front-end to the DB.