• 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…
  • Migrating Sage 300 to Sage 500

    Hello Community, I have a couple questions that i need help with. We are thinking of moving our sister company, that is using Sage 300, to our Sage 500 software. Has anyone successfully done this before? Can someone point me in the correct direction…
  • 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…
  • Data Import Manager- process AP payments

    Hi I'm trying to run a using upload manager a way to update payments. I see that there's an AR pending payments, but i can't find an AP pending payment. is there one? and if so, where can i find that? what's the name of the destination entity? …
  • GL Import

    We have been importing Journal Entries for year through the GL Import, however we decided to begin to import more Journal Entries to save time. Currently when we are importing the system will assign a Journal Number to it but it there a way for us to…
  • GL Import with Invalid Number Error

    I am trying to get the GL Import working for our budget and read that the best way to get the import format is to export the budget data from GL Utilities and modify it with the updated data. I am using the delimited file and have finally gotten the import…
  • 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?