Sage 100

We need to have the ability to use Penny Test to verify bank accounts for a vendor instead of Pre-Notes. There are too many ways that fraud can occur by just using Pre-Notes. 

I created the following idea. If you agree, please vote for this.

www5.v1ideas…

How would I go about creating a popup for invoicing department when they are invoicing orders and some line items have a "0" for price? The goal is to eliminate giving things away for free by accident.

My company recently bought another company who has sage 100 for their accounting software.  Before we close out their books we need to enter a few AR cash receipts.  I have a basic knowledge of Sage 100 but am not proficient.   I have entered the payments…

Running Sage 100 Cloud 2019. I have not previously used Fixed Assets.  When I try to run it a message tells me it isn't installed but it is in the list of installed modules in Company Maintenance.  I can't find a phone number or website to get help…

We are experiencing extreme lag when posting Journal and Daily Transaction Registry. This has slowed significantly in the last couple of months and would seem to be tied to Paperless / Adobe PDF. Our Test Company environment without paperless office is…

How do you record a wire transfer from a customer in AR?  In AP there is the selection drop down for Wire Transfer, but not in AR.  I read if we use ACH/Credit Card, it doesn't post to BR.  So do we use Cash and if so, how/where do we enter the long…

Hi, I'm doing an analysis of credit card fees, with the intent of beginning to charge my Net 30 customers a fee for using a credit card to pay their invoice.  I doubt it's possible, but is there some sort of report, or series of reports, I could run…

Any suggestions on a label printer for inventory receipt of goods?  I'd like the label to be about 2 x 3 - most printers are either 1 x 2 1/8 or 4 x 6 - to small or too large.  I need a printer and of course the labels, compatible with Sage 100.  Thanks…

When we had Sage installed, all of our customers were imported into the system. When I start to type in the 'Customer No.' field, a drop-down menu appears with predictions of those customers. However, when I add a new customer, I have to click the magnifying…

OK. My lack of knowledge is really going to show here. For reference, we use Sage 100 2019 Manufacturing.

I have a highly customized Picking Ticket created in Crystal Reports. We are a manufacturer, and when a customer orders from us, the Picking Ticket…

I have a situation where Period End Processing has NOT been done in over 10 years. I am trying to get things cleaned up. Is there a way to close multiple years without having to close out each module for each period for over 10 years? That would be 120…

Currently we use payroll for expensing the labor expense on our setup.  There was an automatic offsetting journal entry that would zero out the expense for the labor transactions added to an S/O.  When WIP got turned off the offsetting transaction for the…

Upgraded to Sage 100 2021, I am not seeing paperless options in my Customer Maintenance screen, is there a new right I need to activate to get that back??

I am getting an error message while trying to import AR_InvoiceHistoryDetail records into Sage 100 2021 from Sage 100 2018. Error #112 Keyed File Error (Record Key Size Invalid), I got an error during month end close about an open invoice in the system…

I am new to Sage and need to delete a couple JE's that were in the previous (March) period-I have figured out how to reopen the period- however only 1 or 2 have deleted-the others tell me that they can't be deleted until all information is removed from…

We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog:

When I click More…

Hopefully there is a way to do this.

We are currently in a major backorder situation due to material shortages and have many orders that are partially shipping. For example, 

• We enter an order containing pages of items (100-300 parts)
• We are able to build…

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…

We are on Sage 100c Advanced v2019.2

We electronically paid 2 AP Invoices with 1 E-payment.  The second invoice should not have been paid against this vendor.  When we go to reverse payment, the total amount can't be changed to reflect only the 1 incorrect…

The Customer Sales History by Period >> Dollar Sold does not match our income statement revenue. I tried reverse-engineering the data and it appears that any values that touch the customer A/R account are included in Dollars Sold, regardless of which…

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…

Hi all, 

I hope everybody is doing well. I apologize in advance if I post this in the wrong section. 

I recently discovered the Visual Integrator module for Sage 100 and have been trying to learn how to create a job that imports an Excel spreadsheet containing…

Hi,

I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…

Hello,

We began using the Auto Check Reconciliation utility in Sage 100.  We imported a list of cleared checks from our bank, with the account number, cleared date, and amount.  We proceeded with the auto reconciliation, and now we need to completely reverse…