I want report or page which show me that how much Cash is received from customers in a particular period range.
I want further bifurcation in the same that how much is received against sales invoices raised and how much as an Advance.!
Can any one help me how to achieve this from NAV.
You need to design the report by using Cust Ledger Entry and detailed cust ledger entry.
I can get Document type “Payment” from Cust. Ledger Entry but can you tell me how this can be bifurcated that these much receipts are against invoice and others are as an advance.!!
you can locate the entry’s detailed cust. ledger entry to know whether its applied (against invoice) or Initial Entry (Advance).