• Error activating OPS Inquary 6.5

    When upgrading to 6.5 received error when trying to activate Ops Inquiry 6.5: Microsoft SQL Server Native Client 11.0 . SQL Server incorrect syntax near “2018”. Anybody with similar problem?
  • How to reverse a credit note ( Type: Return ) in Purchase Order (Posted to GL)

    How to reverse a credit note ( Type: Return ) in Purchase Order (Posted to GL) .Since the credit note entered a wrong date , i want to adjust the record , What can i do ? is it open a Debit note to recover it?
  • sage 300 API integration

    hi everyone, i'm currently doing a project that would like to read/write sage data from sql db via API. now i have a couple of questions and would be grateful if anyone could help: 1. do i need to install sage 300 on the development PC and every PC…
  • GL REVALUATION-NO RECORDS FOUND SAGE 2014

    Dear All, Wanted to Revalue at Gl level where i have setup both monthly av and daily sp codes in revaluation codes. When reevaluating the other currencies (Not functional) am getting the error "no records found to be revalued" as attached. Kindly…
  • multiple locations??

    My company is a distribution warehouse. We are opening a second distribution warehouse in a different state. I have been tasked with finding a way we can keep AP and AR for both locations separate for internal usage, and then be able to funnel them together…
  • Sage 300 ERP 2017 Canadian Payroll Import Timecard

    Here is the CSV file I'M trying to import. For some weird reason, it doesn't import the very last detail line of the last Timecard. All the other part is imported perfectly. I have loioked for empty space at the end and tried a bunch of other stuff but…
  • Sage 300 Portal

    Hi Guys, Was trying to test Sage 300 portal in VM but the following error pop up. i. Had tried all browser, i.e Firefox, Chrome, IE ii. Done run regacc with run as administrator Appreciate if anyone can assist. Please advise.
  • Feature Transfer Error

    We are unable to install the 2012 (Sage 300 Premium ERP) (Build 0) The error is shown below during installation: The following steps are taken before the installation: 1. Rename all the Sage folder in Driver C: 2. Deleted all the unnecessary…
  • AP detail description

    Hi, In AP GL integration, if the detail description option was not selected to be transferred to GL initially, what happens if this setup is done mid way. Will the detail description be transffered for history data? If not, then how can this be retrieved…
  • Aatrix unable to load vendor library

    Is your Aatrix tax forms update not completing or presenting an error? The Aatrix automatic updates this year-end may take longer to complete, please allow time for them to finish. For 2017 year end (W2, 1099 & 1095 (ACA)) filings, Aatrix now requires…
  • To fix depreciation rate

    Hi, I have only been using Sage for few months now - last week I added new asset through Asset Acquisition and posted to GL and everything before I realized I put the wrong depreciation rate. Is there any way to edit that? Or I have to dispose the…
  • General Ledger Labour Calculation

    We have a table in the database where we are pulling data for the number of hours for labour for different types of jobs. What we are looking at is that when one selects an automotive part for repair as a stock item that also there can be an option…
  • income statement doesn't zero after rollover

    sage 300 erp 2014 . After GL rollover has been performed there are 3 accounts that still show balance in it. they do not zero out. What could be possible reason?
  • Exchange Rate Macro stopped working

    We have been running this Macro for years now but on Wednesday it stopped working with the following errors I have tried to find what could have caused this but am at a dead end please see the code below and the line where I am getting the error …
  • Excel 2016 with Sage 300 2012?

    Client moving to new software per new owners in a couple of months, so do not wish to upgrade Sage 300. Sage 300 v 2012 local install, data on server. Workstation crashed, wiped and reinstalled. External IT firm installed Office 365 with 32 bit Excel…
  • Add-on FH for Accpac or Sage 300 What does FH stand for and who makes it?

    What does the module FH in Accpac or Sage 300 stand for and who makes the add-in?
  • Windows Authentication in Sage 300c Web UI

    Hi, May I know if 300c support Windows Authentication login? I did not see this option at the login page... Thanks, Cinny
  • Converting PO from Requisition gives no cost for non inventory items

    When doing a PO Requisitions for a non inventory item, upon creating the PO from the PO Requisition I noticed the cost did not come over with it. Is this suppose to happen? The cost for the item is listed in the requisition. Do note doing a requisition…
  • Replacing a lost payroll check in Sage 300C 2017

    I have an employee that lost their payroll check and I need to replace it. What is the easiest way to do that?
  • Sage 300 Inventory Software

    Good day could you provide me with suggestions, modules or tweaks that can prevent specific users from accessing or seeing certain inventory items?
  • Print to Email Issue

    Hi there We are running on ERP 2017 Outlook 2010 and following error occurred when processing Accounts Receivable Invoice to email:"Error: Description. Mail delivery failed. Use the Email tab on the Company Profile screen to send a test email and confirm…
  • AR Subledger Balance by Month

    How can I get the balance of the AR Subledger by month for an entire year or date range? The only way I know is to create an AR Aged Trial Balance Report manually for each month... but I just need the balance.
  • Sage 2017 PU2 Emailing Statements with new SMTP setting using Office 365

    We recently upgraded our client to Sage 300 2017 with PU2 and have been using the new STMP email option now available. The general day to day sending of orders, invoices, and purchase orders has been working without any issues, however when it comes to…
  • AR Receipt - Special / invalid characters in AR check / receipt field causing Bank Reconciliation issue

    A user entered a '[' within text in the AR Receipt Check/Receipt No. field which then caused an issue in the Bank Reconciliation. We are on version 2014 (300 Premium ERP) (Build 1) (Product Update 1). A posting by Connie H. in Sage Ideas database titled…
  • Is there an easy way to set up a cost plus job?

    Is there an easy way to set up a cost plus job?