Cadorath

There are 2 ways to Regenerate the Day End report, depending on which day needs to be re-run. If needed for the previous day, follow Process 1. If for an...

Identify the name of the customer in the crm_customer table name column Use the following SQL Statement to add the taxes to the customer automatically by ...

Delete the record from the erp_repairorder_items table by inputting the repair order # and work order # to be removed The DELETE statement is used to re...

To Active (Status 1) UPDATE rpi_procedures -- Set status to 1 (Active) SET id_status = 1 WHERE id_task = {task number} AND number = {RPI Number}; To...

If a workorder is determined to be a warranty, it is flagged when received and the id_options field in the erp_workorder table is updated from "0"...

Update the JRXML file for the report needing to be updated. Copy file to server using scp (/var/www/apps/aero/ywg/templates/pdf/jasper) Navigate to direc...

Steps Collect the Part Numbers and Prices from the supplied PDF or Excel files Combine both M250 and RR300 Part numbers and prices into one list Filter...

Loop through all databases to copy from Prod to Dev File: /usr/local/bin/sync_winnipeg.sh Create Script:  sudo nano /usr/local/bin/sync_winnipeg.sh #...