Multi-currency per account

abdurrehman82 · May 27, 2015, 2:02pm

Hi

When multi-currency per account issue

github.com/frappe/erpnext

Multi-currency per account

opened 07:45AM - 26 Oct 13 UTC

closed 01:14PM - 16 Sep 15 UTC

rmehta

- [x] Add Account Currency to Account & Party - [x] Add Debit (in Alt Currency) …and Credit (in Alt Currency) to GL Entry - [x] [validation] Do not allow currency to change if any transaction has been made for both Party and Account - [x] Currency input on creation of account from Chart of Accounts - [x] In GL Entry posting, also post in alternate currency if party and account currencies are alt and match - [x] Currency in Party and Account (Debtors) must match - [x] In Journal Entry, on selection of account, select currency for the row. - [x] In Journal Entry, Sales Invoice, Purchase Invoice post to default currency (DC) (based on exchange rate) and Account Currency (AC) - [x] Fetch Exchange rate in Journal Entry based on average exchange_rate in case of inter-bank transfer, otherwise fetch current exchange rate - [x] Currency in transactions must be either in party currency or company currency - [x] All selected accounts in a transaction must be with transaction currency or in company currency - [x] Invoice outstanding, advance amount in party account currency - [x] Invoice paid amount and write off amount in both company currency and transaction currency - [x] Patch for Outstanding, Paid, advance, write-off amount - [x] Payment Tool in party currency - [x] Accounting Currency in Customer / Supplier, patch for existing records - [x] Force to mention Receivable / Payable account in Customer/Supplier, if party account currency is different from company currency - [x] Show Receivable / Payable accounts, in accounting currency for customer/supplier and validate - [x] Update "Advance Paid" in Order, based on party account currency, validate with grand total based on currency - [x] Test Case - [x] Patch - Set `currency` in Account, GL Entry, Journal Entry - Update `base_paid_amount`, `base_write_off_amount`, `party_account_currency` value in sales / purchase invoice - Update Exchange Rate, debit/credit in account currency in Journal Entry and GL Entry - Set Accounting Currency for party - Set party account if default currency of party other than company's default currency - [x] Reports: Show Balance in account currency if filtered by account and account currency is different from company currency - General Ledger - Receivable - Payable - [ ] Reports: Show all balances in company currency based on exchange rate as on filter - Trial Balance - Balance Sheet - P&L - Financial Analytics - [x] Update manual - [x] Add multi currency data in erpnext-demo - [x] Set currency and exchange rate based on customer in Quotation while making from Opportunity - [x] Set currency and exchange rate based on Supplier in Supplier Quotation / Purchase Order while making from Material Request #### Inter-currency Conversion <table> <thead> <tr><td>Account</td><td>Debit</td><td>Credit</td><td>Debit (Alt)</td><td>Credit (Alt)</td></tr> </thead> <tbody> <tr><td>Paypal (USD)</td><td></td><td>6000</td><td></td><td>$100</td></tr> <tr><td>Bank (INR)</td><td>6100</td><td></td><td></td><td></td></tr> <tr><td>Exchange Gain / Loss (INR)</td><td></td><td>100</td><td></td><td></td></tr> </tbody> </table> <bountysource-plugin> --- Want to back this issue? **[Place a bounty on it!](https://www.bountysource.com/issues/1046072-multi-currency-per-account?utm_campaign=plugin&utm_content=tracker%2F266088&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F266088&utm_medium=issues&utm_source=github). </bountysource-plugin>

will be added on ver 5 master branch.

rmehta · May 28, 2015, 7:34am

Will most likely will be late June / early July.