We are trying to include an expression in a qr code that exists within another section - it doesn't seem to work. My qr code is as follows:
SALES_ORDER.DEL_NAME+SALES_ORDER.DEL_ADDRESS_1+SALES_ORDER.DEL_ADDRESS_2+SALES_ORDER.DEL_ADDRESS_3+SALES_ORDER.DEL_ADDRESS_4+SALES_ORDER.DEL_ADDRESS_5+SALES_ORDER.ORDER_NUMBER+Expr20
The Expr20 doesn't work. I assume because it is in another section (Details).
Can you help?
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
Including Expression from another Section
-
brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Including Expression from another Section
What is the expression?
Could you attach the layout, report to a post
Could you attach the layout, report to a post
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Including Expression from another Section
Hi, thanks I have attached. As discussed I am trying to get the expr20 to be included in the qr code (top left).
Login to access the files attached to this post.
-
brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Including Expression from another Section
At the point where the header is printed all the items have not yet been printed so the value of Expr 20 will not be known.
The issue is the Expression 20 is either 1 or 2 depending on the item.
The Order could have more than one item, so it could have some lines that have 1 on and some that have 2 so what value you want in the qr code it indeterminate.
You could do max or min of that expression and use that, but then these still happen after the QR code is printed, you can either move the QR code to the footer after the lines are printed and the expression can be determined or you may be able to use use the aggregation feature to do it.
The issue is the Expression 20 is either 1 or 2 depending on the item.
The Order could have more than one item, so it could have some lines that have 1 on and some that have 2 so what value you want in the qr code it indeterminate.
You could do max or min of that expression and use that, but then these still happen after the QR code is printed, you can either move the QR code to the footer after the lines are printed and the expression can be determined or you may be able to use use the aggregation feature to do it.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Including Expression from another Section
Thank you I will give it a go.
Who is online
Users browsing this forum: No registered users and 11 guests