Dynamics Community Forum Thread Details

GP AA Travel Report breakdown

Hi Everyone,

i'm new in GP reporting and i have to build the below report

below is report fields definition

Field	Level	Source	Calculation
Name	Row	Staff Trx Dimension	N/A
Company	Row	Company from where the row data is being generated	N/A
Division	Row	Division Trx Dimension	N/A
Department	Row	Department Trx Dimension	N/A
Ticket Expenses	Column	Travel Expense Trx Dimension	Acual YTD
Hotel expenses	Column	Travel Expense Trx Dimension	Acual YTD
Transportation	Column	Transportation Trx Dimension: Transportation Abroad	Acual YTD
Phone	Column	Number Trx Dimension: General Telecom Exp	Acual YTD
Personel Catering expenses	Column	Travel Expense Trx Dimension	Acual YTD
Visas Expenses	Column	Travel Expense Trx Dimension	Acual YTD
Invitations & Receptions	Column	Travel Expense Trx Dimension	Acual YTD
Public Relations	Column	Travel Expense Trx Dimension	Acual YTD
TOTAL As of July 2017	Column	Calculated Field	Sum (E:L) for Current Year
YTD AS OF July 2016	Column	Calculated Field	Sum (E:L) for Last Year
Budget FY 2017	Column	YTD Budget
YOY %	Column	Calculated Field	(M7-N7)/N7
% Budget Achieved	Column	Calculated Field	M7/O7

is it possible to build it in Management reporter or i should use ssrs?

also kindly advise how to proceed with any of the above solutions

appreciate your assistance

regards,

Georges

Quick Links

GP AA Travel Report breakdown