Browse By Tags

I use VI to import invoices and have now run a duplicate batch but realized it is a duplicate before completing the process. The A/P Invoice Data Entry Batch is "available" but has not yet been processed. How can I delete this batch without processing…

I'm on Sage 100 Standard 2020 (v6.20.1.0). We create sales orders, and then after each sales order ships, invoices are imported into a SO_InvoiceHeader batch. When the batch is posted, all the sales orders are supposed to disappear from SO_SalesOrderHeader…

Our regular import of a payroll GL JE has failed with the error message: Description: External table is not in the expected format Source: 12:20:40 - 1071.80004005.503.914 The only identifiable change is upgrading from old Excel (version unknown…

I am trying to import payroll as I do every pay period. But for some reason I keep getting this error today. My VI import job for payroll has not changed, and has worked for years...until today. Any direction where I could get some help to fix the issue…

Hi there, I hope you can help me. I created a job to import data for a positive inventory adjustment, and I need to specify the unit cost. We are using Scanforce multi-bin software, so we also need to specify the bin and lot. The issue is that the job…

I need help! Our small business received a digital grant of $2500 which was deposited in December 2022. We did not make any purchases from this grant until January 2023. My questions:: How do I input this grant into Sage? I know that I have to put…

Sage 2019 app n db on one server. SQL database in use. Users of AR module were complaining of batch posting being slow so a reboot was done. After reboot realized , Ar module completely disappeared. Steps taken: 1. Did a sage full repair yet AR…

comment rajouter le détail d une écriture dans piste de vérification ou dans transaction de GL en CSV

This is the second month that I am importing credit card transactions using the new bank feed option. Last month worked fine. This month, after disconnecting and reconnecting the bank feed several times, it appears as though it is connecting, but a pop…

Newbie here. When I go to make an invoice paid that has associated inventory items on the purchase it won't let me change payment to cash so my Bank reconciliation is off by these invoices. So the invoice stays as Pay Later. How do I make these payments…

I've developed a script that, for some customers, discounts TX ItemCode's to absorb their AvaTax calculated sales tax and present a invoice total including sales tax (but not freight) equal to the original net invoice, but when the invoice is imported…

Has anyone imported charge card information from a credit card company or bank into Sage50. How is this done? Do you post transactions into your AP account and post all transactions to the credit card company as the vendor? How do you print the check…