Sage 100

Hi Everyone, I do not see the memo button on my customer maintenance screen. Where can I add the function for all of my users who will need to be able to see and change the memo when needed under the customer maintenance. I tried going into the AR Memo…

Has anyone done any integrations or been asked to do any integrations with Bill.com? I have had several inquiries as the Bill.com site has the Sage logo, but the integration they offer is for Intacct, not Sage 100 ERP. I have mapped it out to be able…

Our company has decided they want to change the AR Aging Invoice by Invoice Date to Due Date. Is there anything I should be aware of or need to run after I change the option? I would assume there is some utility I need to run that will recalculate the…

We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…

Sage 2019 - Looking for way to import into AR_CashReceiptHeader from a source file that contains only the invoice number and check number but not the customer number. Manual entry allows to enter an invoice number followed by the check number. This automatically…

is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…

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…

I am trying to get into the setup option "Price Level by Customer Maintenance" but am receiving and error message. Is there somewhere where I can enable this option?

My company has two departments, the main account dept are doing a process called Backdating. While they do this, another department is doing customer lookups for their current balances. The issue is when the main Account Dept is doing the backdating;…

Does SAGE have a feature that will automatically apply a customers credit towards open invoices? We have a customer that had a fairly large dollar value of credits on his account. We've been waiting to get direction from them on what to do with them and…

Hi, For one of our customers, we enter a sales order with the Deposit Payment Type of Pre-paid, but is there a way to see what GL account it is going to? I am trying to track from a previous order, and under the totals Tab that is where it mentions…

Is there a report that will show a list of customer invoices and the payments + credit memos applied against it? We have a customer that is constantly trying to re-use credit memos. Thanks for your input!

We just upgraded from Sage 100C V2019 in that version and all the others before we have been able to add on the fly ship to addresses. In 2022 it looks like someone thought it would be a great idea to remove that permission able item, either that or they…

We are fairly new to Sage 100. We upgraded to Sage 100 in March 2023 due to corrupted data in Sage 50. When we reconciled our bank accounts for March and April, unfortunately we didnt print out the reconciliation and the staff member that completed the…

I have seen two unrelated instances of a single random line showing up on my invoice when generating one using the path sales order, main, invoice data entry the GL detail report that I printed early May for our April rebill, as well as the latest…

Is there an option to run customer statements for customers with a balance less than a specific amount? (Ie, less than $100.00)

Hi Folks, I am trying to add payment information to my A/R invoices. My test company has a formula field called "Payment" with the following formula "formula = {@NetInvoice} + {AR_InvoiceWrk.FreightAmt} + {AR_InvoiceWrk.SalesTaxAmt}" that does not seem…

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…

Hello everyone, We are trying to merge similar customers in SAGE 100 2020, and we have discovered that ship-to addresses with the same shiptocode are being overwritten by the source shiptocode if they are identical. Is there any way to modify the shiptocode…

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.

We would like to allow some customers to pay their invoice on a 6-month payment schedule. I see that we can use repetitive invoicing and set up up for a 6-month period but we want to take the sale upfront. Does the repetitive invoicing replace the traditional…

hi, I'm working with v 2021 Premium. we've had issues with CI_140MB_UpdateDetailToIM.pvc. SO invoice batch posting was interrupted resulting in multiple HeaderSeq numbers being created once posting was refreshed - invoices were duplicated. Looks like…

I would really like to start using the eInvoicing feature in Sage 100c. I have it all set up within Sage (the eInvoicing check box is available in Customer Maintenance and I've sent a few test invoices using the feature). But, I find the email that 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 15 digits…

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 that…