[SL] Only big hurdle I have with SQL-Ledger...

[R P. <arc...@mt...>]

Consider this sequence of buying and selling products purchased in a foreign currency with a credit card.
Using a credit card is becoming the most common method to pay vendors in North America. 
Even the gov't departments that buy products from us use corporate credit cards.


Hopefully someone has a suggestion on how to handle this.

Note: In the follooing example, the credit card exchange rate is calculated by the bank at the end of the business day. This is important to remember.

1) Enter the purchase order
	SL wants to know the exchange rate.... but I can't determine the exchange rate I would be charged until the day is over (when the markets close)
        Solution ?:   Enter the sale order in CDN funds and then alter it to USD tomorrow to reflect the correct exchange rate

2) Shipment arrives
	When using the "ship" or "vendor invoice" functionality to receive the item into inventory, SL wants to know the exchange rate.
	Problem: I can't find this out until the next day. 
	Partial Solution: Don't receive the item into inventory until the next day. This prevents me from selling the items until the day after the shipment arrives.
				This can only be done with an invoice, since you can't manually enter the date when using the "receive" shipment function.
				Which leads to a 2nd problem....
	Problem#2: When I turn the Order into an invoice, SL wants to know TODAY"S exchange rate. even though the invoice is NOT for today's date.
				After all.. you rarely have a copy of the invoice on the same date it was created by your vendor.
				It would be nice if SL only asked for exchange rates when the invoice is posted. NOT before it's even created
				Since I have no way to know what TODAY"S exchange rate is......and i'm forced to enter the exchange rate for today.....
				I enter a fake exhange rate for today, THEN enter the actual invoice date and exchange rate for THAT date and post the invoice.
				I then have to go into the database and delete the fake exchange rate I entered for today.   :P

3) Pay the vendor invoice
	I pay the invoice with a credit card.....wait a day until I know what exchange rate I was charged.....then enter the payment into SL.


Is there a way to handle these invoices in native currency and then just do GL entries to handle the Foreign exchange rate charged when the vendor is paid ?


Regards,
Roy P

P.S.

Not only is this whole process a hassle... 
It would be much nicer if SL calculated COGS when a report was run., not when both a vendor invoice and customer invoice are created.
This would allow you sell items before all this foreign exchange rate was entered. and prevent the dreaded COGS out of order issue we all know about.

Ultimately I'd like to see:
1) Exchange rate to be entered when an vendor invoice is posted, NOT before you even get a chance to enter the invoice's date.
2) Make SL capable of avoiding the whole thing altogether and only handle the PAYMENTS in foreign currency. 
	Of course this would be for those who don't care about foreign exchange gain/loss
3) COGS dynamically calculated when a report is run, NOT when goods are sold.
4) Support for multiple exchange rates (to handle multiple foreign currency transactions done in a single day using multiple methods)