Share
Report
35I have recently joined a company that uses Microsoft RMS Dynamics and see that a lot of work has to be done to eliminate the manual work being done in the purchase order process.
- The company has 20 retail outlets
- The company ordering for each location is being done manually at the support office using RMS to provide data in Excel format
- There are over 3,000 items re-orderable on the data base
- There are over 200 suppliers (vendors) that receive purchase orders
- 20 purchase orders are raised on all suppliers (Vendors) for the same items and deliveries are made direct to stores ex supplier (vendor)
- 20 invoices are created for each supplier (vendor)
What I would like to do (My vision). I'm hoping there is someone that has been in the same position that can assist me.
I'm used to using IBM AS400 platforms and I know nothing of SQL which I believe is what drives RMS Dynamics.
I would like to be able to
- Have the RMS system calculate store specific order quantities based on an ordering criteria
- Accumulate the 20 store orders into one global order by supplier (Vendor)
- Create a store shipping shipping advice that would be sent to the supplier (vendor) together with the global order allowing the supplier to dispatch the store specific order quantities direct to stores with the global invoice being sent to the accounts department in the support office.
- Have the ability for stores to receive the orders with a shipping notice and having the ability to confirm receipt quantities on screen in stores.
- Confirm store receipts automatically ,update the global purchase order quantities to the point where the purchase order is considered "complete"
- Systemically compare the completed purchase order against an electronic invoice to verify the order cost and quantity ordered, pack size
- Once all purchase order and invoice details match the invoice is approved for payment
*This post is locked for comments
All responses (
Answers (
