1

(3 replies, posted in Banking and General Ledger)

I forgot to add in compensation

during the compensation we will have some gain or losses in ex change rate (about the transaction not in home currency) and I want this will be recorded automatically during the compensation

Thanks
Eglis

Hi,

I want to record in FA a transaction like this.

We have one partner which is in the same time the supplier of row materials and the client for the finished goods.

We agree that one part of the liability will be compensated with the client requests.

How can I do this in FA?

3

(8 replies, posted in Items and Inventory)

Joe

I have recorded in FA some sales of finished goods, but, the Inventory sales report is empty.

Can you tell me why?

All revenues and requests towards customers based on sales invoices are recorded correctly

4

(8 replies, posted in Items and Inventory)

No, I can not see

I have created a manufacture item which was produced (by some other items) and in the same time was sold.

This report (GRN Valuation report) show me ONLY PURCHASED items and not movement of items produced or consumed for production

Am I correct?

5

(8 replies, posted in Items and Inventory)

hi Joe

another important think to implement in inventory report will be the item card.

in this report we can see the cost of goods flow based on accounting mode (average or FIFO)

what you think?

Thanks
Eglis

Hi Joe

can you tell me how do get a report of Inventory valuation dated at the same date of balance sheet date, for example

I can get from FA different reports of balance sheet dated 31 January 201x, 28 February 201x,........ 31 December 201x.

Now I want to get a report of Inventory valuation which can show me the date of 31 January 201x, 28 February 201x,........ 31 December 201x.

Thanks
Egli

hi joe

I have a question related the cost of ready production,
before to write the question I am explaining you the situation

when I have create the BOM in FA for the Ferro chrome (ready production Fe-Cr) I have put the consumption of raw materials as follows:

1. chrome ore 2.7 ton (per 1 ton of Fe-Cr)
2. metallurgical coke 0.05 ton (per 1 ton of Fe-Cr)
3. etc

I have follow all the steps in FA about the production of 100 ton of Fe-Cr (ready production) and I saw that the consumption of raw material was decreased based on this technological card, but, the consumption given in BOM is how to say a provision of raw materials consumption and not the fact.

the fact will be when we have finished the inventory, let`s say

after the measurement of:
1. chrome ore stock we can say that the consumption for production of 1 ton Fe-Cr (ready production) is not 2.7 ton but 2.8 or 2.5

Question:

1. CAN I DO CHANGES IN BOM ABOUT THE ITEM WHICH ARE PRODUCED?

2. IF YES, WILL BE REFLECTED THIS CHANGES IN GL EVEN THAT THE ITEM PRODUCTION IS PRODUCED AND MAY BE IS SOLD?

3. IF NO, HOW CAN I HANDLE THIS SITUATION ABOUT THE COST OF READY PRODUCTION IN GL?


many thanks, eglis

I agree too, thanks joe

9

(13 replies, posted in Banking and General Ledger)

now let`s go back now to the first question

how FA calculate the profit or losses of receivables and payable account in the REPORTING DATE of balance sheet?

if we do this we can do it only manually in GL? yes joe?

but if I have a list of 100 clients and supplier in foreign currency I will do this manually?

