Sage 100

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…

We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

Have the following source file (CSV) 2 questions: 1 - I want to import the Invoice No and append "-CM". Is this possible? 2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…

Hello, I have created a VI job to import into PO Receipt of Invoice and encountered a problem with assigning the OrderLineKey from the original purchase order. I have it working if I manually provide the order line key in the import file but need to…

I have a client his mas90 program crashed. He has a backup. Can i get the name of a company that can help me import the data into sage 100

Hello, Today I had someone want to delete a batch that was entered into A/R cash receipts entry. When I try to delete it, a pop up box says "Missing or Invalid Header," and I am not allowed to delete the batch. I have seen this error before while importing…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?

Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…

Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…