Currency Table

Specifies how you can invoice in foreign currencies, post in foreign currencies, record exchange rate differences, and generate statements in foreign currencies. You can post to a customer or vendor in an unlimited number of currencies. The resulting ledger entries will show the currency of each transaction.

You use this table to link various types of information (such as how you want the program to round invoices for specific currencies and which accounts you want the program to post to for exchange rate gains and losses) to a currency code. You must also set up exchange rates for each currency in the Currency Exchange Rate table.

After you have set up this information, you can enter a default currency code on customer and vendor cards. You can also enter the currency code in currency code fields elsewhere in the program. Then, when you post or set up orders, invoices, credit memos, and so on, the program will use the information represented by the code.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
TDS Rounding Precision Field, Currency Table Income Tax
Excise Rounding Precision Field, Currency Table Excise
TDS Rounding Type Field, Currency Table Income Tax
TCS Rounding Precision Field, Currency Table Income Tax
Excise Rounding Type Field, Currency Table Excise
TCS Rounding Type Field, Currency Table Income Tax
Symbol Field, Currency Table United States Local Functionality
Appln. Rounding Precision Field, Currency Table United Kingdom Local Functionality
Units to NOK Field, Currency Table Norway Local Functionality
Currency Decimal Description Field, Currency Table India Local Functionality
Currency Numeric Description Field, Currency Table India Local Functionality
Vendor Amt. Rcd. Not Invoiced Field, Currency Table General Ledger
Realized G/L Losses Account Field, Currency Table General Ledger
Vendor Ledg. Entries in Filter Field, Currency Table General Ledger
Unit-Amount Decimal Places Field, Currency Table General Ledger
Customer Balance Due Field, Currency Table General Ledger
Realized Losses Acc. Field, Currency Table General Ledger
Global Dimension 1 Filter Field, Currency Table General Ledger
Unit-Amount Rounding Precision Field, Currency Table General Ledger
Bill Groups - Collection Field, Currency Table Spain Local Functionality
Realized G/L Gains Account Field, Currency Table General Ledger
Vendor Balance Field, Currency Table General Ledger
Residual Losses Account Field, Currency Table General Ledger
Customer Filter Field, Currency Table General Ledger
Currency Factor Field, Currency Table General Ledger
Payment Orders Field, Currency Table Spain Local Functionality
Global Dimension 2 Filter Field, Currency Table General Ledger
Bill Groups - Discount Field, Currency Table Spain Local Functionality
Max. VAT Difference Allowed Field, Currency Table General Ledger
Description Field, Currency Table General Ledger
Vendor Balance (LCY) Field, Currency Table General Ledger
Last Date Adjusted Field, Currency Table General Ledger
Realized Gains Acc. Field, Currency Table General Ledger
Customer Outstanding Orders Field, Currency Table General Ledger
Payment Tolerance % Field, Currency Table General Ledger
Invoice Rounding Type Field, Currency Table General Ledger
Cust. Ledg. Entries in Filter Field, Currency Table General Ledger
Vendor Outstanding Orders Field, Currency Table General Ledger
Vendor Balance Due Field, Currency Table General Ledger
Customer Balance (LCY) Field, Currency Table General Ledger
Amount Rounding Precision Field, Currency Table General Ledger
Conv. LCY Rndg. Debit Acc. Field, Currency Table General Ledger
Vendor Filter Field, Currency Table General Ledger
Invoice Rounding Precision Field, Currency Table General Ledger
Code Field, Currency Table General Ledger
Amount Decimal Places Field, Currency Table General Ledger
Appln. Rounding Precision Field, Currency Table General Ledger
Customer Shipped Not Invoiced Field, Currency Table General Ledger
Residual Gains Account Field, Currency Table General Ledger
Customer Balance Field, Currency Table General Ledger
Date Filter Field, Currency Table General Ledger
Unrealized Losses Acc. Field, Currency Table General Ledger
Last Date Modified Field, Currency Table General Ledger
Unrealized Gains Acc. Field, Currency Table General Ledger
EMU Currency Field, Currency Table General Ledger
VAT Rounding Type Field, Currency Table General Ledger
Conv. LCY Rndg. Credit Acc. Field, Currency Table General Ledger
Max. Payment Tolerance Amount Field, Currency Table General Ledger
OIOUBL Currency Code Field, Currency Table Denmark Local Functionality
ISO Currency Code Field, Currency Table Switzerland Local Functionality

See Also

Reference

Currency Exchange Rate
Currencies

Other Resources

Set Up Currencies