Combining 2 Reports in Sage 50 Accounts

[richiejames]

Hello...

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:


Stock Category:

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:
Both.

Thanks in advance for any help!



Running Sage 50 Accounts 2008 Version 14.0.12.153 on:

Windows XP 32 bit
Windows 7 32 bit
Windows 7 64 bit

[brucedenney]

Sorry, what you want to do is merge 2 reports together, but there is nothing linking them to each other so is structurally unachievable.

[brucedenney]

What you might be able to do is to create the report in excel using EIR and then place them alongside each other in a spreadsheet, you could then print the sheet.