1 (edited by t2webby 03/13/2009 08:50:31 pm)

Topic: Wire Transfer With Supplier

I have a situation in the system where some suppliers are payed using wire transfer and put into an account called Inventory in Transit. This is used to hold wires money transfers to suppliers before they actually arrive months down the road.

We use different currency to pay the wire transfer so the exchange variance will come into play.

The account payables is set up as Inventory in Transit instead of Accounts Payable.

So the normal process would be:

1) Payment to Supplier via Wire Transfer eg: $1000 made for Nov 11, 2008 (Inventory in Transit is debited, and bank is credited)

2) Inventory arrives, PO is received for Supplier Feb 03, 2009

3) Supplier Invoice is now then created for Feb 03, 2009

4) Payment made in the past is now allocated to this invoice

Here's the problem. The exchange variance created by allocation of the payment to the invoice adds to the payment GL created back in Nov 11, 2008 and not Feb 03, 2009. This poses a problem since Year end is already closed and accounted for at the end of Jan, 2009. Because of this invoice financial data is changed on the fly for Nov 11th.

Could the exchange variance be its own seperate GL post instead or have its own date when making the variance adjusments? Maybe it should a check to see if the invoice date is less than the payment date, if it is, do as normal and use the payment date, otherwise use the invoice date instead if invoice is created after payment..?


Thanks

Re: Wire Transfer With Supplier

Tu, you have paid (in advance) for the inventory and you have an invoice date at a later time. Even if this is a backward operation, FA handles it correctly. It is always the payment date that creates the variances, so in these cases you should wait with the closure of the fisscal year until these operations are gone. It is just that you can't calculate the variances before you have the supplier invoice.
So in my opinion everything is handled correctly.

/Joe

Re: Wire Transfer With Supplier

Ok, after looking at this, it is possible to put the variance JE on the invoice JE instead of the payment JE if the payment is done before the invoice date. I will try to change that in 2.1.0 RC.

/Joe

Re: Wire Transfer With Supplier

Okay, Tu, you got your wishes. CVS updated. Affected file /includes/banking.inc. If you use release 2.0.7, you can copy the lines inside the function exchange_variances.

/Joe

Re: Wire Transfer With Supplier

Awsome Joe Thanks.