Debtor reports & Statements

Hello all

I use the import facility to post sales invoices to multiple nominal codes.  The downside of this is that debtor reports and statements all show the invoice over multiple lines.  I believe this is because Sage is using the URN as a part of the data to display, I've tried removing it from the reports but I still see the invoice on multiple lines though?

 

Can anyone offer any suggestions please?

 

Thanks

Pat

Comments
ara.martirossian's picture

Need to use report which summarises data

ara.martirossian | | Permalink

Hi Pat

The reports that you are running are using the detailed data rather. Depending on which ones these are, you may be able to 'hide' the detail section and just show the summary lines (i.e. the totals per invoice rather than the individual lines). I recommend you test the other existing reports to see if any fit your needs and Sage may alos be able to point you to appropriate ones. Else, feel free to drop me an email ara@red-it.co.uk and we will explore how we can help you.

Regards

Ara

patvanaalst's picture

Have tried

patvanaalst | | Permalink

Cheers Ara, I've tried various statements (and I think debtor reports but can't recall for certain) but never found one that summarises - even when they say summarised!  :-(

 

Thanks for your quick response

Pat

Imported Transactions

johndon68 | | Permalink

The problem is that the import routine, unlike the program itself, does not group transactions with the same date and reference as a header with multiple splits, it creates a separate header and split for each line that you import...

John

patvanaalst's picture

Any Solution

patvanaalst | | Permalink

Thanks John

 

Is there any way of overcoming this problem?

 

Pat

Solution

johndon68 | | Permalink

The only solution would be to use a 3rd party import program that can group the items in the same way that the Sage UI does.

John

patvanaalst's picture

Cost

patvanaalst | | Permalink

:-(  Which I'm guessing would come with a cost...  A little diappointing unfortunately!

 

Thanks though

Pat

Indeed

johndon68 | | Permalink

Indeed, there would be an extra cost involved but not a huge one.  This one, for example, is £99 - http://www.adeptcom.co.uk/transaction_csv_import.htm

John

Add comment
Log in or register to post comments
Group: Sage 50 Accounts discussion group
An independent forum for Sage users to share ideas, tips and gripes