SMSSQL V6.2007.0202

1. Fixed Time when storing a tare truck ticket.
2. Finished Backend triggers for Ticket Time calculation of Material, Delivery, Misc and Tax dollars. This allows virtually any pricing at ticket time to be calculated above and beyond SMSSQL.EXE internal routines. These take the highest precedence. Trigger program stubs included in build.
3. Fixed a tabbing problem inherent in Ticket Browser. If there are no Open Tickets, tabbing from the Ticket Tab to Open Tickets and back didn't return to highest ticket but lowest.
4. Updated Import/Export to included Ticket Pix Images and scanned docs. When this item is checked it enforces saving the ticket export file (usually TK.ASC or TK.CSV) in a folder and not on any root drive. This is because all images are unpackaged from the database as JPGs or PDFs (scanned docs) and can be numerous. The export utility will package all the files including the TK.ASC into a zipped folder (named after the export file name i.e. TK.ZIP) and then remove all files from the folder used. This requires Crunch.exe to be in the SMSSQL folder. The import will now import from a zip file. The zip file is unpackaged in the specified folder to a “temp” folder and the user is then prompted to select the actual import file, TK.ASC usually.
5. Updated ticketing to NOT allow Inactive Materials.
6. Updated DBUPDATES.TXT for 5013 – SecureScale for authorization.
7. Added SecureScale™ to Ticket Browser. This button will be enabled if the ScaleLog table is present in the database even if the User has insufficient authority. The review window allows the running of a stock report and viewing of images, pix or video from the log. Customer reports can be added to the ScaleLog.rpt (text) file to be included on the window. The ScaleLog table is only created from ScaleCOM® and auto-installs a trigger for marrying tickets to scale log events. Scale Log events are setup in ScaleCOM® on the SecureScale™ tab. Each Scale can be service by two AX241 Camera Servers allowing a minimum of 2 cameras per server per video feed or as many as the Port server feed will support.

SMSSQL V6.2007.0116

1. Used deep-assign to make temporary records for signature pads. Customer was experiencing a SQL Cast error when trying to do signatures after credit card transaction. We could not reproduce nor has customer since report. In order to attempt a fix I changed the method of moving memory from record to record to use a deep assignment. This assigns all fields in 1 record to another one field at a time instead of byte transfer. The advantage being any field having a bad value will be handled by clarion auto-cast and corrected or initialized.
2. The Quantity field on the Split Ticket window column has been corrected to properly show Long Tons “T” as well as any other user defined weighed materials.
3. Import/Export routines have been updated to carry the MIX/ASM Components and Category related to a material. If no tickets are exported the whole Component table, Category table and ShipTo table are exported if the Material and/or Customer Checkboxes are set.
4. The procedure for Committed Quantity has been updated to gather the info on the backend. This is extremely fast. If it should error out (not likely) I have currently left the older procedure with the progress bar. However that routine has been updated to produce a SQL Filter to gather the data and is also extremely fast.
5. Changed “VendorID” to “HaulerID” on truck browser. The “Formats.fdb” file may have to be deleted to see this change. The columns were not double line labeled for “Related” as to a future potential to put a data filter tab on the browser which has difficulty with that.
6. Window positioning and sizes are now saved in \%windows%\smssqlw.ini. This is done so any user INI settings such as printers can be preserved in case the Window settings INI file needs to be deleted.
7. A new “Auto Assign Number” button feature has been added to Customer Orders window.
8. Turned on the “End of Day” menu item. This can be controlled by PW and authority as all others. This will call the Billing Interface as setup in Company Master. This is for future processing to the target accounting system for Hauler fees, Royalty, and possible Payroll.

SMSSQL V6.2006.1229a

Fixed Check Committed Quantity for Material ID's greater than 8 chars. In length.

SMSSQL V6.2006.1229

Corrected Update Component Material Description

SMSSQL V6.2006.1225

1. Changed the SmallestUnit to SmallestUnitN where n = 1 to 9. This allows smallest units for each scale to be different. This can be setup in the Parameters of SYSTEM.INI as usual or in the Users SMSSQL.INI file.
2. Added Standardized CalculateTicketDetail and SetPricing procedures and removed all multible coding of this from Import, Regular Ticket, and Splits.
3. Added a Select Material button to the Order Rate Browser so Materials can be selected in a list fashion with checkboxes to load an order with materials faster for Order Entry applications. The Quantity field on the Rates browser can now be updated on the Browser window by double clicking the quantity field in the Browse window.
4. Added new feature to Price list where an SQL statement can be set in the ZZPRICE notes to be used to select the price sheet for a customer. This allows for more complex Price sheet order numbers to be established than 1-99. This can be used to accommodate very complex pricing mechanism.

