多工资单导入gl问题

纵横四海

大家都知道Payroll的数据要传送到GL的gl_interface表，然后才能过帐，由于Payroll模块本身功能的不甚完善，在导入GL的时候没有带group_id标志，导致如果有多payroll的情况下就必须注意，因为会造成数据在总帐中多个日记帐混在一个批中。
解决办法
１．客户化payroll传送至gl的客户化模块。让传送程序在传输的同时设置一下goup_id字段．
２．改变流程。
本文就方法２作说明：
方法２为HR中的传送至总帐后马上进行GL过帐操作。这就需要在多个工资单中进行合理安排避免碰车的发生。

解决方案见第6楼

纵横四海

关于该问题偶已经在Metalink上发Tar了，Oracle官方的说法是Payroll确实不支持在Group_id上设置数据的功能。一下是Oracle的回复，他在回复中说这个在下一个版本中会作为一个功能加以升级。
下面的hu就是ME
11-MAR-05 09:27:23 GMT

.
UPDATE
=======

Hi Hu,
As discussed earlier, creating sources for different payrolls is not within the scope of Oracle Support. Please contact Oracle Consulti
ng / your Implementation Partners for help with the same.

Regarding generating different group ID for individual payrolls, on your behalf I have logged an Enha
ncement Request (ER) 4234358 with Oracle Development. This ER will be reviewed a
nd considered by Development for a future release. It will remain open until it
is either incorporated into the product, or it is deemed not feasible. Progress
on your ER can be monitored via MetaLink by following these steps:

1) Click on Bugs.
2) Enter the bug number in the Bug Number field.
3) Click on Search Bugs.
4) Click on the title of the bug.
5) Click on Bookmark.
6) Monitor periodically by clicking My Headlines then the Bookmarks button.

Consequently, due to the fact that this decision can occur over an extended period of time, this originati
ng SR will be inactivated.

Best Regards,
Ramya.
Oracle Support Services

STATUS
=======
Inactivated -- ER to be Monitored Via MetaLink

纵横四海

该BUG ID为： 4234358 在Oracle 的Metalink上可以查到

Erp100文档

这个metalink关于该问题现在的状态：

主题:  How to set Group IDs for Individual Payrolls During Transfer To GL Process
文档 ID:  注释:302516.1 类型:  HOWTO
上次修订日期:  30-MAR-2005 状态:  MODERATED

The information in this document applies to:
Oracle Payroll - Version: 11.5.9
Information in this document applies to any platform.
Goal
When the Transfer to GL process is run, if a number of payrolls are selected using a consolidation set the same group ID is generated for all payrolls. As a result, there is no way to identify data from individual payrolls while doing a journal import.
How can this be achieved?
Fix
1. Separate sources can be created for each payroll. During the Journal Import, each source can then be handled separately.
2. Separate group IDs are currently not created for individual payrolls during the GL transfer process. This is because the category name and source name are hard-coded as "Payroll".
Enhancement request # 4234358 has been logged for the issue.
References
Bug 4234358 - Separate Group Ids Not Generated When Multiple Payrolls Transferred To Gl
Note 141514.1 - How To Determine Which Tables Are Used For Transfer To GL Process - Costing - Payroll

Erp100文档

来自: Alyn H Griffith 13-4月 -05 10:34
主题: How to link separate journal sources for each Payroll


How to link separate journal sources for each Payroll

Note 302516.1 states that separate sources can be created for each payroll. How do you create the link between a payroll and a journal source?


--------------------------------------------------------------------------------

来自: Oracle, Monica Vijaya Shanker 22-4月 -05 12:48
主题: Re : How to link separate journal sources for each Payroll


Hi Alyn

This is being considered as an Enhancement Request#4234358. Currently this is with the internal team who are checking the feasibility of this functionality and the impact on the code in relation to other modules.

You will have to keep track of the same on metalink and once this is open for customers to vote, please cast your vote in favour of this functionality.

Regards
Monica

纵横四海

公司在实施HRMS时Hand顾问解决了该问题，解决方案如下：

解决办法 ：
        Insert into pay_action_parameters values('TGL_GROUP_ID','Y');

可以满足多工资单同时生成到接口表中，同时过帐到GL中
TGL_GROUP_ID 的生成规则是：传送至总帐 系统生成的 PAYROLL_ACTION_ID 号。

gaoyiming

海哥 我们还没上payroll
下半年上

纵横四海

原帖由 gaoyiming 于 2007-3-4 04:30 发表
海哥 我们还没上payroll
下半年上

你在华友的机会足够好阿，努力阿。

gaoyiming

海哥 这几天都是 加班到凌晨以后
昨天晚上
一个 apps 并发管理其的问题
搞到半夜 凌晨5点才搞定
自己摸索出来的

bhbb2000

中钢集团这两天碰到发工资的问题，好多公司都出现了问题，看看能不能用的上

ylf8785

公司在实施HRMS时Hand顾问解决了该问题，解决方案如下：   
解决办法        Insert into pay_action_parameters values('TGL_GROUP_ID','Y');
可以满足多工资单同时生成到接口表中，同时过帐到GL中
TGL_GROUP_ID 的生成规则是：传送至总帐 系统生成的 PAYROLL_ACTION_ID 号。

海哥，可否就具体操作怎么做讲详细一些么？小弟在此先谢过了。

cindy_ju

　　高手就是不一樣，學習了
　　我還在摸索中，偶像丫