Informizely customer feedback surveys




Se de seneste forbedringer




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

<p dir="ltr">Venlig hilsen/Best regards</p> <p dir="ltr"><strong>&nbsp;</strong></p> <p dir="ltr"><b>Lauris P. Sørensen</b></p> <p dir="ltr">Team Scale, Planet WOW</p> <p dir="ltr"><strong>&nbsp;</strong></p> <p dir="ltr"><img src=" width="258" height="27" /></p> <p dir="ltr"><strong>&nbsp;</strong></p> <p dir="ltr">e-conomic er et produkt fra</p> <p dir="ltr">Visma e-conomic A/S</p> <p dir="ltr">Gærtorvet 1, 1799 København V</p> <p dir="ltr">CVR-nummer: 29403473</p> <p dir="ltr"><strong>&nbsp;</strong></p> 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. <br>- <a href="https://forum.e-conomic.dk/tag/overvejes"> Hop herind og stem på de forslag du er enig i! </a></p>
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