SMSSQL V6.2006.1201

1. Fixed Import UDFs when not in same order as originally defined. This can be caused by changing UDF Field numbers to reorder for different tabs.
2. Fixed Company Master ScaleCOM tab when set to “FILE”. It would forget on return to screen and show DDE/TCP Fields.
3. Fixed Ticket Split ticket Direction button to be enabled when ScaleCOM turned off.
4. Added Invoice # to Split Screen so both Check # and Invoice # show. This is now necessary for AP Paid tickets.
5. Updated call to Custom programs from menu to pass the database number.

SMSSQL V6.2006.1101

1. Split Ticketing window reworked for touch screens.
   
2. Added warning to user if entering 2 or more weighed materials for a tare truck with no split weight code. This will be allowed at this point with the warning but no weight will be assigned to material 2 or more. This is to prevent mixing weigh in/out loads and tare loads. This would be a violation of weighing laws.
   
3. Fixed - Import not working for UDF fields having more than 30 characters.
4. Added Window pop-up for signature area so user can see an enlarged version. This was done using a new window with no save or print capabilities for security reasons.
   
5. Fixed endless loop when emailing a ticket. This was caused by NOT sending a screen AVI at the same time.
   
6. Fixed problem when a UDF length is increased but doesn't allow user to enter data in length beyond first value when field created.
   
7. Changed “Use Split Ticket” checkbox text to “Use Split/Touchscreen ticket” and enabled this all times. Touchscreen/Split Ticket window will only allow one material if Split option is not enabled.
   
8. Reversed “tool-tips” for the Next/Previous buttons on ticket screens.

NOTE: Other minor items as reported to me were fixed over the month of October since the 10-05 release.

SMSSQL V6.2006.1005

1. Added a new report “Post Invoicing” to build menu and authority menu.

2. Fixed Dispatch UDF handling that was causing UDF's to remember old data.

3. Updated UDF Maintenance to allow field numbers larger than 1000.

4. Added “read only” and “hidden” attributes to the UDF maintenance screen.

5. Fixed Material Insert when price sheets are online. If done from ticketing it caused an error.

6. Updated ticketing to separate UDF's onto separate tabs based on field number. Grouping is by thousands: 0-999 on first tab, 1000-1999 on second, etc. While there is no actual limit to tabs, screen real-estate does need to be considered. The ticket screen has been re-worked to allow up to 4 tabs. The tab name can be set by a Parameter UDFTab=<UserLabel>, six characters maximum. UDFTab2 for second tab, etc… UDFTabAuth can be set to any string (e.g. SXZ) to set authority levels approved to use the tab. UDFTabAuth2 for second, etc… These settings are in System.ini.

SMSSQL V6.2006.0925

1. Added a button on Help/About window to check for SMSSQL Updates on www.creativeinfosys.com

2. Added “CSV” to File drop list type in Import Tickets.

3. Corrected pricing to use the Date entered in SQL Select logic. Updated SQL logic to true MS-SQL for speed.

4. Corrected Tax Usage Dbase file ID field lengths, changed from 8 to 15.

5. Added Customer Status and Pricing Level to Customer Name on ticketing screens.

6. Added new SMS Menu Authority setting to prohibit/allow users to change tickets marked paid.

SMSSQL V6.2006.0901

1. Added Print button to Truck Update screen. This will run the Crystal Interface and the report “Truck.rpt”. This report can be used for anything but primarily was added to print truck labels for barcodes.

2. Added a Hauler tab to the Truck/Trailer lookup browser. This allows viewing Trucks in Hauler order. There is an incremental locator.

3. Added “Overwrite existing record” switches for each table in the import utility.

4. Added a warning when importing and any switch is set. These switches allow the user to determine if records existing in the database are overwritten by matching records in the import file. For instance, if customer id “ABC” is in the database and customer id “ABC” is in the import file, than the data for customer “ABC” in the import file will overwrite the record in the database. NOTE: For any records with accumulators (tons, dollars YTD, etc) the accumulators are preserved from the original records in the database.

