Search options (Page 2 of 6)

It was also written for an older version of FA, so the module doesn't work on the latest framework. Most of the work to upgrade it would be making it consistent with FA, not zen cart (which hasn't changed that much).

I updated it to oscommerce, but didn't get further than basic testing.

Yep that's what I did tclim, but see above, I'm getting the password error:
Fatal error: Uncaught exception 'Exception' with message 'Invalid User ID or Password!!!
for demo@anterp.com
password1
I think

Quick question tclim:
When attempting to run soap-test.php, I'm getting:
XML error parsing WSDL from http://localhost/FA234/api/soap.php?wsdl on line 2: Invalid document end
and a list of debug/error information.

Any ideas what might be wrong?
Thanks
pete

Your question is vast, so youre unlikely to be handheld through this, but as a starting point, check out the code in th 'import multi journal entry' module for examples of how to update the ledger with code. This code does not run anymore in the current version, but the logic and all the calls (except for add bank account transaction) are the same. (I have sent an updated import any transaction module to the site owners which willll hopefully appear to download soon)

Me too.
Looks great tclim...good luck with it!

A suggestion: delete the contents of the js_cache directory under the company/x directory. I think this is OK to do (can the itronics/joe confirm?)

OK guys I've updated this module for FA234 and rewritten the logic to make it a bit clearer and reduce duplicated code. I've also very heavily commented almost all lines in it to make it clearer for people wanting to understand what's going on. It's probably more useful as a guide to FA internals rather than a useful import facility. I've got a strange issue (maybe just a Mac thing) where fgetcsv triggers EOF during the last record which is weird (I had to add an extra blank line to deal with it). When I've sorted it, I'll send it through.

IAS 21 says record the liability in your home ('functional') currency at the start date, then make P&L adjustments based on gain/loss. The original liability account should be untouched. FA handles it this way.

"IAS 21, The Effect of Changes in Foreign Exchange Rates requires recognition of foreign exchange differences as income or expense in the period in which they arise"

Given this, AP and AR are unchanged. Changes are reflected only in the P&L on forex.

Restating the original loan after a currency change is not done according to IAS 21 ie. your option b) is not appropriate if I've worked out the question you're trying to ask.

You have made a profit on forex, so you need to enter a balance day adjustment using a normal journal transaction :

CR a P&L account called something like 'Profit/Loss on Forex' or 'Profit and Loss on Forex Loan USD-EUR' if you need to be more specific.

DR an Asset account usually called something 'Retained profits on Forex' or 'Retained profits on forex loans' ('Retained' is the usual name for profit/losses brought to balance sheet in Australia, I think it's the same in Europe too. You may want to check a public company annual report for the right terminology).

You don't need to touch your original loan account: it's in USD so is unchanged in value in this currency.

This is the standard way of handling P&L on Forex changes - make balance day adjustments for all your revaluations (you may even need to to do this for things like debtors  and A/P, not sure about your jurisdiction).

Hope that helps.

Loans have no affect on profit and loss so this question makes no sense. They are balance sheet items.

For a foreign currency loan you would set up a bank account in that currency.

To set up the loan you makie a journal entry where you:
a) DR the bank account receiving the cash.
b) CR a 'Loan' liabilities account.

As you pay off the loan, you make more journal entries: CR the bank account as the balance decreases and DR the liability loan account to decrease it.