Hi
I need to change the PURCHASE_DETAIL.QTY_ORDERED mask type from integer to decimal as we receive in half measures not just full measures. e.g. cable of 10.5m. How can I do this and will this have a negative effect on anything else?
Solved
FSM Metadata change mask type from integer to decimal
Best answer by Saranga Amaraweera
Hi
I assume that you can do this by reserving the qty_ordered field from custom metadata (overriding the standard table mask type) since the data type in the database it self is numeric(28, 10). Just give it a try and check whether the values are being inserted as expected with the decimal mask type.
+22Hi
I assume that you can do this by reserving the qty_ordered field from custom metadata (overriding the standard table mask type) since the data type in the database it self is numeric(28, 10). Just give it a try and check whether the values are being inserted as expected with the decimal mask type.
Hi
Ok, so I created the table PURCHASE_DETAIL table in custom metadata and created the QTY_ORDERED column in the table but changed the mask type to decimal. And this worked! Thank you for the help
We are still having issues and have identified a bug on mobile as it does not allow user to type a , or . when you input quantity used
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.