• Error "Vendor cannot be blank" on Excel upload of A/P Invoices

    I have started to upload A/P Invoices using the Excel template provided with Sage 300. Whenever I upload a file, I get the error message "Vendor cannot be blank" despite the Vendor Number (IDVEND) being populated in the Excel file (in the "invoices…
  • G/L Inquiry with Income Statement Year End Income Statement Amounts

    FormerMember
    FormerMember
    Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…
  • Sage 300 2018 Error on export button

    Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages . As soon they click on export button the following error is received. generally user tends to run the…
  • Importing Employee Transaction History from Excel

    We have many employees with pre-tax 3rd-party short-term disability deductions. When those employees receive payments for short-term disability, some employer-related taxes must be calculated. I have a custom Excel workbook to carry out these calculations…
  • SQL Server Runtime Edition and F9

    Is it legal to use the F9 product of Infor.com with Sage 300 ERP databases that runs on Sage's MS-SQL Server runtime edition?
  • The more you know: Sage 300 ERP tips and tricks

    In this blog post, we wanted to share little tips and tricks that we here in support have picked up and want to pass on to you. How do I Get Real Time Posting in Inventory Control The only way to have real time posting to work is if in IC options…