Sage 100

Hi, My company is currently importing journal entries to the General Journal Entry module by uploading a csv file through the General Ledger Exchange. I was wondering if there's a way to customize the settings so that Sage is the one assigning the journal…

Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table? I've tried creating an UDF via CM under SO Additional Picking List Work, but I…

Hi everyone, I'm using Sage 100 ERP 2013 Does anyone know exactly where (and if, even) I can limit users' abilities to change the Salesperson in Customer Maintenance, Sales Order Entry, and anywhere else where it's possible for them to do so? I'm…

I am using Sage 100 2019 version, I did print checks and I notice that the posting date showing is wrong, the last part of update is not done yet, meaning is not posted in the GL but it does not let me go back or reprint this transaction. how can I…

When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…

All, I'll try and be concise. I am working with Sage100 2019 and Visual Integrator Jobs. We just moved up from Mas90 4.3. Whoa, I know. Here's my dilemma: In Mas90, we had a VI job that would bring in website orders in a csv formatted file and import…

Hello Everyone, I'm currently working on a customized web app with PHP and MySQL backend for remote field services of a company. Since the company ERP is Sage 100, has anyone ever tried connecting Sage database with such customized web app? Appreciate…

In Business Insights Explore, is there a way for me to have the Data Field information and the Preview Field information on the same report? I've got all my fields the way I want them, but I don't want to just see the Invoice History, I want to see the…

I added a tab to my Invoice Data Entry panel with UDFs I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…

I have a script to delete CSP pricing on the IM_PriceCode table. I was wondering would there be a way to run this script outside of SAGE say from Task Scheduler?

Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…

Hello, We sent a PO to one of our vendors and it was supposed to get shipped to our CA location, however they sent it to our FL location. We now need to send this material to our other warehouse as we have no space here to keep the product. For…

Hello, I'm curious to know if I can create user defined fields in Sales Order Entry and the same fields in Invoice Data Entry? The fields are populated in the Sales Order Entry window, and then transfer to the invoice. The fields are in be added to…

Hello, We went live with a new project yesterday and are having some issues. I spoke with support, but because we have so many modifications they said they were unable to help. I found the two below entries in the activity log that I believe may be…

Hello, I've created a VI job to import Sales Orders. All fields work perfectly with the exception of the Quantity and Price. The import log shows both fields as blank, even though the amounts are in the selected columns. I also tried setting the amounts…

Been awhile since I've worked with Crystal and have what should be a simple formula. The Qty BO Column on the SO Picking Sheet just prints an Underscore. I'm trying to get it to print the Qty BO if not equal zero and a blank if equal zero. Keep…

Hello, I have one user who is unable to change the Warehouse code in SO entry from her default to anything else. It is greyed out and wont allow a change. I have changed her permissions, changed her customization group, and nothing has worked. Is…

Hi everyone, Does anyone know of a good system that will help track orders as they're being processed by integrating with Sage? I'm hoping to find something that has a good way to help us keep things on track as orders are being picked, processed and…

Hi, I am pretty new to Sage 100 and I am still getting up to speed. We had a server crash at the office. I was able to reload Sage 100 and restore from backup. My problem now is getting into the archives for previous years that I do not have backups…

When running the standard Monthly Sales Report in the Accounts Receivable module, under Options, the screen only shows the oldest accounting period in our database. Shouldn't users be able to pull down a menu and choose any individual month or range of…

Has anyone installed the F9 software version 4.5 with Sage 2019? We currently have 2016 and it works fine but we are about to upgrade and before we make a change I thought I would check.

We have Sage 100 2018. Looking to add the Routing Number/Description to the Work Order Inquiry Header screen. Can this be done? I can only seem to add UDFs in Customizer. Is there a way to add existing fields to an existing panel? Thanks, Ryan

Is there an SOP available to set up Paperless AR Statement Delivery only for specific customers?

Hi Guys I am looking to remove access for a group of staff from changing the salesperson on a Ship-to address. I am ok with allowing the group to create a new ship to address but I do not want the group to be able to change the Salesperson. I have…

I would like to add the $ to the beginning of sales numbers in a custom Crystal Report, however I can't seem to locate a place to add it when in Cyrstal Reports.