I think I have finally got this working !
I added a new expression field called UNITS by using the toolbox AND the former field I created called STOCK.QTY_SOLD_MTH1 was still there (see above), but when I deleted this former field, it errored again, so having this variable as a field on the report ...
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
- 10 Sep 2008, 13:32
- Forum: Sage 50 UK version General Help
- Topic: Expressions in Report Designer
- Replies: 1
- Views: 2564
- 10 Sep 2008, 11:34
- Forum: Sage 50 UK version General Help
- Topic: Expressions in Report Designer
- Replies: 1
- Views: 2564
Expressions in Report Designer
I am using v14 Sage Line 50 Professional. I am new to SAGE and am self taught.
I am trying to add a new calculated field to a PNL report to show the number of units sold as well as the balance. I added the expression (based on the CATEGORY.DISP_MTH1 field),
'PeriodAggregate("STOCK.QTY_SOLD_MTH ...
I am trying to add a new calculated field to a PNL report to show the number of units sold as well as the balance. I added the expression (based on the CATEGORY.DISP_MTH1 field),
'PeriodAggregate("STOCK.QTY_SOLD_MTH ...