98 - Cash Receipts in Dynamics NAV 2018 Pt. 1

98 - Cash Receipts in Dynamics NAV 2018 Pt. 1  

Today I’m actually going to jump into a little bit of a different topic for a moment, we are definitely gonna keep going on CRM and be exploring 2018 new things, but this actually was a request so, I'm gonna dive into cash receipts in NAV and the customer ledgers etc.

Customer ledgers
I’m logged in here as the accountant manager and if I go into customers, I like setting up things with the Cannon group, it's the demo customer. And if I go here into the entries for the customer, go into navigate, ledger entries, I can see these are the transactions that have happened for the customer, customer is an entity, entity has transactions, and here they are. This is pretty straightforward to most people that have used NAV, for new users of course here it is, nice things about this, you can actually see in red if anything is due.

One of the important things to notice is the remaining amount and open, so if anything is open that means the transaction has not closed yet, which means it hasn't been paid or its an open balance on a credit or a payment that has not been applied, so these are important facts to look out for, and what I just wanted to quickly show you her, is how to apply open credit or open payments to existing open balances.

Here I have some invoices that have a remaining amount, and I got a credit memo here that has not been applied and I just get an email from the customer saying hey! Can you apply that credit memo to the oldest invoice that we have? of course.

So I just go in here to the credit memo, click on that and go into apply entries, then I get up the screen here so, this screen is telling me ok, you want to apply the credit or notice that on top we have the credit memo primed and then at the bottom we have all the open entries that I can apply it to and in this case I would like to apply to that 5,000 dollar one.

You can see that right here, and I just click on that and I click on set applies to ID, so my name will come up here, or my login, I’m logged in as demo, now I’m applying it here, and I can also see on the side that the amount to apply is here, but I could change that I’m gonna apply the entire amount, but I could change that. I can also go the other way around where I’m actually looking at the invoice on top and applying for the credit.

But we’ll do it this way, so I’ve set tit, now I just go ahead and say post application, and I can say the posting date, it's important because if you have open entries and you apply a payment to it or a credit, it matters at what time the application happens, there are two factors in that, for example if you run eight accounts receivable before you made the application its gonna show us opened on the Ads accounts receivable, if you run it after the application or the posting date of the applications, then it's gonna be closed. That's a little nuance of course.

Another thing is that if its a currency transaction then when you apply and you actually close, it matters for the currency calculation. Because it's gonna take the currency of that transaction date.

Here I’m just gonna leave it as it is and I posted, says successfully posted, and now this is zero and that balance has actually been lowered by the current amount, so I’m gonna jump to another video on this as well about cash receipts to show you how the post goes. But for this one, done.