Icon

Internal Audit of purchases and suppliers

This workflow will help you to perform Internal Audit within your company focusing on Purchasing and Suppliers.

On the one hand we have the Purchasing data and the Suppliers data.

On the other side we have the limits for Purchasing and Suppliers (these data may vary in case our company has to comply with different policies).

We will process the data independently and generate a Data App with two sections:

The first one will allow you to check which departments / group exceed the purchase limits. You will be able to browse and download an excel file.

The second one will allow you to check in which suppliers we have overspent money. In this case, besides exporting as an excel file, we will be able to generate an individual report for a selected supplier or a multiple report for all suppliers.

Suppliers Data

Purchases Data

Data Manipulation

Data App


Internal Audit of purchases and suppliers

This workflow will help you to perform Internal Audit within your company focusing on Purchasing and Suppliers.

  1. On the one hand we have the Purchasing data and the Suppliers data.

  2. On the other side we have the limits for Purchasing and Suppliers (these data may vary in case our company has to comply with different policies).

  3. We will process the data independently and generate a Data App with two sections:

    1. The first one will allow you to check which departments / group exceed the purchase limits. You will be able to browse and download an excel file

    2. The second one will allow you to check in which suppliers we have overspent money. In this case, besides exporting as an excel file, we will be able to generate an individual report for a selected supplier or a multiple report for all suppliers

Different aggregationsand calculations
Suppliers
GroupBy andColumn Rename
Manipulation
By ID
Joiner
Different aggregationsand calculations
Aggregations
Purchases Limits
CSV Reader
Purchases
CSV Reader
Suppliers
Excel Reader
Supplier Limits
Excel Reader
Output Data App

Nodes

Extensions

Links