I have a fully working Layout for Printing Quotations (run from Sales Orders) but if I add the WEB_DETAILS data field to the report, it inhibits "M" (Message) items being displayed.
Accounts, v28.0.226.0 & Report Designer v5.0.251.0
I have a fully working Layout for Printing Quotations (run from Sales Orders) but if I add the WEB_DETAILS data field to the report, it inhibits "M" (Message) items being displayed.
Accounts, v28.0.226.0 & Report Designer v5.0.251.0
WEB_DETAILS is part of the STOCK record so the problem will likely be you are using an inner join to link to the SOP_ITEM table. You'll need to change this to a left join (ParentOuter) otherwise only records with a matching stock record will be returned,
Edit the report and go to Report -> Joins, select the line that joins SOP_ITEM to STOCK and in the properties pane change the Join Type property to ParentOuter. That should sort the issue.
Hope that helps.
Thank you Darron - very nice detailed instructions, that worked!
I had also generated a very simple NEW "Layout" from basics as a test for this Sales Order (e.g. Quotation) printing. The join was as you suspected. Is this something that SAGE should change in the Report Template?
Is this something that SAGE should change in the Report Template?
Unfortunately there is no 'right' answer as to whether the join should be an inner or left join by default. In some cases an inner join is what is desired so only matching records will be returned. In other cases, such as yours, the desire is a left join as you want records regardless of match. A case of damned if you do and damned if you don't I'm afraid.
*Community Hub is the new name for Sage City