Affiliates problem - payments not showing up

[pram0310]

Hi

I've done a search on this forum and others, feeling totally lost. I've got my affiliate program up and running, the sales and clicks all register fine. When I go to Admin->Affiliates->Payments, none of the payments show up. Start Billing just shows a message saying "Your affiliates have been billed" but no messages are sent out, and nothing shows up in the payment page either.

I'd changed the status of all orders through the affiliate to "delivered".

My affiliates program configurations are:

Paymnet threshold - 1$
Billing time - 0 days
Order min status - 3
Pay affiliates with check - true
Pay affiliates with paypal - true

Language for the admin and site - English

Really desperate, guys, pls help. I've got to get this thing done in a coupla days, and I'm probably going to have to do without the affiliates contrib if nothing turns up here.

Thanks in advance
pram0310

[pram0310]

Replying to my own questions.... The problem seemed to be happening because of the date. I set the affiliate_date in affiliate_sales table in my database to yesterday instead of today, and the billing stuff worked beautifully. Apparently the transaction needs to be at least a day old for the billing to work. So its all hunky dory now.

Hope this helps.