Cash Receipts Credits against cash accounts 1

[Jcfx]

I asked this question months ago then was distracted and forgot I had asked <blushes> I understand the system a bit better now so I'll try to be more informative.

We have a Customer we just call 'Cash' that is for people that walk in the door and make a purchase but do not want to set up an account. If they pay by Check, we do not have an issue as we will not issue credit until the check clears and we can cancel the original transaction. But if they pay cash or with a credit card we have a slight problem. Please note, all our transactions are integrated from a third party program. So all the sales documents are external. Scenario:

Customer Y comes in and buys a light bulb for .50, he pays cash. Invoice is integrated into GP three hours later, and the cash receipt is processed. Cash Customer account now has nothing outstanding. Customer Y returns a day later and returns the light bulb. The third party program issues a credit memo to return the part into inventory and the clerk gives the customer his .50 back. Credit memo is integrated into GP and we now have .50 with nothing to apply it to. Since this is a 'bucket' Customer for COD only sales, its balance should always be 0.

How do other folks handle this?

Julie
CR 9,10 CE10 Sql DB

 

[VictoriaYudin]

How about integrating a return instead of a credit memo into GP? You can tell it the sales amount is .50 and cash amount is .50, which will actually deduct .50 from the checkbook and GL account associated with it and will keep the Cash customer account at a balance of zero. (On a return the cash - or check or credit card - is actually money you give back to the customer.)

Hope that helps.

 

[Jcfx]

I am not familiar with returns as we've never used them.

As more information, inventory, purchasing, sales are all external to great plains.

The third part software issues a credit memo. <well lets say it 'labels' the transaction as a credit memo>

Now it might be possible for me to fool the system in the integration itself to treat credit memos that arrive via AR as a return. Hrm need to find out more about how they work.

Thanks for the info, maybe there is a way I can tweak it

Julie
CR 9,10 CE10 Sql DB

 

[VictoriaYudin]

From your earlier post it sounded like you are importing in Receivables Transactions - is that right? If so, and if you are using one of the GP tools, you should be able to bring in Returns - they are just a different type of transaction.