Trying to have invoice narrative on project downloads. Can anyone help?

Question

Hi all, 
 I've been trying to change the data shown on a project activity download to show the narrative of sales invoices, rather than a small amount of relevant, but not necessarily descriptive detail. Currently, the small amount of detail will give us the project number and name, or the header of the invoice, pulling from the Description field, as below 
 
 Is there anyway of getting the Projects report to pull from the Details section instead? I've tried myself to find the correct field, but to no avail, Does anyone know which field I can pull this info from? 
 Thanks in advance

Ian C · Answer

Hi Paul, 
 Thanks for using Sage City. 
 The variable you'd need for the details section is INVOICE_ITEM.TEXT 
 Your report will need access to the INVOICE_ITEM table but if you're already able to see the description text (INVOICE_ITEM.DESCRIPTION) it sounds like you already do. 
 You can find all variables in the future here >> Which Report Designer tables and variables to use - Sage Accounts v21 and above 
 If this has answered your question please click More > Verify Answer. 
 Regards, 
 Ian

Ian C · Answer

Hi Paul, 
 You can get the invoice number / date / total etc on a STOCK_TRAN report but you can't get the individual item line information. 
 You'd need to look at what joins are possible. Joins are the property that allows information on to a report, this guide will show what is and isn't possible >> Report Designer - Common data joins for Sage Accounts 
 It's often tricky to get item line information on to a report, in a different area of the program. 
 Ian

Sage 50 Accounts

Trying to have invoice narrative on project downloads. Can anyone help?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING