S100C Copy-Paste Grids

As soon as we saw a few of these calls come in and did some testing ourselves, we actually turned around a short video blog update. Since not everyone has the time to listen to those, thought we’d recap in this newsletter.

For quite a few clients, over the years, they have workflows that pull data into Excel, then it’s pasted into specific S100C grids; or data is pulled out in a query from S100C and the data is copied up to an online portal, or something similar. We’ve actually automated quite a few of these, saving time and increasing accuracy.

We first noticed this for ourselves in the late Fall. Ryan uses a special calculator Larry created when putting together hardware quotes, then pastes the results into the S100C screen. He said it wasn’t lining up correctly, so I suggested he get with Larry and find out if there was some corruption in the template. Since that’s a busy season, they didn’t get to it right away. Then client calls started coming in that the copy-paste wasn’t ending up in the right columns. That’s when we put it together.

We noticed a common denominator was that these clients (and Syscon) had upgraded to the latest version. Larry started testing the various data entry screens and found that they’re not all following the same rules when pasting into them from an Excel source. Some haven’t been changed, and others have; this created frustration all around!

Sage probably doesn’t see this as a bug, so we don’t expect it to be ‘fixed’ any time soon. They’re probably responding to user requests to improve the copy-paste feature to/from Excel and unknowingly created this mis-match of data entry screens.

Next Steps: IF this sounds familiar, we’re suggesting you change your templates, or reach out for us to make changes to your special forms/queries. You’re not going crazy, there really was a change, it’s just inconsistent. Need help? Just let us know! – CMW