I am trying to tweak a product valuation to add column for shipping costs per unit.
I have used Web Category 2 to enter costs attributed to each product. I am now trying to get the report to calculate the figure in WEB_CATEGORY_2 by multiplying with Qty in stock. How can I change the custom box to act as a number?
Thank you in advance for any help offered.
Thanks for using Sage City
The following functions may be of use:
E.g., To multiply the quantity in stock by a number entered in Product Record > Location:StringToFloat(STOCK.LOCATION) * STOCK.QTY_IN_STOCK
E.g., To multiply the quantity in stock by a number entered in Product Record > Unit of Sale:StringToInteger(STOCK.UNIT_OF_SALE) * STOCK.QTY_IN_STOCK
** All records must have a number entered in the appropriate format, there are any non-numeric values, blank fields or whole numbers the following message appears: 'Input string is not in correct format.'
I hope this helps
Fiona, Sage UKI