Has anyone done Groupons with Dynamics GP? We have been for a year now. We use Salespad Solutions for our SOP. The problem we are having is that Groupon codes are marked down; we never receive $50 from Groupon. Yet the deal being run is for a $50 groupon. We want to be able to discount the Groupon, and the order, at the transaction level. What we are doing now is writing down our sales and Groupon A/R at the end of the month when we get reporting from Groupon. Groupon sends an outstanding balance report to us at month end and we write down an account called "Groupon A/R" to sales.
Here's how a transaction works. A customer purchases a "$50" Groupon for "$25" from the Groupon company. The customer then comes to our company with their code and purchases an item that's $50. Their code pays for the item. Then they owe sales tax & freight, which they pay with cash equivalent.
Here is the journal entry in our system:
credit sales - 50.00
debit purch.- 12.00
credit inv. - 12.00
debit groupon a/r - 50.00
The groupon coupon code pymt actually represents only 25% of what we will receive. The customer only paid $25; groupon & us split that 50/50, and then groupon deducts 3% of the funds due to us for credit card fees. So we actually get $11.75. So this groupon a/r grows, overstated, while sales grow overstated during the month. What I would like to happen is have that groupon code "split" 75/25 at the transaction level; 75% of it reduces sales while the 25% goes to the groupon a/r. Then at month end, I reconcile the groupon a/r for the credit card fees, and not touch sales, where the write down is huge.
I have considered a groupon to be a coupon/discount code, not a true gift certificate. Because think about that entry: debit ????, credit liability for the codes, which was $5,000,000 for our first run. And then groupons expire and groupon does not know when someone has used their code. So when someone uses their code, u debit the liability and credit groupon A/R??? So how do you apply payments??
This is our dilemma. What solutions have other GP users used? Please help.