5. Added Authority checking for Customer Status.

6. Added warning when trying to Dispatch tickets for customers on hold.

7. Added warning when trying to Dispatch and Location is required but not in the Order.

8. Disable Credit Card button on split ticket outbound if a new material is entered.

9. Check if split ticket has a Credit Card approval number when the user hits the insert button to add another material. If approved, then insert is not allowed.

10. Added Mailing Label checkbox to Customer List. Created new SMR001L (Avery 5160 Labels).

SMSSQL V6.2006.0720

1. Added Default Material – there can only be one. This is used if no other Database relationship exists.

2. Added Default Location – there can only be one. This is used if no other Database relationship exists.

3. Both assignments are held in the user INI (\windows\smssql.ini) thus each user can have their own defaults.

4. Added Data filters to Pricing and Ticket browsers. Pricing will now price according to what has been filtered or if no filter applies, what is in the browse box.

5. Added PgDn and PgUp buttons to Update Ticket Screens.

6. Added Change Ticket Quantity to Update Ticket and Update Split Ticket Detail. Updated Database with new Authority setting to change the quantity

7. Added Authority check to Split Ticket Window Browse box for pricing. Pricing will not show unless user has the authority.

SMSSQL V6.2006.0612

1. Updated Ticket Browser when Split Ticket option is on to look first for the Users preference as to the setting “Split Ticket” switch and if not defined then looks in the SYSTEM.INI Parameters section for the setting. This allows a system wide setting of the preference which users can override. If split ticketing option not on, this setting is hidden.

2. Corrected Import to be able to continue the Import process when duplicate tickets are in the import file.

SMSSQL V6.2006.0525

1. Fixed UDF Data display length, would not display greater than 30 characters. Reset data between tickets.

2. Changed Custom Programs when called from menu to pass the User ID so the Called program can look up the operator record fields.

SMSSQL 6.2006.0428

1. Updated Truck, Customer, Material, Ticket and Pricing browsers to remember a users Tab selection.

2. Added a “Design” button on all Report Parameter windows. This will run the Crystal Designer Design runtime allowing users to modify reports. Reports if modified are automatically saved in the Custom folder, preserving the shipped original. Future revision will add an Authority function to enable/disable based on users SMS authority group. This feature will only work with this build forward as the Designer Design runtime was not included in prior builds.

3. Added new feature for Dispatching ticket from Customer Orders.

4. Added switch in Printer Setup to Prompt for Printer Selection before each print job. This will allow users to change printer settings “on-the-fly” prior to any print job.

DISPATCH Tickets – For reminder purposes, there are four modes:

– Single Weighment Trucks produce a Final ticket and test UDF's if required.

– Trucks with Tares produce an In-Process ticket with the Tare.

– Trucks with no tare (on file or not) produce an In-Process ticket with no weights. Follows business rules for Truck not on file allowed.

– Dispatching with no Truck, uses the Auto-Number feature and sets the Truck ID equal to the Ticket Number.

Dispatch tickets can be made with no materials in the list. They can be entered at ticket weighment time.

Location is defaulted to Order Location.

SMSSQL 6.2006.0316

1. Added a new tab to the Pricing Browser for “ByNumber”.

2. Added to the existing Customer Tab and the new Number tab incremental locators.

3. Added Direction Button (Flat) to Ticketing screens. This allows a user to reverse the tickets direction flow of material. Primarily used for those tracking inventory in SMSSQL and do NOT want to code their material directions as UNKNOWN. This feature is controlled by a new Security function “Change Ticket Direction”. The button is not active after the ticket has been invoiced.

SMSSQL 6.2006.0217

1. DBUpdates – added Authority items for “Change Ticket Date” and Change Ticket Number” to the Authority Menu File.

SMSSQL 6.2006.0127

1. Fixed User Defined Conversions when Inserting/Changing a record. The SQL Data def's and Clarion's were not coded in agreement.

2. Added “Show All Materials” switch to Material Browser and changed Browser to NOT show all materials by default.

3. Added Customer Name to Ticket Browser.

4. Ticketing – Changed screen dollars area to show Cash Customers total in Green. Turned on Credit Card button (if option installed) for Outbound tickets for Cash Customers. Allow ticket stored with zero Gross/Tare/Net if the Material is NOT a weighed item.