Sage Report Designer Problem
Posted: 27 Jul 2011, 15:21
We have amended the sage std A4 Despatch Note to our own company design. We use Projects for all our orders and need to display the Project Ref on the despatch note. I have added a Join (in join editor)between 'Invoice Item Project' & 'SOP Item' (using Project ID as the link), this has allowed me to select the Project Reference in the report. The only problem is that we now get multipul lines of the same item in the 'Details' area on the despatch note. If I remove the Join the problem remains.
Can anyone help please!
Can anyone help please!