Tracking Return Credits for Customers in
XpertMart

    Most often retailers do not allow merchandise to be returned for cash. They will gladly allow merchandise to be exchanged for other merchandise of the same value. When the customer does not find anything in stock that he or she wished to buy in exchange it is common to issue a return credit that can be used at a future date towards all or part of a purchase.

    While a printed return ticket can serve to assure the customer that he or she has this return credit. It is important for the retailer to have a control of which customers have return credit balances and the amount of return credit they have. This allows the retailer to avoid fraud related to return credits.

    In the Customer Catalog in XpertMart there is a field where we track the amount of the customer's return credit. This is what the field looks like:

                                    Customer Catalog Return Credit Field

    By design this field cannot be directly edited. Only Sales and Return documents can affect the Return Credit Balance. This balance is totally separate from any lay away balance or credit balance.

    To use XpertMart return credit balances you must add to the Payments catalog a register for this payment type. You may call it whatever you wish, but its PAYMENTS_ID must be equal to 8.  You can use the XpertQuery function in the payments catalog to see all the registers in the Payments catalog with their respective IDs. The register entry for Return Credits looks like this:

                Return Credit Payment Register

    Once you have set up the Return Credit (Payments_ID = 8) register then you can begin to use the Return Credit payment type in XpertMart returns and sales. You would use the Return Credit payment type just like any other payment type. This is what it looks like on the payments section of invoicing or return:

                    Return Credit Payments on Invoicing

    Normally the first thing that would happen is a customer would make a return and instead of returning cash or a credit to their credit card you could make the payment type Return Credit on the return. Because XpertMart is going to control which customer has a Return Credit Balance, it will not let you print a return with a Return Credit payment type unless the return shows a customer. It would display this message instead:

                                                No Customer For Return Credit

    Once the return is printed the amount of payment you entered as Return Credit will be added to the specified customer's Return Credit Balance.

    The next thing that would happen at some point is that this customer would return to purchase something and want to use some or all of his or her Return Credit Balance to pay for this new purchase. Just as on the return, in invoicing you can use the Return Credit payment type to pay for all or part of the amount of the new invoice.

    Just as in returns if you try printing an invoice with some amount shown as Return Credit payment amount, XpertMart will give you a warning message if there is no customer specified and will not let you to proceed to print the invoice until you specify whcih customer the Return Credit refers to.

    Finally before allowing you to print an invoice with a Return Credit payment amount XpertMart checks to see that the amount of Return Credit that is shown as payment is not larger than the Return Credit Balance for the customer to whom the invoice is being made. If the amount of Return Credit payment is larger than the Return Credit Balance for this customer, then the following message is displayed:

 Insuficient Return Credit Balance

    XpertMart will not allow you to proceed to print this invoice until the Return Credit payment amount is less than or equal to the Return Credit Balance. You can combine cash or other payment types with the Return Credit payment type in order to complete the payment for the invoice.

    When the Return Credit payment amount is less than or equal to the Return Credit Balance for the customer, then XpertMart allows you to proceed and print the invoice. The amount of Return Credit payment type of the invoice is subtracted from the Return Credit Balance for this customer.

    The Return Credit payments will show up on your POS payment type reports.

    We also supply you with reports that can show customers with their Return Credit Balance and any returns or invoices that were paid via Return Credit payments. And of course all of this data can be used in reports designed to your wishes using XpertReports.