Order Import Error: Creation Date/Time

Overview

This article covers how to fix an order after it fails with the error that “the Creation Date is required”. The below steps covers both types of databases for Sage 100 customers. If you do not have experience with Sage we recommend reaching out to your Sage Var before making these changes as they do bypass the Sage 100 Business Objects.

After following the below steps please feel free to contact CIMcloud’s customer service team if you have any questions.

Instructions

Providex Database

1. Inside of Sage go to Modules -> Library Master -> Utilities -> Data File Display and Maintenance
2. In the search box at the top put in “SO_SalesOrderHeader” and click Tab
3. In the search box at the bottom of the screen put in the order number and click Tab
   • This should bring up the order with a lot of blank fields
4. Click “Edit”
5. Scroll down the list of fields and select “DateCreated”
   • It is probably somewhere around 90-100
6. Put in the current date and click Save
   • The dates are formatted YYYYMMDD
7. Repeat 5 and 6 for the “TimeCreated” field
   • The format for this field is military time for hours and decimal time ex: 15.50 (3:30 pm)
8. After that you can close out of Data File Display and Maintenance and re-export the order.
   • If you try to re-export the order before closing out it will fail to export since you have the order open

SQL Database (Sage 100 Premium)

Note: I only recommend doing this if you have SQL experience. Please consult your database manager before making direct changes to the database.

1. Open up SQL Server Management Studio and connect to the Sage “MAS_<company code>” database
2. Run the below SQL statement to make sure that the order exists in the database
   • Select * from SO_SalesOrderHeader where SalesOrderNo = ‘<insert sales order number>’
     • If you find the order then continue otherwise you have connected to the wrong database
3. Run the below SQL statement to update the DateCreated and TimeCreated fields
   • Update SO_SalesOrderHeader set DateCreated = ‘MM/DD/YYYY’, TimeCreated = ‘<time in decimal>’ where SalesOrderNo = ‘<insert sales order number>’
     • This should update 1 record in the database
4. Run the SQL statement from step 2 again and verify those fields are populated correctly
5. Go to Webdriver and re-export the order and it should import