Skip to main content

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?

Hi @MatAntoiF ,

 

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 @Saranga Amaraweera 

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


Terms & ConditionsCookie settings