Table Maintenance Generator - Problem with Currency field getting unexpected value

[former_member621062]

Hi every one....

I have created the custom data base table with 6 fields are mat_no, mat_desc, mat_qty, mat_uom, mat_price, mat_curr and also generated TMG. I have provided the reference fields for quantity and currency fields and also maintained the foreign key relationship for quantity units and currency key fields. when I am maintaining the table through the TMG currency field getting 3 decimals but i have given only 2 decimals in domain but it is updating the data base correctly with 2 decimals.

for Example I am giving the data like

mat_no - 2.

mat_desc - Close up past.

mat_qty - 5.

mat_uon - PC.

mat_price - 200.00.

mat_cur - INR

here i have given mat_price was '200.00', but after click on save button it shows like '20.000'. that is the my problem.

Can you please any body provide the proper solution.

[raymond_giuseppi]

Did you check in online documentation for Currency Fields and Quantity Fields, look for external and internal format.

Hint: For domains, did you use correct types of data, CURR and QUAN?

NB: Also TMG are not actually a very good tool to handle some master data, they were intended for one-shot or Customizing type of tables.

[former_member621062]

Thanks Raymond for responding.

I have given correct data types for quantity and currency fields. I am not able to see correct format for currency field in TMG level but in data base, I am able to see correct format.

[Sandra_Rossi]

Please use the COMMENT button to reply to someone. ANSWER is only to propose a solution.