FrontAccounting forum — wrong calcution exchange rate

Re: wrong calcution exchange rate

null@example.com (joseray) — Sun, 02 Nov 2008 14:58:16 +0000

thank's joe

finally i am create my own script to input opening stock, but not one by one, i am input all product one time.

Re: wrong calcution exchange rate

null@example.com (joe) — Sat, 01 Nov 2008 16:00:22 +0000

To get it right, you should enter the stock one by one and location by location in Inventory Adjustments. To get the correct average price calculated, you should enter the values/purchase price by item.

When you are ready the GL Inventory ends up with an accumulated amount and the same amout is credited to a consumable account. This account should then be debited for the same amount and the credit post should be put into an equity account (your company owns this stock). You should have an opening balance from your earlier accounting to compare with, otherwise talk to somebody with accountancy knowledge.

There might be other ways of doing this. Please someone advise us then.

/Joe

Re: wrong calcution exchange rate

null@example.com (joseray) — Sat, 01 Nov 2008 13:37:21 +0000

how to input opening stock????

thanks

Re: wrong calcution exchange rate

null@example.com (joseray) — Sat, 01 Nov 2008 13:35:44 +0000

thank's joe...i think your programe very perpect...your programme not wrong but i was wrong..the currency automatic searching from internet for the rate. so i change your script to manual rate

regard

andrian

Re: wrong calcution exchange rate

null@example.com (joe) — Sat, 01 Nov 2008 07:42:05 +0000

Hello,
You should enter the currency rate against the USD. 1 Rupiah = ? USD or 1 / 9800. Due to the small amount 0.0001xxxxx you should probably increase th currency rate decimals in display setup. Then everything is ok.

/Joe

wrong calcution exchange rate

null@example.com (joseray) — Sat, 01 Nov 2008 02:43:50 +0000

hi joe,....

i used exchange rate from rupiah(indonesian currency) to USD, the company currency is USD but customer currency is rupiah, for example

monitor 17" price is $120 for retail price and $100 for wholesale price,
rupiah rate is 9800, so the price for that item is :
$120 * Rp.9800= Rp.1.176.000
or
$100 * Rp.9800= Rp.980.000

but total amount is wrong.

that's

andrian