Informizely customer feedback surveys

How can I run a report of amounts invoiced by depatment code?

0

Hi

We use department codes on most sales invoices.  We would like to run a report on amounts Invoiced breaking down the invoiced amount by department dimension.

1.     Cannot do it by searching on Sales > invoicing > Archive, because Department is kept at invoice line level, not invoice header level.

2.     Cannot do it by Reports > Customers > Turnover Statistics as I get the totals but not the line by line, invoice, by invoice, detail.

3.     Cannot do it by Accounting > Searches & Lists > Find entries, because department selection not an option.

4.     Can sort of do it by running an Export and then analysis in Excel, but takes 5 mins+ each time.

Have we missed something?  Is this something others would want?  Our preference would be 3. Add department code as a selection criteria;  2. Add an option to see Invoice header details.

Thanks

Stephen

lukket
i Spørgsmål » Dimension (afdelinger) af (200 points)
status opdateret af

1 Svar

 
Bedste svar
Hi Stephen

Thank you for your forum post and question.

I see one additional way, you might be able to put to good use.
Going in Reports > Ledger cards > For all or one of your revenue accounts, bounded by department number and dates.
This report will show you entries/invoices line by line, and department numbers on the entries.

Otherwise you can export the data to Excel as you mentioned, where we could sort and analyse it, but it seems that you know that workaround and it is not a solution for you.

I would appreciate if you could get back to me, with your thoughts about this solution.

Kind regards

Venlig hilsen/Best regards

 

Lauris P. Sørensen

Team Scale, Planet WOW

 

image

 

e-conomic er et produkt fra

Visma e-conomic A/S

Gærtorvet 1, 1799 København V

CVR-nummer: 29403473

 

Hvis du gerne vil have indflydelse på de næste forbedringer, så er du velkommen til at besøge vores liste over forslag vi på nuværende tidspunkt overvejer.
- Hop herind og stem på de forslag du er enig i!
Spørgsmål af (35.0k points)
valgt som bedste svar af
Hi

Yes I had seen the Ledger Card solution, but I did not like it so much as I was hoping for a listing of invoices (i.e. in invoice order), whereas the Ledger Card report has the invoices split into the related Ledger Account.

However in the absence of any other report that shows this data without any further drilldown, I think the Ledger Card is my best solution.  It also allows me to click and view the invoice in case I need further details which is useful sometimes.

Thanks for the reply.

Stephen