pillai.ganesh
21st May 2017, 14:33
Hey guys,
We are creating cost purchase orders to buy flight tickets for employees. We want to track the expense that we do for each employee. (And would like to fill the employee dimension for such ledger entries)
Currently there is no place in the PO where I can maintain the employee code.
Any idea of how this is handled in Infor LN.
Warm Regards,
Ganesh Ravindran Pillai
bhushanchanda
22nd May 2017, 09:14
Hi Ganesh,
There is a similar thread (http://www.baanboard.com/baanboard/showthread.php?t=69254) which provides an idea to achieve what you are looking for.
finamp
1st June 2017, 09:06
Hi Ganesh,
Please check which process your are following:-
1 - Cost item with normal Item Group - Maintain Employee Dimension mapping in mapping scheme
2 - Cost item with Cost to be specific Item Group - Use Employee Dimension while doing Match & approve process.
I think this will help you to resolve your issue.
pillai.ganesh
8th June 2017, 13:18
Dear All, Thanks for your input.
We were able to meet this business requirement by following the below steps-
1. Dimension 3 is Employee dimension in our system.
2. Purchase Order Type – “COS” was created in the system. The setup was done such that only cost items will be allowed on the PO with this PO Type.
3. Cost Items which were used to book expenses where assigned a separate Item Group.
4. Now that we had a new "Purchase Order Type – COS” and “Cost Items” with appropriate “Item Groups” connected to them; we defined the Mapping Scheme to set the Default Ledger based on the “Purchase Order Type” and “Item Group” Combination. In the session "Mapping Scheme" (tfgld4573m000) we made a ledger mapping set-up for the integration transaction "Purchase Order / General Costs" (IDT = 10001045).
5. Now when user creates a Purchase Order of “Purchase Order Type – COS” and fills one of the newly created items in Purchase Order Line. In Finance tab of session "Purchase Order Lines" (tdpur4101m000); ledger account would have automatically populated based on the mapping scheme and then user will have to select the employee id in dimension 3.
This is how we can track the expenses employee wise on the ledger.
baan_cap
17th June 2017, 17:58
Hi Ganesh,
Thanks for excellent and detailed explanation.It is very helpful. Just a query on step 2 , as below, have you customized to achieve this or is it standard feature.
Many thanks.
Regards.
sasikanth
22nd June 2017, 10:37
This is a Standard Feature of ERP LN.
Hi Ganesh,
Thanks for excellent and detailed explanation.It is very helpful. Just a query on step 2 , as below, have you customized to achieve this or is it standard feature.
Many thanks.
Regards.
TebbyTan
26th June 2017, 08:05
1. Can try to use the Item Group with Cost to be specified, when invoice matching finance can define the expenses with employee dimension.
2. For cost item, system allow to key in the expenses accounts/dimension during PO, can directly allocate the cost during PO entry.