While it is possible, I wouldn't recommend what you are trying. Easier would be to use both comment fields. So comment 1 is 600 and comment 2 is 600.
You can the do Stringtointeger(Invoice_item.comment_1) * Stringtointeger(invoice_item.comment_2)
This will the. Give the result.
Otherwise you ...
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Search found 2 matches
- 28 Jul 2014, 11:23
- Forum: Sage 50 Report Designer
- Topic: Expressions
- Replies: 2
- Views: 3614
- 25 Jun 2014, 22:32
- Forum: Sage 50 Report Designer
- Topic: If statement
- Replies: 2
- Views: 4010
Re: If statement
Dave
Having looked at what you have asked, you could combine the 2 expressions into one such as:
STOCK.UNIT_WEIGHT * 6.3 <= 0 ? (StringToInteger(SOP_ITEM.COMMENT_2) * StringToInteger(SOP_ITEM.EXT_ORDER_REF) * 6.3 / 1000000 < 0.26 ? 0.26 : StringToInteger(SOP_ITEM.COMMENT_2) * StringToInteger(SOP ...
Having looked at what you have asked, you could combine the 2 expressions into one such as:
STOCK.UNIT_WEIGHT * 6.3 <= 0 ? (StringToInteger(SOP_ITEM.COMMENT_2) * StringToInteger(SOP_ITEM.EXT_ORDER_REF) * 6.3 / 1000000 < 0.26 ? 0.26 : StringToInteger(SOP_ITEM.COMMENT_2) * StringToInteger(SOP ...