Sage 100

In Sage Intelligence if I run the report Fiscal Year Detail, the start date is not accurate if you are using a 4-4-5 Fiscal Year. The formula used to calculate the start of the month is not accurate and is off by days, resulting in incorrect period…

This has been an ongoing issue for years. When customer service enters an order, the credit warning comes up, even though the HOLD is right there, they can just leave the order status as open or new, send the order to shipping and once its shipped...…

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…

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…

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…

I'm trying to find out how many invoices are being entered by month/period. The generic report JAccounts Payable Analysis Report shows this information, but it is showing me data from year 2022, May through October. How do I change the date range? Or…

Is there an easy way to set up backup withholding for a vendor in AP? We need to withhold federal backup for a subcontractor.

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…

I have a client that bills once per month. I want to export the customers that have a checkbox I created that states yes, along with that month's invoice balance to auto-pay credit cards. 300+ customers need to be autopay a few days after the invoices…

Hello, We noticed that two vendors have a posted check with the same check number, different amounts, and different check dates. Check 4340 for 2,313.03 shows under Vendor A with a Check Date of 06/23/2022 Check 4340 for 2,120.14 shows under Vendor…

I am running Sage 2021 and have managed to get two people into the same batch for doing Credit Card transactions with Paya. Any attempt to add a third person will not work. What is the preferred method for allowing users to run a stored card for a client…

Hello I am trying to create a VI Job that will delete a long list of vendors with whom we have not done business in over 7 years. I've "created" the job and imported the data from my list but get an error. Sage does not like my thinking. Here…

We have started the process of implementation of Sage 100c Premium. My support portal is still not connected to our account and am in need of getting the Minimum System Requirements for the servers and workstations. I will be grateful if someone can forward…

Has anyone created a Positive Pay Export for Union Bank or any bank that requires the detail record to be on two separate lines? Here's a sample of the output file Sample data transmission payee positive pay Input format 908123456700002000720312070000029375…

Why doesn't the SO_SalesOrderHistoryHeader file get updated with the new customer number from the Customer Delete/Change utility? I've renumbered and merged several customer numbers and this is the one file that does not get updated. This file also is…

Hello, I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…

We have a client that has one company that would like to use the Expanded Customer Number, but they have another company that doesn't need the Expanded Customer Number. They set up the first company with the box checked. Now they are trying to set up…

I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

We have a process synchronization from our online store into Sage using the SData API. We had a glitch that caused a large number of empty Sales Order batches to be created. There are no invoices on these batches, so I was wondering if there was a way…

Hello, I setup a VI import Job for Transaction Journal Entry and it was working fine until recently. It is taking the offset account number and using it for the line account number as well. I am telling it to get the number from column, but it ignores…

AR Customer Statements are printing / pdf / paperless delivering blank pages. There is a documented "work around" for printing to do a crystal suppression formula... but that does not stop the "pdf all" or other paperless output options from doing blank…

Looking for a definition of what happens during period in all modules. Which files are purged, what files are changed, etc. Where can I find that? I looked on Sage's KB and found it for AP, but no other modules. Thank you!

There is only one bank code on my Sage 100. Cash receivables and payables have been recorded on the system and I did bank reconciliation. But I do not see any balance of cash receivables on the GL balance sheet. I would be grateful if someone…

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…

Is there a way to view invoices in Customer Inquiry for the Sold To Customer when National Accounts is Enabled? Currently, I can only view the invoices in the Bill To Customer. When someone is inquiring on an Invoice on a Sold To Customer there does…