GL中RMB折算为USD问题

amwlq

你看看你的设置>币种>期间汇率  看里面的平均汇率、期末汇率是多少？ 自己算一算。

我之前测试过没有问题的。

dianxing

呵呵 换反了 也不可能差 上千倍呀...

zhanglinjun007

关注!!

lylsy

汇率设置没有反,是OK的,而且同一家公司前面几个期间都没有这个问题.
我在Metalink 上找了些资料,有些公式计算折算结果的,大家看看:

TRANSLATE BALANCES AND AMOUNTS METHODS
There are two translation methods: Amount Balance and Net Activity.
Amount Balance Method (YTD Method) Amount Balance uses the following formulas to calculate initial translated balance, translated period net debit, translated period net credit and, translated end balance.

Initial Translated Debit Balance = Translated Debit Balance of previous period
Initial Translated Credit Balance = Translated Credit Balance of previous period
Period Translated Net Debit = (Initial Functional Debit Balance + Period Functional Net Debit) * Rate - Initial Translated Debit Balance
Period Translated Net Credit = (Initial Functional Credit Balance + Period Functional Net Credit) * Rate - Initial Translated Credit Balance
End Translated Debit Balance = Initial Translated Debit Balance + Period Translated Net Debit
End Translated Credit Balance = Initial Translated Credit Balance + Period Translated Net Credit

Net Activity Method (PTD Method) Net Activity uses the following formulas to calculate initial translated balance, translated period net debit, translated period net credit and, translated end balance.

Initial Translated Debit Balance = End Translated Debit Balance of previous period
Initial Translated Credit Balance = End Translated Credit Balance of previous period
Period Translated Net Debit = Period Functional Net Debit * Rate
Period Translated Net Credit = Period Functional Net Credit * Rate
End Translated Debit Balance = Initial Translated Debit Balance + Period Translated Net Debit
End Translated Credit Balance = Initial Translated Credit Balance + Period Translated Net Credit

lylsy

上面好象说年度累计和期间累计用的是不同的方法计算折算金额,
但我们用的是PTD期间累计,但平时做折算时金额上看来怎么好象用的是YTD年度累计的公式算的.
而且这一次又不是完全按照YTD的公式,因为中间不是有个 * Rate吗,RMB->USD,它还乘以7点多呢!按理也是要除以啊!
我现在都给弄糊涂了,请高手出山指教啊!

lylsy

呼唤高手啊!

lylsy

呼唤版主，呼唤财务高手！
我着急着呢！

天使的眼淚

系統沒有問題。

天使的眼淚

其實科目折算所使用的匯率不一樣。

lylsy

最初由 天使的眼淚 发布
[B]其實科目折算所使用的匯率不一樣。 [/B]

折算所使用的匯率不是期間匯率嗎？