Sage 100

Good Morning, So have a bit of an issue that we're trying to solve and not 100% sure on the best way to go about this. We recently transitioned into Sage Intacct on Dec 1st and everything has been going great, however, our CFO now does not like the…

Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…

in Sage 100 customer maintenance how can we designate customers as distributors? we need this information for tax, insurance, reporting purposes. we can't rely on resale certificates due to the nature of our products.

We just upgraded to Sage 100 2022 and we are getting the following error in one of the companies. Has anyone seen this in the new 2022 version? The company we are using is very limited we are using AR to invoice. The item is a misc ar item code. any…

Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

We discovered a flaw with state sales tax not calculating properly and I was in contact with SAGE support about an issue. The issue was with sales tax not computing correctly when entering freight on a repetitive invoice. I was told it is a flaw in the…

I've been tasked with creating an AR Invoice import job with the input file not having an invoice number. Looking for a way to have a "Run Assign" field that would prompt for the next invoice number to use and then increment that number upon change…

We desire to document customer contact/communications regarding specific past-due invoices in Accounts Receivable. Is there a facility to do this at the invoice level? Frequently, we receive verbal confirmation from a customer that a past-due invoice…

I am a new controller to the company, and I have very little experience with Sage 100. We need a solution to send a customer one invoice (containing multiple jobs), and only show a summary as if it were one job. Our business is in manufacturing, and…

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…

I am trying to do an invoice adjustment (item was not priced correctly), and am trying to follow these steps: https://www.erpvar.com/blog/bid/89141/In-Sage-100-ERP-how-do-I-do-an-adjusting-invoice-entry-and-when However, when I enter the itemcode…

Having added a UDF to the AR Invoice history Called Enhatch order Id. When trying to print a copy of an invoice from this record the UDF does not print and it has been added to the form. Any ideas as to what link I am missing? To see the invoice printout…

We are trying to write a query or stored procedure to identify the cash receipts for each of our franchises (warehouses) but ran into some trouble with consolidated billing. Since payments aren't applied to the line items we need to create a lookup table…

I have a customer that has about 10 different divisions in different states. I received a few checks today , and while applying payments i accidentally over received in one account. So now that account shows -$239.40 , however i need that to be transferred…

Hello , We are new to using Sage 100 and have a few questions . After our sales people process a sales order we then go into Shipping data entry and then print the invoice. At the end of the day , we then update the register. My question is , how…

We are running a program were the customer at the end of the month receives a rebate on how many systems they sell. We have been putting this in as a credit on the customers account. Now that we have a fair amount of customers on this program we have…

What are the differences between 'Time Created' and 'Time Updated' fields in the invoice history? Assuming they are my local times and that it is based on a 24 hour clock with decimals as fractions of the hour (e.g. 15.5 = 3:30 PM)?

I'm in search of a consultant that can help audit our invoicing process and make recommendations on how we can streamline it and make it more efficient. It is extremely painful and there has to be a better way. Can anyone make a recommendation for a consultant…

Our developers have written an interface to pull and push AR customer data. Invoices (IN) are not a problem, but prepaid invoices (PP) produce no results and no errors. I'm pasting the code below. Any ideas? using System; using System.Collections.Generic;…

I have an invoice that was posted without freight added, so an adjustment was successfully processed to the specific invoice. I'm trying to find a way to update paperless office with a new PDF that reflects the adjustment, or some sort of means of sending…

I'm trying to set invoice object to a single record and not having much luck. What I'm trying: oSS.nSetProgram(oSS.nLookupTask("AR_InvoiceHistoryInquiry_ui")) Dim oInvoices As Object = oScript.NewObject("AR_InvoiceHistoryInquiry_svc", oSS) oInvoices…

I am running a VI import to import AR invoices into AR Invoice Data entry to post Invoice to Customer accounts. The import works I am using an assigned Misc Item code that contains a GL Account number for Sales. But when I try to post the invoice I get…

Sage 100 Advanced 2018. I have a script designed to fire on AR Invoice Header PreWrite: If a BillTo account is specified in Invoice Header it should confirm the checkbox UDF_BTST is checked in AR_Customer, and if not should displays a message reminding…

Hi, I have several customers with special requests regarding the sending of their invoices (mail, fax, e-mail to specific parties, etc). We created memos that pop up during Sales Order Entry. Unfortunately, that department doesn't always remember to…

Hi What are the steps to post a sales order through to AR? How is the AR pdf log created?