Skip to content

clemone210/DACHSER-invoice_cost-summary

Folders and files

NameName
Last commit message
Last commit date

Latest commit

bbad29f · Aug 16, 2023

History

10 Commits
Aug 10, 2023
Aug 10, 2023
Aug 16, 2023
Aug 10, 2023
Aug 10, 2023
Aug 11, 2023
Aug 10, 2023

Repository files navigation

DACHSER invoice - cost summary

This repository/code is designed to give a quick overview of the actual cost of a shipment.

The code extracts all costs based on the order number and outputs them in a file with two sheets. Sheet 1 contains all shipments (based on the reference) and lists all corresponding cost service types and their amount. Sheet 2 contains all the shipments (based on the reference) and lists the sum of all the costs, so you have an overview of the total cost of the shipment.

You can place any number of invoice files into the "invoice" directory within this repository and receive one output file.

How to use?

  1. Open Windows Powershell and install git by using the following command:

    winget install git

  2. Clone this repository

    git clone https://github.com/clemone210/DACHSER-invoice_cost-summary.git

  3. Install Python on Windows by using this guide: install_python.md

  4. Install the dependencies

    pip install -r requirements.txt

  5. Download the invoices from eLogistics as a .csv file.

  6. Create a new folder called "invoices" in the repository root directory.

  7. Move all the downloaded invoices into the "invoices" folder.

  8. Run a Powershell shell from the repository folder

    python main.py or python3 main.py

  9. You should now have your shipment data in the repository directory.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages