Adding WEB_DETAILS to a Sales Order Layout inhibits "M" (message) fields

Question

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

Darron Cockram · Accepted Answer

John Smale said: 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.

Darron Cockram · Answer

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.

Sage 50 Accounts

Adding WEB_DETAILS to a Sales Order Layout inhibits "M" (message) fields

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING