Accounting and PMC processes
| Project number and name | Description | Successfully automated |
|---|---|---|
| P3- Information collection for report | Extraction of accounting data (invoices, receipts, customer debt, etc.) from SAP into Excel for generating monthly reports for AdN’s group holding | – |
| P4- Monthly record of impairments in SAP (the ERP system where accounting is performed) | Monthly extraction of large and complex Excel files (about 400,000 rows) from invoicing programs, analyzing relevant columns to calculate client impairment amounts, and inputting the corresponding accounting entries into SAP. | – |
| P5 – Email sending with report | Each report’s area and responsible person are verified on the shared drive, and the corresponding XLSX report is sent | – |
| P6 - Registration of SAP document numbers in the iPortal (the document management program) | Daily extraction of an Excel file with invoice data from SAP and iPortal enables comparison. If a match is found, the robot inputs the SAP document number into the corresponding iPortal invoice. This centralizes information in iPortal, eliminating the treasury sector’s need to verify invoice recordings with accounting | Yes |
| P7- Preparation of report information for the business areas | Download the previous month’s report from SAP, copy the data to the total base file, and generate area-specific report outputs | – |
| P8- Insertion of the iPortal hyperlink into SAP | The robot adds a hyperlink to the SAP document that directs users to the PDF invoice in iPortal. This further integrates the accounting program with the document management system, working opposite to P6, and eliminates the need to access two platforms for complementary information | Yes |
| P27- Social Security declarations | One week before the certificate expiration, the robot e-mails the supplier for an update. Upon receipt, it attaches the certificate to the supplier’s folder. It notifies the user, ensuring timely and complete compliance with the requirement to maintain an updated non-debt certificate from Social Security in each supplier’s folder | Yes |
| Project number and name | Description | Successfully automated |
|---|---|---|
| P3- Information collection for report | Extraction of accounting data (invoices, receipts, customer debt, etc.) from SAP into Excel for generating monthly reports for AdN’s group holding | – |
| P4- Monthly record of impairments in SAP (the ERP system where accounting is performed) | Monthly extraction of large and complex Excel files (about 400,000 rows) from invoicing programs, analyzing relevant columns to calculate client impairment amounts, and inputting the corresponding accounting entries into SAP. | – |
| P5 – Email sending with report | Each report’s area and responsible person are verified on the shared drive, and the corresponding XLSX report is sent | – |
| P6 - Registration of SAP document numbers in the iPortal (the document management program) | Daily extraction of an Excel file with invoice data from SAP and iPortal enables comparison. If a match is found, the robot inputs the SAP document number into the corresponding iPortal invoice. This centralizes information in iPortal, eliminating the treasury sector’s need to verify invoice recordings with accounting | Yes |
| P7- Preparation of report information for the business areas | Download the previous month’s report from SAP, copy the data to the total base file, and generate area-specific report outputs | – |
| P8- Insertion of the iPortal hyperlink into SAP | The robot adds a hyperlink to the SAP document that directs users to the PDF invoice in iPortal. This further integrates the accounting program with the document management system, working opposite to P6, and eliminates the need to access two platforms for complementary information | Yes |
| P27- Social Security declarations | One week before the certificate expiration, the robot e-mails the supplier for an update. Upon receipt, it attaches the certificate to the supplier’s folder. It notifies the user, ensuring timely and complete compliance with the requirement to maintain an updated non-debt certificate from Social Security in each supplier’s folder | Yes |
Sharing content requires targeting cookies to be enabled. Please update your cookie preferences to use this feature.