The product description box is too limiting for us, and on this forum I found a hint about using the "web details" to add extra info for printing on reports.
I have added this to one of our reports (a tweaked version of the OrderAck layout) as an extra footer containing a variable box with the expression "STOCK.WEB_DETAILS".
All seems fine apart from one *really* annoying "feature" ... none of the S1, S2, S3 or M lines appear any more.
If I change the expression to *any* other non-STOCK expression, then the missing lines magically re-appear !!
In fact, if I place a STOCK variable *anywhere* on my layout, the S1, S2, S3 and M lines are never shown.
Can anyone help me ?
This is driving me loopy !?!
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
Adding product web details to reports
Re: Adding product web details to reports
Fixed it ... finally !?!
In Data->Joins, I needed to change the link from SOP_ITEM to STOCK from an "Inner" to a "ParentOuter" join type.
Obvious, really ...
In Data->Joins, I needed to change the link from SOP_ITEM to STOCK from an "Inner" to a "ParentOuter" join type.
Obvious, really ...
Who is online
Users browsing this forum: No registered users and 3 guests