GC Sales & Redemption

Is it necessary to use the TN(' ') function with these particular values? Or just safer to do so? I thought it was only necessary to use TN('{PRINTER TAG}') with the Printer Template tags?

I can give a you a Backup, but perhaps to reduce the size, I should delete the Transactions on my Test PC, since it is rather large.

You are right it is not required for [:] values. Iā€™ve added them without thinking :slight_smile:

1 Like

Everything is going good. But I donā€™t like the way the Transactions are taking place.

I donā€™t want the Purchase of a GC to appear as a Sales Transaction at all (even if the Sales account is Debited/Credited); that is, the Sales Account should not be touched. I donā€™t think I care if Receivables Account is used (debited/credited) in the process.

@emre, can you please elaborate on the type of Account setup that you mentioned to track GC Sales separately in itā€™s own account, with its own transactions:

Iā€™m trying to get this to work properly, but Iā€™m running around in circlesā€¦

Iā€™m lost. Accounts, Transaction Types, and Document Types confuse me.

This is the way I hope for it to appear:

Account Type: GC Sale & Redemption
Account: GC Sales ā€¦ to hold a total of GCs sold/purchased
Account: GC Redemptions ā€¦ to hold a total of redeemed GC balances
(or maybe I donā€™t need a GC Redemptions Account)

Account Type: GC Accounts
Account: GC20140605223050300
Account: GC20140606223050100
Account: GC20140607223050500
Account: GC20140607223050200
etc.

When the Sale/Purchase of a GC occurs, say GC20140608223050700:
Debit: GC Sales by 700ā€¦ Balance=700
Credit: GC Redemptions by 700ā€¦ Balance=(700)
Credit: GC20140608223050700 by 700 ā€¦ Balance=(700)
Debit: Cash (or Credit Card or Customer Account) by 700ā€¦ Balance=700
LeaveAlone: Sales Account ā€¦ Balance=0

When a GC is redeemed in part or in full, say GC20140608223050700 is redeemed for 500
Debit: GC Redemptions by 500 ā€¦ Balance=(200)
Debit: GC20140608223050700 by 500ā€¦ Balance=(200)
Credit: Sales Account by 500ā€¦ Balance=500

Iā€™m almost there, but itā€™s backwards, and I donā€™t know whyā€¦
Here Iā€™ve Purchased a GC for 100, but the Debits/Credits for the GC Accounts are backwards, and the Balances are inverted:

I donā€™t know if it helps but if you supply a negative amount to account transactions that will invert amounts. That means it will convert -100 Debit to 100 Credit.

Update Order Action have Account Transaction Type setting. So you can clone GC Sales transaction type form Sales transaction and execute Update Order action whenever a GC order added to ticket.

Someone please tell me, does this look correct? Or should I have some things reversed, or portions of funds being transferred in a different manner? Iā€™m not an Accountant, but it mostly makes sense, though Iā€™m not completely sure.

This was the flow:
Selected a GC500 Product with a value of 500.
Settled the Ticket for the GC500 Product using Cash [500].

ā€¦ then ā€¦

Selected some Other Product with a total value of 200.
Selected the GC500 (GC201406091128809500) to use as Payment.
Settled the Ticket for the Other Product using GC500 [200].

At the end we have:
Sales Account (Other Product) with balance (200).
Cash Account (GC500 Product) with balance 500.
GC Purchases Income Account (income from GC500 Product purchase) with balance 500.
GC Sales Account (GC500 Product) to track GCs sold/purchased with balance (500).
GC500 Account showing Credit 500 (when it was purchased) and Debit 200 (when it was partially redeemed for payment of Other Product, for a total balance (300).

Seems fine to me except GC Purchases account. Why you need that?

Iā€™m not sure why I need it, LOL! I made the Account to avoid the NULL Account seen here:

Further to this, if I had simply made the flow of buying a GC with Cash like this:

Then the GC Sales Balance would be ZERO, so I couldnā€™t track GC Purchases by the Balance.

Maybe this is better terminology shown below:

What do you think?
Maybe when I Redeemed the GC500, I should do one of the following (but not both)ā€¦
GC Income Account should be Credited 200 so itā€™s Balance is 300 ?
ā€¦ or ā€¦
GC Purchases Account should be Debited 200 so itā€™s Balance is (300) ?

How about this? Feel free to tell me if Iā€™m getting out of control :stuck_out_tongue:

Purchase GC500 for 500, and GC1000 for 1000, Settle using partial Cash (700), and partial Credit Card (800):

Purchase Other Product for 600, Settle using total GC500 (500), and partial GC1000 (100):

General Accounts: notice the GC500 is not listed, because it was fully redeemed (balance=0):

Gift Certificates: notice the GC500 is not listed, because it was fully redeemed (balance=0):

My Report:

I think itā€™s time to implement this setup in my Production Server. Any thoughts?

Good luck @QMcKay :smiley:

@QMcKay I liked how you organized accounts. Iā€™d merge GC Purchases and GC Income and track these amounts through debit and credit totals however this is not a rule. Account planning should be done according to business needs. The best solution is how you feel better with. Iā€™m looking forward to your feedbacks about production use. Have fun :slight_smile:

Something is wrong here. I seem to remember this not happening in the past.

Can you tell me how to avoid this? The Gift Certificate Payment Type should not be enabled in this case, since the GC Account (500) does not have enough funds to Pay the Ticket in full (550) ā€¦

If I click Gift Certificate as payment, the GC Account will be overdrawn by 50!

but you could pay 500 with GC and 50 in cash or credit???

G.

I can, but that isnā€™t the issue. The Gift Certificate Payment Type Button should be Disabled at this point, since I Entered 550 into the NUMPAD (or clicked ā€œAllā€) to populate the ā€œChargedā€ field.

The button should only become Enabled when "Charged" field <= GC Account Balance

Ok, I figured out how to prevent it from becoming enabled. I had changed this in my setup, but shouldnā€™t have. The original Tutorial by @JohnS has this set correctly.

The Rules for the GC Account Type must not be Default, instead it must be Credit.

See the difference? The Gift Certificate Payment Type Button is Disabledā€¦

hey all,
Iā€™ve been using V2 for quite a while. Aside from reporting issues its been very stable.
Iā€™m in the process of moving to V4. I have managed to get the GC working as your instructions have been clearā€¦ however I need to get the sale of new GC out of sales and into their own account. Thatā€™s where I got lost.
What and how do I need to set up a GC account that carries the purchase of the gift card when they are purchased as opposed to tendered as payment.

Thanks

This Topic was used to discuss these very things.

Following this, a Tutorial was created that shows everything you need to do in order to keep them out of the Sales Account, and how to use them when used as Tender (Payment Type). You can find it here:

Wowā€¦thanks for the speedy replyā€¦somehow it was working fairly well already aside from this accounting issue. I appreciate the speedy reply.
Iā€™ll let you know if even a non technical dude like me can get it working.
Cheers
Steve