ERP Scheduler: CFS Orders Not Transfering to ERP

Before you begin, connect to the SQL server on Client machine.

Orders not coming from CFS to ERP

Assuming the ERP scheduler is running we can check CFS for pending batches.

Pre-Requisites

1. Make sure you have login privileges to the SQL server and SQL. (Refer to the Client connection page for this information.)

Step-by-Step Guide

1. If we look in the ERP_Prod_Ext database table ImportExportJob we can find Shipping Detail Updates. This is the process for updating ERP customer orders with data from CFS.
   
   

   Open

   

   
   The commands run by the scheduler are located in the ERP_Prod_Ext database table ImportExportStep. By using the idImportExportJob value 4 from above we can query the table and see the commands used to bring data back to ERP from CFS.

2. The first command (based on CommandOrder) is a select to get the next BatchNumber. I copied the SourceCommand value and pasted it into the query panel to see the full command.
   
   

   Open

   

   
   Reviewing the command above you can see that it is querying the INTERFACES database table BATCH. It is looking for ERP and Shipping with a Processed value of ‘’.

3. Next we will need the password for the ComputerWay database. To get this we look in the ERP_Prod database table ImportExportConnections.
   Below you will see the password for ComputerWay is myPassword
   .

4. To Run the command, connect to the Country Ribbon SQL server.
   They should have QTODBC on the desktop. This is how we can run commands on the CFS database.
   
   
   

5. When you load the QTODBC you will see this next screen.Click on the Machine Data Source tab.

6. Next click on the interfaces Data Source Name and then click OK.

7. You will need to enter Password from above.

8. You can now see the INTERFACES database and it’s tables.

   Copy and paste the SELECT command we got from the ERP_Prod_Ext database table ImportExportStep.

   This command is looking for the next available batch. Click on the right arrow to run the command and see the results down below.

   You can see that currently there is no next batch available.
   

9. We can easily modify this command to remove restriction for Processed = ‘’ and add a date filter to get today’s orders. As you can see all orders are Processed Yes. Processed No orders will not be picked up by ERP Scheduler. A regular update command can be used to set the Processed value to ‘’ (not NULL).