• error when importing file GL budget maintenance

    Hi there, We're on Sage 2014/ Excel 2003 and this is what we have when we do the import in GL Budget Maintenance: "Account fiscal set invalid list choice put to field "Currency type" Any clue? Thanks for the help.
  • Importing in AR Receipts using single line items

    I know how to import into AR Receipts in Sage 300. Is there a way where Sage 300 can read single line items per transaction. For example, on the import file, I just want a single line item on the CSV for every cash receipt. Right now, Sage 300 requires…
  • Connectivity problem with Excel

    Hi, MS released an update this past weekend and it seems to have affected connections to excel. I was wondering if anybody else has experienced this. Before the MS updates our macros were programmed to connect to Excel with Microsoft.ACE.OLEDB.12.0…
  • Sage 300 ERP UI Container has stopped working

    Hi, I am having a hard time importing transaction on AR module, this notif. keeps on prompting while i keep on trying. I have searched some trouble shoot for this but still I can't proceed to what I am doing. Any help? Please! Thanks, B…
  • Conditional Formatting

    Have a question about Excel conditionally formatting within the Financial Reporter. I have a FR report with different columns for each division......is it possible to format that column either red or green depending on if that division is showing a…
  • FR Print to Excel - Excel file opens at bottom and not the top

    When the report is printed to an Excel File and you open it, the file opens at the bottom of the report. This report is several pages long and is emailed to management and people dont like to have to scroll up to the top all the time. Can something be…
  • Sage 6.1 PU4 - Excel 2013 32 bit "cmd Start : Error on creating Excel object - Excel not licensed"

    Hi We have a client running 6.1 Sage ERP 300 with SP 4 installed. They are using Excel 2013 32 bit which PU2 says makes compatible but when we run we get an error saying it cant open excel as excel. I ran a repair on excel in control panel. Ran…
  • Exporting previewed reports to Excel

    Recently upgraded to 2014 300 Advanced Version 6.0 functionality for exporting a previewed report to Excel included a dialog box where column sizing could be based on header, details, or other choices. That dialog no longer appears and the exported…
  • 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?
  • Accpac V6.0 Excel versions

    We have a customer on v6, moving to 2014 soon. In the meantime, a workstation using the system now has Excel 2013 on it and the financial reporter won't run. My guess is that it is an incompatibility issue. The customer is asking what versions are supported…
  • Create shipped and invoiced Order Entry

    hi all i need help i am record a micro fist thing i am entered the data in order entry screen and then press ship all button and then check the check box create invoice and then post the ORDER ENTRY and then i take the code and put it in visual studio…
  • How do you produce effective, multi-currency financial statements?

    How do you produce effective, multi-currency financial statements?
  • NOTHING APPEARS IN INCOME STATEMENT :(

    Hi guys, we have upgraded from Sage 5.3 to Sage 6.1. Everything was okey, and this morning I'm generating the financial reports. As I was generating the financial reports, I'm able to generate datas in BALANCE SHEET. But as I generated the income Statement…
  • 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…
  • Importing spreadsheet data into A/R invoice batch Sage 200 ERP

    Hi there! I have hit a bit of a wall and I'm hoping someone here can provide some pointers. Here is my situation: We have a company with multiple operation centers. I'm in the head office and part of what we do is to take paper contracts and input…