All public logs

Combined display of all available logs of KeystoneIntranet. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 19:34, 17 March 2025 Jquinn talk contribs created page File:CIDRA SETUP.png
• 19:34, 17 March 2025 Jquinn talk contribs uploaded File:CIDRA SETUP.png
• 21:48, 22 January 2025 Pmorey talk contribs created page ISolved Keystone Integration (Created page with "==Overview== GivenHansco has developed an integration between iSolved Payroll and Keystone financials (G/L, C/M and J/C.) This integration makes use of the iSolved API to allow transfer of payroll data directly from iSolved into Keystone transaction batches. Once transferred these batches can be reviewed and/or posted. <i>This integration requires Keystone 4.7.12 or higher.</i> ==Configuration== ===iSolved Information=== The first step in configuring the integration i...")
• 16:26, 30 August 2024 Pmorey talk contribs created page Release Notes for Keystone 4.6.x (Created page with "__TOC__ <p><i>NOTE: Items in '''bold type''' are NEW features.</i></p> ==Build 4.6.6 - 7/11/2024== ===Accounts Receivable Module=== Product Maintenance :Fix Access Violation exception after hitting ENTER when using F4 to search for a product (introduced in 4.6.5.0.) :Fix per-hundred weight ingredient cost calculation on Mix Design tab (introduced in 4.6.2.3.) ===General=== File Maintenance :Fix lookup drop-down to properly lookup key after the BACKSPACE key is pro...")
• 19:33, 27 August 2024 Chanson talk contribs created page File:DeviceServerRemoteConfigA.PNG (File uploaded with MsUpload)
• 19:33, 27 August 2024 Chanson talk contribs uploaded File:DeviceServerRemoteConfigA.PNG (File uploaded with MsUpload)
• 02:32, 4 May 2024 Pmorey talk contribs created page Release Notes for Keystone 4.5.x (Created page with "__TOC__ <p><i>NOTE: Items in '''bold type''' are NEW features.</i></p> ==Build 4.5.6 - 4/3/2024== ===Dispatch Module=== Ticket Maintenance :Fix F4 Search "Ticket Number" option so it searches tickets for all customers. ===Ticketing Module=== Ticket Maintenance :Fix F4 Search "Ticket Number" option so it searches tickets for all customers. ===Accounts Receivable Module=== A/R Inquiry<BR> Cash Posting :Fix to use selected invoice/statement form when printing invoi...")
• 15:34, 27 March 2024 Chanson talk contribs created page QueryGen Case: Add missing item to all Jobs (Created page with "Sometimes you want to add an detail item to all jobs. In this case, we will add the item ENVIRO.01 (adjusted to plant) to all jobs wher it is missing. In the query below we select all jobs and identify which do NOT have a product like ENVIRO. Artjob as d1 represents the detail line that should exist if ENVIRO.XX is in the job detail. Artjob as d0 is used to find a valid plant number on a product. (you can't count on the job header). <pre> select h.session_no,h.trans_...")
• 16:02, 29 February 2024 Pmorey talk contribs created page Do This after updating number of licensed InterBase users (Created page with "After updating the number of IB Licensed Users, do the following on the main Keystone server: #Verify that the ccasib6.exe (app server) and the Keystone REST Server service are shutdown. #Run Notepad AS ADMINISTRATOR. #Open the file <i>C:\ProgramData\GivenHansco\Keystone\Settings\ccwibsv.ini</i> #Remove the single line that begins with: <b>DefPoolMaximumItems</b> #Save the file. #Reboot the server.")
• 16:18, 27 February 2024 Chanson talk contribs created page Microsoft SQL Server Query Features (Created page with "===trim=== ltrim rtrim select trim(address1) from Customer ===concat=== ===replace=== Replace singele quote with 2 single quotes: <code>replace(rtrim(ltrim(NAME)),'''','''''') "DRIVER_NAME",</code> ===left, right=== ===case=== ===iif=== ===windowing functions=== ===rank=== ===derived queries=== Derived queries, fequently seen as a "with" statement... allow for querying queries.")
• 12:29, 19 February 2024 Chanson talk contribs created page Examples by Table (Created page with " *'''ACCT:''' GL Accounts *'''ARTB:''' Aging *'''CCON:''' Contact Connection *'''COMP:''' Company *'''CPRD:''' Customer Prices *'''CTCT:''' Contact *'''CUST:''' Customer Prices *'''EMPL:''' Employee - Sales and Drivers *'''ICAT:''' Item (Product) *'''ICST:''' Component Structure *'''ILOC:''' Product by Location (Similar to Plant) *'''IMST:''' Products *'''IPRC:''' Prices - by Level (Group) *'''LOCN:''' Locations (Similar to Plant) *'''PLNT:''' Plant *'''PRCC:''' Price...")
• 02:04, 16 December 2023 Pmorey talk contribs created page Release Notes for Keystone 4.4.x (Created page with "__TOC__ <p><i>NOTE: Items in '''bold type''' are NEW features.</i></p> ==Build 4.4.3 - 12/12/2023== ===Year-End=== :'''This version includes updates for A/P and Payroll year-end tax filings as well as 2024 payroll tax changes that are currently available. Please check frequently for further updates.''' ===Dispatch Module=== Beginning of Day :Preserve the following tables at the remote site: CCTUSERROLE, CCTEVENT, CCTEVENTTYPE. :Preserve the following generators at...")
• 17:02, 21 November 2023 Chanson talk contribs created page Command Import: Rain MO Work Notes (Created page with "<pre> PLANTS=========================== SELECT * FROM PLNT INSERT INTO ARTPLANT ( PLANT_NO, SYS_LOC, PLANT_NAME, ADDRESS_1, ADDRESS_2, PHONE_NO, PLANT_TYPE, PLANT_SCREEN_ID, DIVISION_NO,PLANT_WASH_MINLD, JOB_WASH_MINLD, BATCH_CAPACITY, MEMO, IMPORTED_FLAG, LAST_CHANGE_DATETIME, LAST_CHANGE_USER, ACTIVE_FLAG ) VALUES ( '{plant_code|trim=0}', 0, '{name}', '{addr_line_1}', '{addr_line_2}', '{PHONE_Num}', 'D', '{short_name}', null, {PLANT_WASHDOWN_TIME}, {JOB_WASHDOWN_T...")
• 16:48, 21 November 2023 Chanson talk contribs created page Command Import: Hedger Work Notes (Created page with "<pre> 2022DEC19 ==Customer Class select ltrim(rtrim(sales_anl_code)) class_no, ltrim(rtrim(descry)) description, * from sanl == INSERT INTO artcucls ( CLASS_NO, DESCRIPTION, IMPORTED_FLAG, LAST_CHANGE_DATETIME, LAST_CHANGE_USER, ACTIVE_FLAG ) VALUES ( '{CLASS_NO}', '{DESCRIPTION|LEN=35}', 'Y', CAST('TODAY' AS TIMESTAMP), 'HIT', 'Y' ); == ==Price Groups SELECT RTRIM(LTRIM(replace(PRICE_CAT,'.',''))) GROUP_NO, RTRIM(LTRIM(DESCR)) DESCRIPTION, PRCC.* FROM prcc =...")
• 16:06, 21 November 2023 Chanson talk contribs created page Command Import (Created page with " ===Hedger Work Notes===")
• 12:38, 17 November 2023 Chanson talk contribs created page Dispatch Option: Status Configuration (Created page with "Custom Column Headers can be applied to the dispatch schedule screen... File:DispStatsConfig.png")
• 12:37, 17 November 2023 Chanson talk contribs created page File:DispStatsConfig.png (File uploaded with MsUpload)
• 12:37, 17 November 2023 Chanson talk contribs uploaded File:DispStatsConfig.png (File uploaded with MsUpload)
• 20:25, 24 October 2023 Pmorey talk contribs created page Identify Assembly and Component Product Reconcile Group Mismatch (Created page with "<pre> SELECT PR.PRODUCT_CODE, PR.RECONCILE_GROUP, PR1.PRODUCT_CODE, PR1.RECONCILE_GROUP, PR2.PRODUCT_CODE, PR2.RECONCILE_GROUP, PR3.PRODUCT_CODE, PR3.RECONCILE_GROUP, PR4.PRODUCT_CODE, PR4.RECONCILE_GROUP, PR5.PRODUCT_CODE, PR5.RECONCILE_GROUP, PR6.PRODUCT_CODE, PR6.RECONCILE_GROUP, PR7.PRODUCT_CODE, PR7.RECONCILE_GROUP, PR8.PRODUCT_CODE, PR8.RECONCILE_GROUP, PR9.PRODUCT_CODE, PR9.RECONCILE_GROUP FROM ARTPROD PR LEFT OUTER JOIN ARTPRSTR PS1 ON (PS1.ASSY_PRODUCT_...")
• 02:07, 14 October 2023 Pmorey talk contribs created page Release Notes for Keystone 4.3.x (Created page with "__TOC__ <p><i>NOTE: Items in '''bold type''' are NEW features.</i></p> ==Build 4.3.12 - 8/8/2023== ===Dispatch Module=== Order Maintenance :'''Plant drop-down list now shows the closest plants to the job site based on site GPS coordinates.''' :Do not allow the delivery date/time to be changed on an order when there are voided loads that have not yet returned to the plant. :Do not allow the order to be cancelled when there are voided loads that have not yet returned...")
• 20:09, 17 July 2023 WikiAdmin talk contribs changed group membership for Bhanson from (none) to support
• 20:08, 17 July 2023 User account Bhanson talk contribs was created by WikiAdmin talk contribs
• 18:28, 17 July 2023 WikiAdmin talk contribs changed group membership for XxxAyeager from support to (none)
• 18:27, 17 July 2023 WikiAdmin talk contribs changed group membership for Ayeager from (none) to support
• 18:27, 17 July 2023 User account Ayeager talk contribs was created by WikiAdmin talk contribs
• 18:26, 17 July 2023 WikiAdmin talk contribs renamed user Ayeager (0 edits) to XxxAyeager
• 16:53, 17 July 2023 WikiAdmin talk contribs changed group membership for Chanson from (none) to administrator and support
• 16:52, 17 July 2023 WikiAdmin talk contribs changed group membership for Lcannon from (none) to administrator and support
• 16:50, 17 July 2023 WikiAdmin talk contribs changed group membership for Staylor from (none) to support
• 16:49, 17 July 2023 User account Lcannon talk contribs was created by WikiAdmin talk contribs
• 16:48, 17 July 2023 WikiAdmin talk contribs changed group membership for Hhildreth from (none) to support
• 16:47, 17 July 2023 WikiAdmin talk contribs changed group membership for Mbarker from (none) to support
• 16:47, 17 July 2023 WikiAdmin talk contribs changed group membership for Mbradley from (none) to support
• 16:47, 17 July 2023 WikiAdmin talk contribs changed group membership for Gbarth from (none) to support
• 16:47, 17 July 2023 WikiAdmin talk contribs changed group membership for Dcheng from (none) to administrator and support
• 16:46, 17 July 2023 WikiAdmin talk contribs changed group membership for XxxAyeager from (none) to support
• 16:44, 17 July 2023 User account XxxAyeager talk contribs was created by WikiAdmin talk contribs
• 13:21, 17 July 2023 WikiAdmin talk contribs renamed user Jquinnxxx (0 edits) to Jquinn
• 13:18, 17 July 2023 WikiAdmin talk contribs renamed user Jquinn (0 edits) to Jquinnxxx (password hell)
• 18:35, 14 July 2023 Chanson talk contribs created page File:ResetCache1.PNG (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs uploaded File:ResetCache1.PNG (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs created page File:RemotePlantSetup.PNG (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs uploaded File:RemotePlantSetup.PNG (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs created page File:RemoteLocationSetup.PNG (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs uploaded File:RemoteLocationSetup.PNG (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs created page File:RemoteLicenseSetup.PNG (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs uploaded File:RemoteLicenseSetup.PNG (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs created page File:Readmeta sql.txt (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs uploaded File:Readmeta sql.txt (File uploaded with MsUpload)
• 18:35, 14 July 2023 Chanson talk contribs created page File:Queue Properties.PNG (File uploaded with MsUpload)