We have an ERP package on an SQL database, we require integration with 3rd party software. The 3rd party software is an online ordering system which needs to interrogate our database to check stock availability and then if the user orders stock from our company then a sales order must be automatically generated on our system. Our inventory uses batch numbers and expiry dates so the sales order must pick first expiring first. Confirmation must be sent to the third party software and an email with the sales order number must be sent to someone inside my company. I will supply API's wherever possible but in some instances it will have to be written directly into SQL.
Requirements: Attention to detail, accuracy and proof of test results in a test environment