Automate manual inventory reconciliation process for GSA
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.bash_profile
.gitignore
adjust5_30.py
boh.py
readme.md

readme.md

Balance on Hand Script

The purpose of this script is to compare two CSVs, "master" and "copy" which represent inventory manifests from warehouse and SalesForce record. Script serves to easily and quickly identify differences greater than or equal to 500 items.

  • copy refers to the cmls available report which can be downloaded from SalesForce.
  • master refers to the boh report which can be downloaded from the GPO RADS reporting system.

Requirements

  • Python 3.6 or higher (available through the GSA software catalog).
  • csv standard Python library.
  • Ability to download or clone this repository from GitHub.

Pro tips

  • make sure the item numbers in master include leading zeros (0) on projects created in FY16 and later.
  • manually remove the first two rows in master as their presence is not required and throws the execution of the script.

Usage

Creative Commons License
This project is licensed under a Creative Commons Attribution 4.0 International License. This idea is of my own design and fabrication. It is provided free of charge for use and modification. It is not officially supported by me or anyone else.