In this particular application we connected our applications to Microsoft Dynamics AX for GET and POST data through API. We made a reporting module to send reports twice a day at email addresses provided by the admin. We used Laravel 6.4.
Funai Corporation is the North American sales and marketing company for consumer electronic products manufactured by Funai’s parent company, Funai Corporation has offices in Rutherford, New Jersey and in Torrance.
Funai Electric Co., Ltd., established in 1961, and headquartered in Osaka, Japan, is listed in the Tokyo Securities Exchange First Section (6839). In addition to the consumer electronics brands sold by FUNAI Corporation and other FUNAI sales and marketing companies throughout Asia, Europe, and South America, Funai Electric Company, Ltd. is a major original equipment manufacturer (OEM) and supplier for appliance, consumer electronic, printer and computer peripheral companies.
In this project client was looking to keep track for the items deliveries at warehouses.
- It is an interface that will allow the warehouse staff to scan pallets of incoming product and keep a tally of what is physically received versus what is expected on the shipment.
- The integration points would be a joint effort between Microsoft Dynamics AX and PHP, Setup PHP queries to pull data from AX and populate into MySQL.
- Shipment information is queried from Dynamics AX so the application would be responsible for keeping track (counting down) as items are received, and upon completion, sending back the information to AX where the batch and PO status will be updated as well as a few additional items.
- Running Cron Job to send End Of the Day Report (EOD) for the information for the items which have been posted.
Client wanted us to create a mechanism which could retrieve data from Dynamics AX and save it in MySQL and validate the correct number of pallets/items received at warehouse and posting the data to the AX. Laravel APP was configured for GET & POST requests and sending EOD.
We achieved requested functionality using following steps:
- Active Directory Authentication
- Entry Form / Landing Page
- GET request if container / batch doesn’t exist in MySQL.
- UPC Scan to validate all the pallets received at warehouse.
- POST data to AX after validation completes.
- Delete Container page for deleting not used data.
- Reports page for setting preferences (Emails / SMTP Host)
- CRONJOB for sending End of the Day Report.
To accommodate application requirements, we performed following actions in our APP.
- Created an admin panel to provide nice interface.
- Created form for getting data from AX and display necessary fields.
- Created Action in home controller to query data from AX in GET request.
- Created Action in home controller to post data to AX in POST request.
- Based on successful posting of a data update container / batch and send the record details in EOD
Keywords: Laravel 6, MySQL, Active Directory Authentication, SOAP API’s (Microsoft Dynamics AX)