Every month I need to calculate our dealers' commissions.
In order for a dealer to be commissioned, we need to physically have the contract the customer signed, so before I run the commission tool, I upload the received contracts into my "dealer database/commission tool".
Last month, some contracts were missing from the file I use to upload the received contracts. When I noticed this, I just entered them into the file I have to upload into the DB, and I uploaded the "received contracts" file into the Dealer DB/Commissioning tool" for a second time that month. It did not work, but since this only concerned a few contracts, I didn't bother too much...
Now, this month I uploaded the received contracts again (and also the contracts received since then), but since I uploaded received contracts twice in the same month, the DB only takes contracts from two months ago into account when calculating the commissions, and neglects the ones from the last month.... I'm looking for a way to fix this issue, but no success, so I taught I might ask you guys...