Job description
Writing a program that will read data from two sources (ERP Optima and WMS EasyStorage), compare (show in a table) and export to CSV/XLSX
Negotiable
Writing a program that will read data from two sources (ERP Optima and WMS EasyStorage), compare (show in a table) and export to CSV/XLSX
A simple program that shows in a table the inventory of products in ERP Optima and WMS EasyStorage (at this stage we do not worry about the documents, unrealized, reservations, etc.). Details: You will need to load states from Optima (products+resources table) into the table. The program will run in a local network, so access to SQL server is not a problem. The next step is to load the inventory from WMS - available through the API, https://demo.easystorage.io/swagger/index.html - the getproducts method (to retrieve records) and the getinventorysummaryperwarehouse method (to retrieve quantities). Products between optima and WMS are mapped by SKU/Code and display a table of 6 columns: SKU, barcode, name, state from Optima, state from WMS, difference between states. Columns must be filtered (SKU, barcode, name) and sorted (quantities). In addition, a button that saves the data in a CSV or XLSX file. Arguments (name of the warehouse in optima, data for connection to optima and WMS, id of the owner and id of the WMS warehouse are given in the configuration file). Programming language any, but the program compiled to run on windows 11.
Add your offer or ask the client for more details