PH FIN want to have PR/PO in TWD and SGD but do invoice matching and payment in USD
来源:互联网 发布:电脑广告录音软件 编辑:程序博客网 时间:2024/05/16 08:07
Doc ID: AG0915
Subject:PH FIN want to have PR/PO in TWD and SGD but do invoice matching and payment in USD
Type: Request
Creation Date: 16-Jun-08
Last Revision Date: 29-Jul-08
Status: Closed
Owner: Kevin
Request
We want to know if it’s possible to have PR/PO in TWD and SGD but Oracle invoice matching and payment will be done in USD.
Purpose
PR/PO in TWD and SGD but Oracle invoice matching and payment will be done in USD.
Current Practice
Doing PR/PO stage, we can select what type of Foreign currency we want (TWD, SGD or USD). We can also do invoice matching and payment in system using these currencies. However, actual payment we do is in USD because of the reality that TWD and SGD is not a universal currency. Paying in USD instead of TWD and SGD will result in bank reconciliation for the reason that Oracle we use current foreign exchange rate (the date we will remit the payment to the vendor). (Refer to AG0915_01)
Solutions
1.[17-Jun-08]前进国际的Janet说这个需求在ORACLE EBS系统中可以变通的解决,但是过程有些繁琐。
在ORACLE EBS系统中,TWD 、 SGD与PHP(本位币)有换算关系,USD与PHP有换算关系,但是TWD 、 SGD与USD之间没有直接的换算关系,ORACLE EBS系统也不支持它们之间进行直接的换算。所以在PR/PO中选择用TWD 、 SGD,而在做发票匹配后,付款时选择用USD,两者的金额是不能直接换算的。
处理办法:建立一个过渡银行科目,在PR/PO中选择用TWD 、 SGD,在做发票匹配后,付款时选择用选择用PHP(对应科目为过渡银行科目)。然后过渡银行科目在GL中跟USD折算。
AP中会计分录如下:
Dr:AP(TWD)
Cr:过渡银行科目(PHP)
GL中会计分录如下:
Dr: 过渡银行科目(USD)
Cr:Bank(USD)
换句话说,由于TWD 、 SGD与USD之间没有直接的换算关系,所以在它们之间用PHP来建立换算关系。
2.[24-Jun-08]Jack、Shen、Kevin跟前进国际Janet关于这个问题的讨论,Janet提到两个处理办法:(1)手工立帐时,可以选择币别(如USD),但如果发票的币别与PO的币别不一致的话,则不能匹配。这样处理的影响是导致财务的暂估应付无法核销,使得REPORT[UNINVOICED RECEIPTS REPORT]的数据不准确,失去其作用;(2)在系统中做发票匹配后,付款时选择用不同于Invoice的币别时,则需要增加一个过渡银行科目,设定过渡银行资料,在GL中还需要做一笔分录进行调整处理(处理方法见1)。
3.[30-Jun-08] Kevin了解到KS FIN也有类似的业务流程。跟KS FIN的章玲讨论了这个问题,她们现在的处理方法是(比如用USD付EUR的款):PO、INVOICE、PAYMENT上面的金额都是EUR,
则在AP中的会计分录是 :
Dr:AP(EUR)
Cr: USD 帐户(EUR)
在GL做调整,会计分录如下:
(1)EUR的金额调整为USD金额(先调整到中转帐户)
Dr:USD帐户(EUR)
Cr: 中转帐户(EUR)
(2)EUR的金额调整为USD金额(从中转帐户调整到USD)
Dr:中转帐户(USD)
Cr: USD帐户(USD)
4.[02-Jul-08] Kevin从Divine那里了解了菲律宾财务的详细处理流程, 比如用USD付TWD的款, PO、INVOICE、PAYMENT上面的金额都是TWD,实际付款时使用USD。(Refer to AG0915_02)
她们在GL中做一笔Journal进行调整,但是需要手工计算。
5.[07-Jul-08] 前进国际的Janet提供给我们一个解决方案。(Refer to AG0915_03)
她的方法也需要在GL中做一笔Journal进行调整,也需要手工计算。
6.[07-Jul-08] Kevin针对Janet提供的方案做了一个完整的测试,流程是可行的。(Refer to AG0915_04 AG0915_05 AG0915_06 AG0915_07)
7.[09-Jul-08] Kevin 请昆山财务章玲协助一起把昆山财务用美元支付欧元的应付账款的业务流程整理了出,做成了SOP,并请昆山财务Anee进行了确认。(Refer to AG0915_08 AG0915_09)
8.[11-Jul-08] Kevin 完成了昆山财务现有流程的SOP和前进国际Janet提供的解决方案的SOP。(Refer to AG0915_10 AG0915_11)
9.[11-Jul-08] Jack 发邮件给Divine让她自己做决定采用哪种方案还是沿用她们以前的做法。(Refer to AG0915_12)
10.[14-Jul-08] Kevin 继续发邮件给Divine询问她的决定。(Refer to AG0915_13)
11.[29-Jul-08] Divine 回复说她们将继续使用她们现行的处理办法。(Refer to AG0915_14)- PH FIN want to have PR/PO in TWD and SGD but do invoice matching and payment in USD
- I have a custom view that I want to be able to initialize both in-code and in nib.
- do what you want to do and be youself
- back propagation in practice;GD and SGD
- question2.Would you prefer to have classes during the day and do part-time jobs in the evening or ?
- 51 You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the
- What I Have Done In 2005 And What I Should Do In 2006
- Do you want to know me?----Come in.
- Black and White in Photoshop CS3 and Photoshop Lightroom: Create stunning monochromatic images in Ph
- Advances in Security and Payment Methods for Mobile Commerce
- Advances in Security and Payment Methods for Mobile Commerce
- 81.You are currently located in Singapore and have connected to a remote database in Chicago.
- AR/AP invoices/payment transferred to GL successfully but can't be found in GL module
- User Fields in PR/PO Release Procedure
- What I have and what I want
- 85.View the Exhibit and examine the structure and data in the INVOICE table.
- 107.View the Exhibit and examine the structure and data in the INVOICE table.
- Statistics doesn’t have to be so hard! Resampling in R and SAS
- jsp中response.sendRedirect()的中文参数乱码问题
- 《10PiG.cn开源合辑-(游戏/娱乐)之(Delphi/Kylix)》 (5)
- 程序员要注意保护自己的鼠标手
- 《10PiG.cn开源合辑-(游戏/娱乐)之(Delphi/Kylix)》 (6)
- 128个ajax/javascript框架
- PH FIN want to have PR/PO in TWD and SGD but do invoice matching and payment in USD
- 《10PiG.cn开源合辑-(游戏/娱乐)之(Delphi/Kylix)》 (7)
- Class对象的获取方法
- ultraedit如何自动换行
- QNX下获取系统信息的方法(cpu,内存,进程等等)
- 高效内存管理系列(1)之子分配器
- C#格式化日期时间大全
- 内存管理
- 人家的牙龈都是红色的,而我的都发白,而且刷牙的时候会流血,是怎么回事呢