We were using refreshable excel on Dynamics GP to get the following information of employee expenses from GL transactions. I get everything from GL transaction into refreshable excel and from that we do a pivot table to get the details as follows.
Employee number, Employee Name, Date and expenses total of each account type of expenses (specific ones account) but in BC I am getting account and total alone in general ledger entries and when I go employee ledger entries it has employee no. employee name and total of all expenses(total of all expenses together) as one. I tried to build a financial report but again I am not able to get employee name into that. Can any of you shed light on this.
You would need to pull the employee table as well and then link the Employee Ledger Entries and Employee table. The Employee table has multiple name fields. The simplest way to manage this is using a reporting tool and building a data model. You could also just export the employee list to excel and keep it as static data and then just update it only when new employees are added.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
429
Share
Report
All responses (
Answers (
