SageForum for UK versions of Sage 50- Help and support.

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

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

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.