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

Search found 3 matches

by Charlo
02 Apr 2020, 08:49
Forum: Sage 50 Report Designer
Topic: Expressions
Replies: 10
Views: 13971

Re: Expressions

Since in the Commodity code i have written C/S X12 (case x12) can do the sum with the string as you said but I leave the words c/s x
by Charlo
02 Apr 2020, 08:26
Forum: Sage 50 Report Designer
Topic: Expressions
Replies: 10
Views: 13971

Re: Expressions

Perfect, THANK YOU!
by Charlo
25 Feb 2020, 11:26
Forum: Sage 50 Report Designer
Topic: Expressions
Replies: 10
Views: 13971

Re: Expressions

Hi i'm trying to divide the following but it is giving me an error
StringToFloat(INVOICE_ITEM.QUANTITY)/(STOCK.COMMODITY_CODE)

where commodity is a CASE number so i need to divide the quantity of the order item by how much a case has (144/4=36 cases)