✓ RPA Challenge 14 - Invoice generator

Challenge 14New challenge! Create robot that will generate invoices!

Imagine you have a company and you want to create invoices effectively. You have your set of products (with number, name, and item price) in one Excel file. The Robot will help you to create invoices based just on the product number and amount. And of course, the vendor name.

Input data

  1. Items.xlsx Items.xlsx (9.0 KB)
    image
    This file contains items that your company is selling.
  2. Your company name and address is:
    your nickname LTD
    25 Challengers avenue
    1414 Bottown
  3. Input files for 3 invoices to create: input_invoices.zip (20.4 KB)
    Each input file looks like this:
    image
    1st line: customer name and address (Bill To)
    Following is list of items to bill with item number and quantity.

Steps for robot

Go through each input files:

  1. Fill up form at https://invoice-generator.com/ like this:
    image

:exclamation: Do not miss:

  • Add your custom logo.
  • Bill To - replace ", " with a new line.
  • set Date as Today and Due Date as +2 weeks.
  1. Download the invoice. (example: Invoice # 11.pdf (23.9 KB) )

How to participate :question:

  • Send me your code in PM, upload 3 PDF invoices as a Reply :wink:

First three correct, original solvers earn 3 robopoints, next get 1 robopoint.
There is a leaderboard with your score. Those on top positions will be badged by a special challenger badge :slight_smile: We are preparing also some prizes!

The challenge deadline is 20.6. by the end of the day. You can still submit your projects after the deadline but you cannot earn robopoints. :robot: A new challenge is published every week or 2 weeks so don’t worry if you did not catch this one. Keep in mind, your submitted files may be published after the deadline so others can learn from solutions.

1 Like

Hello Roman, a great challenge thanks!! This is the kind of script we could use in real-life scenario for a company. Loved it!
challenge14.zip (74.1 KB)

2 Likes

Time us up! :mantelpiece_clock:

This time we had @pmontez challenging with his very smart solution using Python and API of the website! Wow! I love your code!
There is just a small issue that you parsed to the invoiced item numbers not their names. :wink: But still, your 3 robopoints are well deserved.

For those who are interested in UiPath solution:

Solution of this Challenge [UiPath]:

1401_solution.zip (258.2 KB)

Keep going!

Even the deadline is over, keep trying and use this to practice your automation skills!
Leaderboard updated here!

Haaa, I didn’t see the Items.xlsx file :smiley:
Code updated here. It is much better now :wink:
challenge14.zip (82.0 KB)

2 Likes

Super cool @pmontez !! I hope you will also take part in the next challenges! :slight_smile: :slight_smile: