[LemonPOS-general] LemonPOS deposits/Multiple payment sources impasse

[DR <sur...@gm...>]

Hello Ben/Miguel,

First thank you for all the work you've done on Lemon. The work you guys have done has been great. Miguel, thank you for all of the one-on-one help early last year in getting your 0.9.5 release to work for our needs.

I could really use your help again:

We have reached an impasse in using LemonPOS which I haven't been able to resolve on my own. I am hoping that one of you could suggestion a solution or, if its not to involved, add something into LemonPOS. If its a question of time/money, I could definitely convince the owners to donate/pay again if it could be shown the outcome would work. 

LemonPOS in its current form has no option(that I've found) to account for deposits. Our situation is such: We teach classes in which people might leave a deposit through www.bookeo.com. When they arrive to pay, we need to account for this within our LemonPOS report. Prior to this point we got around the issue by having multiple(duplicate) Class items with different prices to account for if deposits are made(ie: A $50 class that someone had made a $20 deposit on would be listed as a separate item for $30). This solution is no longer sufficient for the accountantant, our integration with an ERP or to maintain 'best practices' in our accounting.

What we need in simple terms: 
If we sell 10 classes x $50, we need to produce an end of day that shows a net profit of $500 but part of this needs to account for funds coming from a different source(ie: deposits). In our current system, it doesnt see the deposits because the classes appear to just be sold for a lesser dollar value.

Possible sollutions:
-Multiple payment options! We have been hoping for this for the last year and being able to fund a single transaction with multiple payment sources would solve MANY of the problems we've faced. Is this possible? Can it be done? Is there a reason it hasnt?
-Negative value items: This seems like it could cause other problems but it might also act as a solution.


Full context:
-We are generating custom EoD reports via Select queries -> CSV for import into other systems.


Thank you,
Darius R.