Sales Day Book entries

vom

I am using Navision 4 SP3 and am wanting to pull off information either in report format or preferably into a spreadsheet to allow me to reconcile my Sales Ledger Control Account but am having difficulty in finding anything that will allow me to print a list of invoices; credit notes; payments received and journal entries for a particular date range.
Ideally I would like to print these individually so I can check them and ideally drop them into excel to enable me to sort them.
Can anyone please point me in the right direction.
Thanks,
Tim

Alex_Chow

Have you checked out the Customer Transaction Details report?

sriram_venkat

Hi

Do you mean "Detailed Customer Ledger Entries" for a customer?

Please confirm

Venkat

ssingla

You can also create a dataport for customer ledger which will export data based on the posting date filter or go to customer card , drill down on balance field , press "Show All", select key with field "Posting Date", copy and paste to excel.