470 likes | 649 Views
Demo Show 7. Purchase Data Consolidation Supports data consolidation outside of the finance department Allow standardization of data collected from different branches Supports multiple currencies and multiple branches
E N D
Demo Show 7 • Purchase Data Consolidation • Supports data consolidation outside of the finance department • Allow standardization of data collected from different branches • Supports multiple currencies and multiple branches • Provides different kinds of transactional reports and summary reports • Able to map data sources to 100 columns • Able to consolidate purchase data from different stages • of a purchasing cycle. • This is an auto-run PowerPoint Show • Press Enter to start • Press Pauseto stop/continue • Press Esc to exit
By Business Function Sales/ Marketing Human Resource Purchasing Production Finance Different Types of FESA Apps Retailing By Industrial Sector Hospitability Trading Construction Manufacturing
By Business Function Sales/ Marketing Human Resource Purchasing Production Finance Different Types of FESA Apps Retail Sales Analysis Sales Commission Retailing Group Purchase Analysis By Industrial Sector Hospitability Cash Management Consignment Management Trading Expense Claim Mgnt Project Management Construction Inventory Aging Analysis Productivity Analysis Manufacturing
Sales Department Human Resource Department Purchase Data Consolidation - Overview Executive Info FESA App Finance Department Purchase Department Multiway
Input Processing Output Excel FESA App Flexibility of Processing Excel Report Data Compression Standardization Multiway FionBrick Dashboard SQL
Measure Purchase Cost - CurrentPeriodActual - CurrentYearActual Purchase Item Multi-dimension View of Purchase Data Supplier Responsibility Centre A/C Code = Purchase Type Ledger Accounting Period An example of Query Formula: =fac("a/c(all) pri(12/2009) leg(H07..H09) val(CPA)ana(PI:BAT1)ana(RC:ADMIN)ana(SP:CHO01))") A/C CodeA/C Period Ledger Code Value Type User-defined dimensions