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
Suppress Line unless qty remaining to despatch
-
- User
- Posts: 10
- Joined: 09 May 2022, 15:41
- Sage Version: v29 UK/Europe/Africa
Suppress Line unless qty remaining to despatch
Hi Bruce and all
I am editing the Sales Order Report, and looking to create a report that only shows lines that are waiting for despatch.
We use an external program (CIM50) to despatch our items - I am not sure if this affects things?
Originally I used 'SOP_ITEM.QTY_ORDER - SOP_ITEM.QTY_DELIVERED = 0.00', but this suppressed everything in the column.
I have tried entered conditional formating (SOP_ITEM.STOCK_CODE LIKE "M") and TRUE on suppress printing, but the whole column is suppressed, not just items with stock code M. I have also tried 'SOP_ITEM.QTY_ORDER = 20.00' as this particular order has 20qty of 2 items, and then qty's of 30,15,5,50 etc. so I thought this would only suppress 2 lines, but again it suppresses the whole column.
Do you have any idea what I am doing wrong?
Picture attached of the report, and the preview output from this.
Thanks
I am editing the Sales Order Report, and looking to create a report that only shows lines that are waiting for despatch.
We use an external program (CIM50) to despatch our items - I am not sure if this affects things?
Originally I used 'SOP_ITEM.QTY_ORDER - SOP_ITEM.QTY_DELIVERED = 0.00', but this suppressed everything in the column.
I have tried entered conditional formating (SOP_ITEM.STOCK_CODE LIKE "M") and TRUE on suppress printing, but the whole column is suppressed, not just items with stock code M. I have also tried 'SOP_ITEM.QTY_ORDER = 20.00' as this particular order has 20qty of 2 items, and then qty's of 30,15,5,50 etc. so I thought this would only suppress 2 lines, but again it suppresses the whole column.
Do you have any idea what I am doing wrong?
Picture attached of the report, and the preview output from this.
Thanks
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Suppress Line unless qty remaining to despatch
Is "LIKE" a valid operator?
Perhaps you could attach the layout to your post as it may be something else.
As a general rule, when "debugging" reports it is useful to create an expression on the page which you can see the result of and be sure you are getting the values you expect.
SOP_ITEM.QTY_ORDER - SOP_ITEM.QTY_DELIVERED = 0.00 seems perfect to me, i suspect that it is something subtle.
Perhaps you could attach the layout to your post as it may be something else.
As a general rule, when "debugging" reports it is useful to create an expression on the page which you can see the result of and be sure you are getting the values you expect.
SOP_ITEM.QTY_ORDER - SOP_ITEM.QTY_DELIVERED = 0.00 seems perfect to me, i suspect that it is something subtle.
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.
-
- User
- Posts: 10
- Joined: 09 May 2022, 15:41
- Sage Version: v29 UK/Europe/Africa
Re: Suppress Line unless qty remaining to despatch
Thanks Bruce
The LIKE "M" was from the Sage webpage on how to use conditional formatting!
Please find the .layout atatched. I have SOP_ITEM.QTY_ORDER - SOP_ITEM.QTY_DELIVERED as the first column, and it shows nothing for all rows, except the row that still needs 3 items despatching.
This is then in the conditional formatting, with suppress priting, but suppresses the whole column still.
is it becuase SOP_ITEM.QTY_ORDER - SOP_ITEM.QTY_DELIVERED doesnt = 0?
Thanks
Steve
The LIKE "M" was from the Sage webpage on how to use conditional formatting!
Please find the .layout atatched. I have SOP_ITEM.QTY_ORDER - SOP_ITEM.QTY_DELIVERED as the first column, and it shows nothing for all rows, except the row that still needs 3 items despatching.
This is then in the conditional formatting, with suppress priting, but suppresses the whole column still.
is it becuase SOP_ITEM.QTY_ORDER - SOP_ITEM.QTY_DELIVERED doesnt = 0?
Thanks
Steve
Login to access the files attached to this post.
-
- User
- Posts: 10
- Joined: 09 May 2022, 15:41
- Sage Version: v29 UK/Europe/Africa
Re: Suppress Line unless qty remaining to despatch
Hi Bruce
Did you have any luck looking at this?
Thanks
Did you have any luck looking at this?
Thanks
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Suppress Line unless qty remaining to despatch
Sorry very busy, I can't turn customers away to give free help on the forum.
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.
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Suppress Line unless qty remaining to despatch
I have had a look.
I gave the expression on the left of the Item_Number Section the name "Outstanding" having an expression without a name is not a good idea.
I switched off advanced conditional formatting, not sure why you were trying to use it. I think the conditional formatting may have been setting suppress print to true, but it was already set to true so nothing printed either way.
I removed all the conditional formatting from all items in the section
I set all items to have suppress print set to false as they were set to be hidden by default
I changed the filter on the section to be "SOP_ITEM.SERVICE_FLAG = 0 AND Outstanding > 0" so only items that have an outstanding qty will print.
The way you were trying to do it, even if you had been successful, you would have got blank lines wherever there was a line that had been completed. With my approach the line is only printed if there is an outstanding item, there is no conditional formatting at all.
“If the only tool you have is a hammer, you tend to see every problem as a nail.” - Abraham Maslow
Attached is my reworking, hopefully you can see how it works and it makes sense to you
I gave the expression on the left of the Item_Number Section the name "Outstanding" having an expression without a name is not a good idea.
I switched off advanced conditional formatting, not sure why you were trying to use it. I think the conditional formatting may have been setting suppress print to true, but it was already set to true so nothing printed either way.
I removed all the conditional formatting from all items in the section
I set all items to have suppress print set to false as they were set to be hidden by default
I changed the filter on the section to be "SOP_ITEM.SERVICE_FLAG = 0 AND Outstanding > 0" so only items that have an outstanding qty will print.
The way you were trying to do it, even if you had been successful, you would have got blank lines wherever there was a line that had been completed. With my approach the line is only printed if there is an outstanding item, there is no conditional formatting at all.
“If the only tool you have is a hammer, you tend to see every problem as a nail.” - Abraham Maslow
Attached is my reworking, hopefully you can see how it works and it makes sense to you
Login to access the files attached to this 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.
-
- User
- Posts: 10
- Joined: 09 May 2022, 15:41
- Sage Version: v29 UK/Europe/Africa
Re: Suppress Line unless qty remaining to despatch
Thats amazing, thank you Bruce
I think I had tried so many different things, that I forgot to undo lots of them!
I have now made these changes to my report and it is working as expected.
Thank you
I think I had tried so many different things, that I forgot to undo lots of them!
I have now made these changes to my report and it is working as expected.
Thank you
Who is online
Users browsing this forum: No registered users and 3 guests