Browse By Tags

Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…

I'm running Sage 100c Advanced 2020, Version 6.20.6.0 We have one primary company and another dozen or so secondary companies. My accountant told me today that when he posts something in AR/AP in the primary company it is very fast - almost instant…

We have a vendor that we entered in our AP data entry. The amount entered into the data entry batch matches that amount of the auto draft from our bank account. When we go into Invoice Payment Selection, the amount is correct and matches back to the AP…

How do I set up my scanner [Epson ES-400II] to scan documents directly to the AP Invoice I am entering? I know I can scan the document and then attach it to the invoice after entering the invoice, but I want to scan it directly into Sage as part of…

I'm seeking a solution for the tax calculation outlined below. Within Sage 300, how can we configure the system to perform the following calculation: Gross amount: $100.00 - T1 @ 5%: $5.00 - T2 @ 2.5%: $2.50 - T3 @ 2.5%: $2.50 - T4 @ 1%: $1.00 Subtotal…

Is there any documentation available for the processing of 1099s from Sage 300 using Aatrix? It looks like no documentation was added to the user guides or F1 help for the "1099 Filing" menu option in AP Vendor Reports. Bert

Hi there! I incorrectly tagged an AP Payment as being paid by EFT, but it was actually paid by CC. How do I void the EFT payment on AP entry? Thanks Ashley

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

Hi all, While importing AP Payment, I encounter this error "The bank code and bank currency combination does not match that of the batch". However, the batch is still imported with all (total = 3) of the entries. I do not understand what does…

Hello everyone, I was wondering if it is possible to edit a PO quantity ordered in the lines tab without having to reverse the receipt of invoice. From everything I learned, I always thought we had to create a reverse receipt of invoice first, then…

I am importing an Accounts Payable Vendor to BusinessWorks. The file is a comma delimited file. The definition says to send city and state abbreviation a City, ST for example Hastings, MN. When importing, this adds the city as "Hastings" and the Zip code…

We believe a user deleted some AP vendor invoices. How can we find deleted AP vendor invoices in Sage 300 CRE?

Hi all, I have already created C# program using Accpac Advantage to import AR and AP Batches into sage in Ready to Post Mode. But my client wants it to auto post after import to sage. So, is there any tutorial or example that I can reference for doing…

That's it, really: when an existing vendor provides a new FEIN via their W-9, do you prefer to A. update their FEIN in vendor maintenance and carry on, or B. create a new vendor to account for the new FEIN and deactivate the old vendor?

AP_TRANSACTIONS.REF_NO has a 25 character field limit, however the use of this field has been limited in the BusinessVision front end GUI to 10 characters. It appears that this is because the cheque number field in system setup is limited to 10 characters…

Hello, I pulled an Over/Under and realized that on a specific job the JTD costs are not showing. We were billed and already paid the intercompany for their portion of the project (through TimberScan), but JTD costs isn't reflecting this. I already confirmed…

Can anyone line up the office connector reporting to the following report within AP AP --> Reports --> Invoice Regesiter --> Invoices Selected for Payment I would like to generate this report within Office Connector to have the information within…

When a vendor's W-9 lists company and/or personal names in both boxes one and two, what is the correct way to record this information in vendor maintenance? In other words, what name should go into the Name slot in VM? Or, should the two names be split…

How do I find out what invoice is not posting when I am getting Rejected Invoice on my posting report?

We are looking into the HH2 AP Workflow to replace Paperless as our AP Workflow software that pushes to Sage 100 Contractor. I think it has many benefits ... phone app/cloud based, data capture and vendor mapping, paid invoice status and payment details…

We will be paying a consultant a set amount every two weeks. Is it possible to set up a recurring bill and payment or just the payment?

We are using 2021 (300 Premium) (Build 20) (Product Update 2) An outstanding cheque was cleared by mistake during the Bank Reconciliation. The bank reconciliation is posted. Is there a way to mark this cheque outstanding again? We couldn't find a…

Good morning! Our accounts payable clerk has reported an odd behavior in a single company when she enters a record into a batch using the Invoice Batch List. Clicking the 'Add' button does not progress to the next blank record. Instead, the button changes…

In Accounts Payable How to I remove $0 distribution in invoices? These invoices shows up in "invoices to pay"