Purchase Consolidation for Global Metal Buying Offices

FlexCalc is not restrict to implement by finance department. It can extend to provide services to other departments including sales, marketing, procurement, internal audit & etc.

This application is designed to provide data consolidation to the procurement department when they encounter operational problems associated with multiple procurement offices — different units of measurement, different currencies of purchase contracts and different base currencies of regional offices. In addition, this application is also useful for the internal audit department when they are required to carry out certain audit plans for procurement activities.

Below tutorials are highly correlate to this app:-

• Solving Steep Learning Curve of ETL (1a)
• Recyclying Unstructured Data (1b)
• Foriegn Currency Transaction (1c)
• Dual-base Currency (1d)
• Standardise Unit of Measurement (1e)

Consolidation Method

• Full Consolidation

Data Transformations

• Unit Code Mapping
  
• Exchange Rate Mapping for Local & Group
  
• Calculate Total Quantity
• Calculate Total Transaction Amount with Transaction Currency
• Calculate Total Local Amount with Local Base Currency
• Calculate Total Group Amount with Group Currency

Data Posting Models

• No Posting to Data Building

Reporting

• Output Raw Purchase Consolidation Report

Data Collection Templates

• Any day, any month, any year
  

Also See a Detail List of Accounting Rules

Below, the CalcRule file contains 5 different sheets using the ETL module:-

ETL

• 1.ETL.Ledger
• 2.ETL.MainUnit
• 3.ETL.SubUnit
• 4.ETL.TranExRate
• 5. ETL.ReportExRate

Below every demo data contains 5 different sheets:-

Demo Data Sheet

• 1. Ledger
• 2. MainUnit – It is used to support standardisation of unit of measurement.
• 3. SubUnit – It is used to support standardisation of unit of measurement.
• 4. TranExRate – It is used to support translation from transaction currency to local base currency.
• 5. ReportExRate – It is used to support translation from local base currency to group currency.