Sales Day Book entries

vom · 2008-02-26

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 · 2008-02-26

Have you checked out the Customer Transaction Details report?

sriram_venkat · 2008-02-27

Hi

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

Please confirm

Venkat

ssingla · 2008-02-27

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.

Sales Day Book entries

Comments

Categories