Purchase Ledger Control Account Report showing Narratives

Business Central/NAV User Forum
1

Hi

I was wondering if there was a report that would give me the narrative of Purchase Invoices.

I am preparing the year end accounts, and need this information so I can see which invoices need to be in accruals at the year end. I don’t want to have to go through every invoice, looking at the description, that has been posted since the year end as there are thousands.

I can see reports that give me the description, but none that give me the narrative

Thanks

Paul

2

you want to have description field of Purch. Inv. Line on report or some other field?

3

I want to have the narrative field on the report

4

Is it in Purch. Inv. Line only or some other table ?

5

I’ve found out how to do it now. I’ve imported the GL entries on the Purchase Ledger to Excel and sorted by invoice date.

Thanks

6

Hi Paul,

Why don’t you simply use BI to solve reporting? You don’t need to export your data to excel. This is done in BI on daily basis. Once you set up the report (it’s very easy as you have data cleaned and prepared for analysis) the structure will stay the same and you will have report ready each time you open Excel.

BI allows you to go all the way to the document type.

BI4Dynamics offers full blown data warehouse BI solution that covers all NAV application areas and you can test solution for free without any risk. You get full solution and pre-defined reports for 30 days.

Let me know if you’re interested and we can help you out. We offer free support during trial period.

Best Regards,

Klemen