Hello everyone, welcome to A La Carte GP.com, this is kyle malone and
Today we are talking about the customer vendor consolidation within Dynamics GP
2015 R2
The customer vendor consolidation process doesn't really vary between the versions but we are working with 2015r2 today
I'll apologize in advance. The sound quality here is a little off in this video
But we will take care of it for future videos. Enjoy
So first things first once you're in GP 2015
you want to scroll down to the customer setup and go to the customer and vendor setup and
Define your suspense account that will be used
So anytime you transfer transactions from AP to AR or AR to AP you have to use this default suspense account
Which will essentially be debited and credited with in the process
So you'll see my example below that I've selected a
Suspense account. So once I have my account selected, I'm just going to go ahead and save my settings
So now the second option second step here will be to
Come into the sales cards customer vendor setup window and define your customer vendor relationship
In my example, I'll just use the first two in the list
But obviously you'll want to go in here and select the customer and vendor account that relate to the same entity
So over here, I have Aaron Pitts
Hooked up to H travel
Alright so there are two separate scenarios here that we can benefit from the first being where a new entity is a customer a vendor
And say they owe us
$100 but in return we owe them $50 on the person's inside
so we have an outstanding invoice in the sales module and
They don't want to pay they'd rather substantially the balance against what we owe them
So what we'll do here is we go under sales transactions customer vendor transactions
So within here what I want to do is I want to transfer the balance from the vendor card
To the customer card, so I'm going to go in on the select my vendor ID
I have A travel connected to a customer having benefits in this example, and I'm going to say okay
I'm going to transfer it from my vendor balance. I went to transfer to receivables. So as I tab through I
Have all of my outstanding ap vouchers and so I'm just going to scroll down and say okay well
the customer here has
$100 that they wanted to take off
So I'm just going to select one of the vouchers. I'm gonna say I don't want the whole amount. I just wanted $100
If I want to I can click preview and
I will see that I'm taking now $100 out of my payables and $100 out of my receivables
So I have to pay less and less
Close out the window to get the reports and here comes a barrage of reports
So today I just want to show the posting journals
And the first beaded receivables posting journals, so we had a
Outstanding invoice. Well now we have a credit memo for $100 that we've transferred over from the purchasing side
The second here is our people aside
And again, we have an invoice and now we have a $100 credit out the vendor account which is transferred to the receivable side
All right, so now if I want to I can go into inquiry I'm going to pull up my customer
Aaron Fitz, I'm going to sort on today's date
Uh-huh. Here's my last credit memo
So as I pulled it up, I see that there was a balance transfer from hundred dollars
It's not currently applied like it then open up the apply transactions window and apply this to an outstanding invoice
So that's the first feature the second is going to be issuing credit refunds. So
Actually the exact opposite of what we just did so instead of transferring a balance from payables - receivable
We're not going to take a receivable balance and transfer it over the payables. This would obviously be the case when we say that
The customer doesn't know us but that you actually owe them
So that would be through a credit or a return and we don't want to wait for the next invoice payments
We want to issue their check so that we're back to square
So the first thing I want to do here is open up
sales transaction refund checks
I'm gonna go ahead and call it home check
Okay, so now I'm going to create refund checks window and I created my batch and now I know that there's a specific customer that
Has a outstanding credit memo that I want you to return for
So again, I'm when it's like this I'm gonna select insert it'll bring up all of his credit documents
so I see a return down here for
$2,500 then we go ahead and select this and say I want to issue that back to the entity
So now that I have the transaction selected I can view my edit list
Or I can get right into processing the transaction then movies from sales to purchasing
And again, we'll take a look at these sales and purchasing posting journals
So on the sales side we had the credit balance and now we'll have a debit transaction come through as you can see right here
and
on the purchasing side
You now have a miscellaneous
Increase to their account as we see here
All right, so the transactions both can post it and it already skips us to the print tables checks process
So from here, it's the same as it normally is and you could finish out the rest of your process
I'm going to go ahead and print my chest
And there we are
All right, so that does it for today do us a favor and subscribe to our YouTube channel for future releases?
Check out our Facebook page. Check out our blog on our website Alacarte GP calm and
I guess stay tuned. Thanks, everyone
