Combining 2 Reports in Sage 50 Accounts
I'm fairly new to creating reports in Sage 50 Accounts, and I have a question that hopefully someone more knowledgable might be able to help me with please...
I have 2 reports that work fine. I am trying to combine the 2 reports into one...
One report shows INVOICE_ITEM.DESCRIPTION and INVOICE_ITEM.QUANTITY(Sum), for Invoices from a given date (which is set by Criteria).
The other report shows STOCK.DESCRIPTION and STOCK.QUANTITY_LAST_STOCK_TAKE, for all items where the Quantity Of Last Stock Take does not equal zero.
Both reports group by STOCK.STOCK_CAT.
So ideally I would like the report to look like this:
Invoice/Stock Item Description: Total Invoice Item Quantity: Quantity Last Stock Take:
The problem I have is this: If I add STOCK.QUANTITY_LAST_STOCK_TAKE to the first report, it still only returns INVOICE_ITEM.DESCRIPTION's from the given Invoice Date range, whereas I want it to also include ANY other items that have a Stock Take Quantity, regardless of whether they fit the Invoice Date criteria... then group them all by STOCK.STOCK_CAT.
So to summarise, it needs to show:
Items that fit the Invoice Date criteria, OR:
Items that have a Quantity Last Stock Take <> 0, OR:
Thanks in advance for any help!
Running Sage 50 Accounts 2008 Version 220.127.116.11 on:
Windows XP 32 bit
Windows 7 32 bit
windows 7 64 bit