Search options (Page 1 of 2)

Thanks, my PHP 5.6.3 should be fine so I'll try it in my localhost on my PC.
I was a little concerned that  after moving it from the Just Host server to my localhost the passwords might not work or it wouldn't find things in the place it expected them.
Jonathan

I meant when when I click "place invoice". If it takes too long to respond, it doesn't move on to the next page, and sometimes it has placed the invoice and sometimes not. If I continue it accuses me of opening the document twice.
If I change a date box, or customer name box, or just click "next" and my website takes more than a few seconds to respond I get the orange triangle and !, so I cant get to "next".

Thanks, that is what I thought.

I've solved it. More files were lost, I don't know how, so a full restore of an older back up has cured it.

It just shows the value of keeping backups.

Sorry to have bothered you.

jonathan

Janusz and Joe,

Thanks, I've tried it with customer payments, and supplier payments and not a foreign exchange gain in sight.

Jonathan

Home currency GBP,  customer currency EUR, exchange rate 0.8 fixed, vat 20%.

Take a sale of 120 euro, = £96. Payment of 120 euro = £96. (no exchange gain)

Invoice ...... 100 EUR + 20EURvat = 120 euro in all. This is shown on the invoice correctly.

G/L  4000     Sales                                                 80.00    
       1100      Debtors Control Account           96.00        
       2200      VAT (20%)                                         16.00    
                          Total                                 96.00        96.00    
This is correct, in GBP.
The G/L for Delivery is also correct , and in GBP

Customer payment  = 120 EUR      96 GBP

G/L   1200      Bank Current Account            96.00        
         1100     Debtors Control Account                          96.00    
         1100     Debtors Control Account             24.00                 Sales Invoice 5
         4920      Foreign Exchange Gain                          24.00     Sales Invoice 5
                                    Total                         120.00      120.00    

Here £120 has come out of the Debtors account, £96 to the Bank, and £24 to Exchange gain.  (120 was the Euro amount paid in)

Summary:
Invoice         £96  ... 120 euro
payment       £96  ... 120 euro
Allocation    £120 ...  150 euro

The final result is £24 Foreign exchange gain, and £24 deficit in the Debtors control account, where both should be nill.
The payment has allocated £120, not £96.

My mistake, NOT SOLVED

The problem is half way to being solved.

A payment now results in the custommer's balance ( in pounds, our currency ) being credited with the euro figure, unconverted. This is not as bad as it was, ie converted in the wrong direction.

So now the sums in the foreign exchange gain are half what they were, but should be zero.

Jonathan

Janus,

If the foreign customer payment is not related to in invoice the customer balance increases by an amount as if  the exchange rate is applied the wrong way round. There are no foreign exchange gains or losses.

When a direct invoice, or an order- dispatch-invoice is entered there are no foreign exchange entries.

When a payment is made, directly for an invoice, or by allocating from the customer balance (which is artificially high) then the foreign exchange entries appear. They are almost twice the difference between the euro sum and the Pound equivalent.

All the above is done with no change in rate between the actions, and no bank charges.

I wondered if the wrong value was being sent from the payment form, but the problem is still there when the allocate payment form is used.

Hope this helps

Jonathan

I think I have worked it out.

The order FA leads me to make entries:-
1 Order
2 Receive Goods
3 Invoice this delivery
leads to the increase of stock being calculated at the price of the pre-existing stock, when 'receive goods' is performed.

The subsequent 'Invoice' provides the new costs and the difference from the old costs is the GRN provision. These go into the Stock account so it is the same in the end.

If you can confirm that this is what is happening I can work with it.

However it would be tidier to be able to go from Viewing the order to Invoicing before Receiving goods. This appears not to be an option.
Alternatively the ability to convert an order to a direct Invoice, would also avoid the need for GRN provisions.

Hoping I have it now

Thanks for your patience,

Jonathan

Yes but provision for what. Isn't the purchase price what it says?
I don't want to add anything unless I know how it is calculated.

Front accounting just puts them in - I can't stop it -, and it is not a fixed proportion of the cost.
Is it to do with currency movements perhaps?

Jonathan