Sage 100

We are utilizing a test company which is a copy of our live file for verifying effects of journal entries and other transactions. Is it possible to update a previously created test company copy with up-to-date information from the live file? Or would…

I stumbled upon another post that described hard-coding or allowing a user to manually type in a deposit number when chaining two VI-Import jobs together for a Cash Receipts import. We are not wanting to go this route as in our case the deposit number…

Hi Support Community /Support Folks:

Customer suffered a power fail 2 days ago, Windows 11 running on Dell Inspirion.

Ran sfc /scannow and found and repaired system corruption.

Ran Windows updates (Win 11 22H2) as well as Dell command updates..

But whenever…

Good afternoon, I am troubleshooting how to create a NACHA file out of Sage. I have been able to export an ACH File from Sage, but I need to have a file type of NACHA in order to upload to our bank or else it errors out. Has anyone else ran into this…

Finance charges are setup to be a fixed amount; however some customers should be exempt from finance charges. I can't find that I can import into the finance charge field. I want to import $0 for these customers. You can manually change the amount in…

Is there a way to create multiple accounts at once in Sage 100? We are creating a new business branch, and we need to create all income statement accounts for the new branch. Is there a way to add all of the accounts we need using an upload template or…

We recently upgraded from Sage 2018 to Sage 2022 version. In the 2018 version there was no "State/Province Code" maintenance task because there was no country/state relationship table. When you needed to enter a new Zip Code in Sage 2018 you would pick…

Posting this in case it helps someone else.  (Client is Premium, if it matters).

After a lot of troubleshooting, a colleague confirmed the issue is that a vendor just alphabetically prior to the one in question had a French accented character in its VendorNo…

Sage 100 2021 PU3 Advanced.

After selecting vendor invoices for payment, then going into the check maintenance window, duplicate invoices display. However, the invoices are only entered / posted once. If the phantom invoice is not removed from the check…

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…

We need to be able to track who is making changes to a bank code in the bank code maintenance module. We are currently able to track when a change is made. Is this possible or would it require a custom script to do?

Have a client running Sage 100 Standard 2021 PU2.

A check prints for an open invoice, even though the invoice was not selected for payment.  The check prints, but the invoice it paid does not show up on the stub.  The invoice does not print on the Invoice…

We are following Sage ticket instructions on correcting an aged transaction.

Part of the instructions are below:

• In the File Name field, select the "..\MAS90\MAS_xxx\ARxxx\AR_OpenInvoice.M4T" file and press the ENTER key
• 1. Click Key Scan button…

We have a client that would like to export their customer credit card information from Paya's Vault so that they can upload it to another payment processor.   They do NOT use Paya for their payment processing at this time, they just store the credit…

Sage 100 2021 PU2

This happens even if no changes are made.

Running Sage 100 v2018 and have a similar issue that was resolved about 6 months ago..."VI Export Job - Conditional export of two data fields into one column" originally posted by SO1.  My situation is similar with a twist.  I am looking to export…

Running Sage 100 v2018.  Client has AP Divisions turned on and has multiple vendors with the same Vendor No. but different Division (01-1234567; 21-1234567, etc.)  When exporting Vendor information through VI, they would like to only have one instance of…

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…

Running SAGE 100 v2018 and am trying to export data from the AP_OpenInvoice table where the CheckNo is not blank.  I've gone into the Export Select tab, selected CheckNo, selected the Relation as "Not Equal (<>)".  For the Selection…

Our Accounts Payable Specialist tried to export a positive pay file and received the following error:

"Unable to create the export file using sequence number 0 through 9.  You may need to rename or remove existing export files and run the export again…

I am working on building two VI Jobs that will automate our Cash Receipts Entry process. The first job inserts into the AR_CashReceiptsDeposit table, the second will insert to AR_CashReceiptsHeader so our AR Manager can simply spot check for accuracy…

How do I import the calculation method and commission rate for items?

(IM Setup has been set to calculate commission by item)

CI_Item does not contain those fields.

Running Sage 100 v2018.  We receive an import file containing AP Invoice information.  Within the import file there is a Purchase Order number.  I am trying to figure out a way to match the PO number from the import with the PO number within the PO_ReceiteHistoryHeader…

Hello,

I'm working on a VI Job to import a csv list of active Sales Orders with Sales Order Number, Line Key, the current Item Code, and the new Item Code we want to replace it with. It worked fine in our test environment except for the quantity ordered…

we are attempting to delete a SO. we have successfully done so to other SO but this one item gives us an error #47 Substring reference out of string and we are unable to do anything.