please let`s think how FA can do this job.

10

(13 replies, posted in Banking and General Ledger)

hi joe and p2409,

below I am copying an interpretation of IAS 21 about "Translation of Foreign Currency Transactions"

According to IAS 21, a foreign currency transaction is a transaction that is "denominated in or requires settlement in a foreign currency." Denominated means that the amount to be received or paid is fixed in terms of the number of units of a particular foreign currency, regardless of changes in the exchange rate.

From the viewpoint of a US company, for instance, a foreign currency transaction results when it imports or exports goods or services to a foreign entity or makes a loan involving a foreign entity and agrees to settle the transaction in currency other than the US dollar (the reporting currency of the US company). In these situations, the US company has "crossed currencies" and directly assumes the risk of fluctuating exchange rates of the foreign currency in which the transaction is denominated. This risk may lead to recognition of foreign exchange differences in the income statement of the US company. Note that exchange differences can result only when the foreign currency transactions are denominated in a foreign currency.

When a US company imports or exports goods or services and the transaction is to be settled in US dollars, the US company will incur neither gain nor loss because it bears no risk due to exchange rate fluctuations. The following example illustrates the terminology and procedures applicable to the translation of foreign currency transactions.

Assume that a US company, an exporter, sells merchandise to a customer in Germany on December 1, 2002, for 10,000 DM. Receipt is due on January 31, 2003, and the US company prepares financial statements on December 31, 2002. At the transaction date (December 1, 2002), the spot rate for immediate exchange of foreign currencies indicates that 1 DM is equivalent to $0.50.

To find the US dollar equivalent of this transaction, the foreign currency amount, 10,000 DM, is multiplied by $0.50 to get $5,000. At December 1, 2002, the foreign currency transaction should be recorded by the US company in the following manner: Accounts receivable—Germany 5,000; sales 5,000. The accounts receivable and sales are measured in US dollars at the transaction date using the spot rate at the time of the transaction. While the accounts receivable is measured and reported in US dollars, the receivable is denominated or fixed in DM.

This characteristic may result in foreign exchange differences if the spot rate for DM changes between the transaction date and the date of settlement (January 31, 2003). If financial statements are prepared between the transaction date and the settlement date, all receivables and liabilities that are denominated in a foreign currency (the US dollar) must be restated to reflect the spot rates in existence at the balance sheet date.

Assume that on December 31, 2002, the spot rate for DM is 1 DM = $0.52. This means that the 10,000 DM are now worth $5,200 and that the accounts receivable denominated in DM should be increased by $200. The following journal entry would be recorded as of December 31, 2002:

Accounts receivable—Germany 200
   
Foreign currency exchange difference   200


Note that the sales account, which was credited on the transaction date for $5,000, is not affected by changes in the spot rate. This treatment exemplifies the two-transaction viewpoint (which is a US GAAP expression). In other words, making the sale is the result of an operating decision, while bearing the risk of fluctuating spot rates is the result of a financing decision. Therefore, the amount determined as sales revenue at the transaction date should not be altered because of a financing decision to wait until January 31, 2003, for payment of the account.

The risk of a foreign exchange transaction loss can be avoided either by demanding immediate payment on December 1 or by entering into a forward exchange contract to hedge the exposed asset (accounts receivable). The fact that the US company in the example did not act in either of these two ways is reflected by requiring the recognition of foreign currency exchange differences (transaction gains or losses) in its income statement (reported as financial or non operating items) in the period during which the exchange rates changed.

This treatment has been criticized, however, because both the unrealized gain and/or loss are recognized in the financial statements, a practice that is at variance with traditional GAAP. Furthermore, earnings will fluctuate because of changes in exchange rates and not because of changes in the economic activities of the enterprise.

On the settlement date (January 31, 2003), assume that the spot rate is 1 DM = $0.51. The receipt of 10,000 DM and their conversion into US dollars would be journalized in the following manner:

Foreign currency 5,100
   
Foreign currency transaction loss 100
   
Accounts receivable—Germany   5,200

Cash 5,100
   
Foreign currency   5,100

The net effect of this foreign currency transaction was to receive $5,100 from a sale that was measured originally at $5,000. This realized net foreign currency transaction gain of $100 is reported on two income statements: a $200 gain in 2002 and a $100 loss in 2003. The reporting of the gain in two income statements causes a temporary difference between pretax accounting and taxable income. This results because the transaction gain of $100 is not taxable until 2003, the year the transaction was completed or settled. Accordingly, inter-period tax allocation is required for foreign currency transaction gains or losses.


joe and p2409,
about the loan I have resolved the case based on the above explanation (doing the revaluation in FA, but now I am thinking about the AP and AR)

many thanks eglis

11

(13 replies, posted in Banking and General Ledger)

hi Joe,

I am an accountant, and I want to understand the FA in relation of international accounting standard (IAS)
may be loan is so difficult to understand in comparison of client or supplier account.
please can you explain me how will be reported in the balance sheet the liabilities of supplier expressed in foreign currency? Because when I do the revaluation of currency account in FA, this transaction has no effect in AP or AR in foreign currency but only in bank and cash account.

Please read below the IAS 21 "Effect of Changes in Foreign Exchange Rates"

Reporting at Subsequent Balance Sheet Date:
Foreign currency monetary item* at closing rate
monetary item - *are money held and assets and liabilities to be received or paid in fixed or determinable amounts of money)

Treatment of Exchange Difference
a) On settlement of monetary item
b) or, Reporting the monetary item at rates different from those at which they were initially recorded (my post dated at 04/29/2011 12:14:49 pm)
b,1) Recognize as income or expense in the period in which they arise

thanks in advance

12

(13 replies, posted in Banking and General Ledger)

thanks,

but can you tell me how can I create e new account (not account of supplier, client or bank) in different currency not in home currency?

because based on your explanation

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

my loan currency is in euro (home currency), I do not know how to create the loan account in USD.

regards,

13

(13 replies, posted in Banking and General Ledger)

may be need to reformulate the question

Home currency of the company is EUR

I took a credit at march 01 in amount of 10,000 usd with currency 1 usd = 0.672 euro
reporting in GL as follow
Dr bank in usd 10,000 usd (or 6720 euro)
Cr loan acc 6720 euro (home currency)

based on international standard, need to do the revaluation of this loan in the reporting date of balance sheet which is for example December 31
ex rate at December 31 is 1 usd = 0.600 euro

the loan in the balance sheet will be reported
long terms (or short) liabilities 10,000 usd x 0.6 = 6000 euro
difference from
6720 - 6000 = 720 euro will be reported as profit from ex rate.

please show me the way how to do this in FA.

regards,

14

(13 replies, posted in Banking and General Ledger)

hi Joe,

how FA calculate the profit or losses after the loan payment or in the reporting date of balance sheet?

the loan is not in home currency.


can I create a new account not in home currency (except supplier, client and bank accounts)?

regards,
Eglis

15

(9 replies, posted in Items and Inventory)

Can you do it in this way??? The problem should be in defoult configuration of Item.
at first
when we record a purchase invoice.
Dr internal acc of inventory (xx)
Cr Supplier (xx)
In this registration it is neccasary to not show the qty received in warehouse but the duty towards the supplier.

Second
Transport service invoice
Dr internal acc of inventory (x)
Cr Supplier (x)

Third
Inventory
Dr inv acc 15...  (xxx) -here we can show the qty in warehouse.
Cr internal acc of inventory (xxx)

Thanks & Best regards,
Eglis

16

(7 replies, posted in Items and Inventory)

how many items it is necesary to create in base of different expenses???
Phone, post
counsultaning
legal
financial
publicity
travel ticket
insurance
car insurance
rent
energy
In this way the items should be from 100 to 1000...... It is correct????
thanks

17

(7 replies, posted in Items and Inventory)

No,
How to register in expenses services (purchase invoice) when the company buy a service from third parties?
General ledger account
Expenses 100$ Dr
Acc. Payable 100$ Cr

18

(7 replies, posted in Items and Inventory)

Consulting services?????

19

(7 replies, posted in Items and Inventory)

Hi,
it is possible to register service invoices direct in expenses account???

regards,

20

(9 replies, posted in Items and Inventory)

Can you do it in this way
when I register a purchase invoice  and in the same time I will click in a box the registration should be
GL temporary acc of inventory 15..../AP of supplier
after this
I will register the transportation invoice
GL temporary acc of inventory 15..../AP of supplier
and the third registration should be
adjustment inventory
GL Inventory/temporary acc of inventory 15....

21

(9 replies, posted in Items and Inventory)

My opinion,
at first,
it is not necessary to crate items for services. The users need to have the commodity to register the service expenses directly to account of expenses, and in the same time the software will ask if this service need to be distributed in cost of goods or not.
I think for the administrator of FA this should be very easy.

Hello,
why in this report is not shown the unit of measure for each items of inventory????

thanks in advance

23

(9 replies, posted in Items and Inventory)

Hello,
How it should be increased the cost of goods with shipping, tax etc. ?
for examples:
1- Invoice from supplier A
qty 10 x price 20 = 200 $
GL inventory/AP-Supplier A 200 $
2- Invoice from supplier B
transport of goods (sold by supplier A) in amount 50 $
GL inventory/AP-Supplier B 50 $

Cost of goods in reports should be (200+50)/10 = 25$/per unit

Thanks