| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Scenario== | ==Scenario== | ||
* Foreign Customer/Supplier but set In Local Currency in SQL Accounting | * Foreign Customer/Supplier but set In Local Currency in SQL Accounting | ||
* Not buying the Currency Module & force to set Foreign Customer/Supplier | * Not buying the Currency Module & force to set Foreign Customer/Supplier to Local Currency in SQL Accounting | ||
==Solution== | ==Solution== | ||
| Line 7: | Line 7: | ||
* Debit Note | * Debit Note | ||
* Credit Note | * Credit Note | ||
* Journal Voucher | * GL Journal Voucher | ||
* Gain/Loss Account (Set Tax Code to IES(Replace for ES43)) | * Foreign Gain/Loss Account (Set Tax Code to IES (Replace for ES43)) | ||
===Customer Side=== | ===Customer Side=== | ||
* Debit Note(Gain) | * Debit Note(Gain) | ||
:: DR Debtor | :: DR Debtor | ||
:::CR Gain Account | :::CR Foreign Gain Account (IES (Replace for ES43) | ||
* Credit Note(Loss) | * Credit Note(Loss) | ||
:: DR Loss Account | :: DR Foreign Loss Account (IES (Replace for ES43) | ||
:::CR Debtor | :::CR Debtor | ||
===Supplier Side=== | ===Supplier Side=== | ||
====Gain==== | ====Gain==== | ||
* | * Supplier Credit Note | ||
::DR Supplier | ::DR Supplier | ||
:::CR Contra | :::CR Contra | ||
* | * GL Journal Voucher | ||
::DR Contra | ::DR Contra | ||
:::CR Gain Account | :::CR Foreign Gain Account (IES (Replace for ES43) | ||
====Loss==== | ====Loss==== | ||
* | * Supplier Debit Note | ||
::DR Contra | ::DR Contra | ||
:::CR Supplier | :::CR Supplier | ||
* | * GL Journal Voucher | ||
::DR Loss Account | ::DR Foreign Loss Account (IES (Replace for ES43) | ||
:::CR Contra | :::CR Contra | ||
==See also== | |||
* [[GST Bounce Cheque]] | |||
* [[GST Summary Sheet - MY-Detail]] | |||
* Others [[Customisation]] | |||
Latest revision as of 01:31, 13 October 2017
Scenario
- Foreign Customer/Supplier but set In Local Currency in SQL Accounting
- Not buying the Currency Module & force to set Foreign Customer/Supplier to Local Currency in SQL Accounting
Solution
By using Customer/Supplier
- Debit Note
- Credit Note
- GL Journal Voucher
- Foreign Gain/Loss Account (Set Tax Code to IES (Replace for ES43))
Customer Side
- Debit Note(Gain)
- DR Debtor
- CR Foreign Gain Account (IES (Replace for ES43)
- DR Debtor
- Credit Note(Loss)
- DR Foreign Loss Account (IES (Replace for ES43)
- CR Debtor
- DR Foreign Loss Account (IES (Replace for ES43)
Supplier Side
Gain
- Supplier Credit Note
- DR Supplier
- CR Contra
- DR Supplier
- GL Journal Voucher
- DR Contra
- CR Foreign Gain Account (IES (Replace for ES43)
- DR Contra
Loss
- Supplier Debit Note
- DR Contra
- CR Supplier
- DR Contra
- GL Journal Voucher
- DR Foreign Loss Account (IES (Replace for ES43)
- CR Contra
- DR Foreign Loss Account (IES (Replace for ES43)