• Importing purchase requistion details from an external csv file into the grid field

    Newbie here. I am entering items details manually into the different fields of a purchase requisition. I have a csv file with data from an MSC shopping cart. How do I transfer this data into the Purchase requisition grid without copy and pasting field…
  • Is there an easy way to import journal transactions to SAGE 500 ver 2016 from QuickBooks

    Looking for the best method to import transactions. We do not have Data Import Manager. Sage 500 version 2016, upgrading to version 2021 this year.
  • Does MRP Generation look at Purchase order tables?

    When MRP Generation is running, does it look at the open PO's, what does it look at? Does it look at Header or Detail line tables? Or does it go by the PO Log? Reason for asking is that I see a lot of entries in the PO Log that are not in the Header/Detail…
  • Import Doesn't Show up in Journal or Ledger

    FormerMember
    FormerMember
    We want to import a csv file instead o manual entries to save time. I select file "Select Import/Export" select "General Ledger" and then we created a template for our import file. The fields are in this order Reference Description Number of Distributions…
  • MAS500 server crashed, have restored DB, but need reports from within software.

    Our company MAS 500 server crashed, very hard no recover. The DB was backed up to another server and I am able to restore the DB from the BAK file. The data is there, but we need to access reports and stuff. We no longer have the MAS500 server software…
  • Invalid characters in Item and SO ids

    We are running into issues where a user copies a part ID from an excel sheet only to get a space at the end of the item ID or SO tranno. Sage support didn't have a good suggestion to keep this from happening. Has anyone else run into this? If so what…
  • General Ledger Import ignores required reference codes

    We have reference codes required on some of our GL accounts. When we import a journal entry, it is possible to post the entry without the reference code. Is there a way to stop this?
  • Sage 500 discontinued

    We are currently using Sage 100 and want to move away from a proprietary database. We were looking into Sage 500. In all my researching someone just mentioned to me that Sage 500 has been classified as a ‘sunset’ product meaning… while companies can still…