Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hello Sage 100 Community,
I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout:
Account No.
Debit
Credit
Posting Comment
Journal Comment
6570-00
500.00
0.00
Test comment…
New install bringing in JC Trans Detail seems to think all entries are change orders and change orders can only be Cost Type S (subcontractor). Errors on all transactions that are not Cost Type S.
I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message:
"VI JOB_NAME Unable to open [wdx][odb]<dsn_name>"
I don't get this message…
I'm going through a process of converting several Standard Cost Parts to Serialized in our system for each of our warehouses. I've adjusted the items out manually using a transaction entry. I've changed the valuation from Standard to Serialized using…
Trying to upload a budget file. However, when I test the upload I am getting errors where the 3rd segment of a GL account number is being left off and causing the error XXXXX-XX- is not on file. However, other GL accounts are loading just fine.
Our…
I'm trying to create a VI Import job to bring in some general journal entries but can't seem to figure out to grab the next Entry No automatically like I can with Batch Numbers and Invoice Numbers. I can't get them to import properly without actually…
Hi, I'm trying to do an import of about 350 inventory items that are already in the system. I am trying to change the product type to "Discontinued"
I am getting an error on the import saying the product type is needed????
Any help with this would…
I have set up a VI import to import Item/Customer Pricing info for a single customer into IM_PriceCode. However, I would like to run a program as part of the VI job "On Execution" that would remove the previous records for that customer so my imported…
Our client has a system in place that kicks out a dept code. This department code has been directly linked to a G/L account by utilizing the AP Expense Distribution Table (Code 5 on the Distribution Table is equivalent to the G/L account we want to import…
Each invoice has a single line distribution, but fails to distribute. Checks and new invoices import, but distribution lines do not.. No errors show up when doing test import. Do you have any ideas?
I need to take 2 different companies in MAS and combine them in to one database (make them one company). Is there an easy way to do this? Do i use Visual Integrator? If so, do i have to do each database one by one?
Thank you for your help.
We have upgraded to MAS200 43 and our VI is no longer working. It will search records but will not export files.
This was accomplished using AP Check History Detail Report in previous system.
Using same information in new system, the report will not…