Sage 100

We have started the process of implementation of Sage 100c Premium. My support portal is still not connected to our account and am in need of getting the Minimum System Requirements for the servers and workstations. I will be grateful if someone can forward…

Has anyone created a Positive Pay Export for Union Bank or any bank that requires the detail record to be on two separate lines? Here's a sample of the output file Sample data transmission payee positive pay Input format 908123456700002000720312070000029375…

I'm preparing my upgrade from v2019 to Sage 100c Advanced v2021 with PU1 (due to Scanco Operations Mgmt compatibility) and notice KB articles referring to slow performance issues with STANDARD and PREMIUM. But nothing with ADVANCED. Does anyone know…

Hello everyone, We are running into an issue where at random 2-3 users a day are not able to login to SAGE. They enter their passwords and the screen flashes and the closes. I've noticed that the module date is somewhere in 2015 when I catch a glimpse…

I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

PR header and detail are chained. Same problem with each.

I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…

Hi everyone, I have a phone number field in the Sales Order Entry task, which appears to be a customization someone added at some point. It’s not a default field, right? The text label looks a bit different than the other fields and sometimes it seems…

Hello, We are making some changes regarding taxes at our company and are wanting to change the default tax class when adding new items. Currently, when a new item is added it is assigned 'NT' (non taxable) tax class, and we want it to default to …

Hello, We are trying to set up an invoice report for a 3rd party company to help us manage our taxes. They require that we put taxable amounts on one row, and non taxable amounts on another row per invoice as we have some invoices that have both taxable…

Hello everyone, I received existing import job with defined perform logic The import job contains Command "CREATE_ERRORLOG" on Failure. Сan anyone tell me where I can find this error log? Also, Is there a link where listed all available commands…

Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…

I installed Sage 100 2018 Standard. Then installed product update 10 and Payroll 2.21. I migrated the data from the 2017 version and began to convert companies. When I get to the filing status mapping screen, there is a single line there, with none of…

Looking for a definition of what happens during period in all modules. Which files are purged, what files are changed, etc. Where can I find that? I looked on Sage's KB and found it for AP, but no other modules. Thank you!

I am writing an html email alert for Sage Alerts and Workflow v9.0 for Sage 100 and I have a table in the email alert and I want the table to be shaded for every other row. I'm using the nth-child(even) method and I can't get it to work. If someone has…

I'm trying to recreate PO Receipt of Goods from history. I can't seem to import to a PO where 10 lines are lot distributed and 1 line is not. What field can i add to distinguish between them?

I have a customer that has about 10 different divisions in different states. I received a few checks today , and while applying payments i accidentally over received in one account. So now that account shows -$239.40 , however i need that to be transferred…

Hello, We are having an issue with our invoices not closing out because the actual kit is marked as 'backordered' as opposed to 'shipped'. However, all components of the kit have shipped. For example, the KIT named ABC-KIT has 3 components: ABC…

I am working on a Crystal Report that shows a grid with sales history and would like to graph the history by sales period. For instance showing each period in 2018 as blue, 2019 as red, 2020 as green. So you will see each year clearly in each period.…

Is there a way to view invoices in Customer Inquiry for the Sold To Customer when National Accounts is Enabled? Currently, I can only view the invoices in the Bill To Customer. When someone is inquiring on an Invoice on a Sold To Customer there does…

Hello, i am now the default the admin for Sage for my company (I am a Salesforce Analyst by Profession), and I am just learning Sage Admin as issues or requests come up. I am not sure if this is the right group to ask, but overall in Sage if I want to…

Hello, I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…

We are going with SAGE 100, Starship and other integrated solution providers. What Zebra printers, shipping label sizes are best for printing both UPS and Fed Ex shipping labels. Michael

It appears that the process that is used to synchronize the workstation synchronization is no longer an app that can be run to update components after product updates are installed. Instead a vb script is run from a temporary folder. The problem is…

Hello, We have added many panel customizations including additional tabs, buttons with scripts, etc that are important for many of our users. I was just resizing a field in customizer, and when I went to exit the customizer an error popped up saying…