x Want to participate? Join the group to interact

  • Import AP Invoice from own excel file failed

    Hi all. I create my own excel file with the same sheet name, column name as exported one. however, it failed to import with the error below. However, copy pasting the content to an exported excel file seems to works fine. The issue is: I am going…

  • G/L Journal Entry import from spreadsheet not working after Microsoft 365 version of Excel installed

    Our regular import of a payroll GL JE has failed with the error message: Description: External table is not in the expected format Source: 12:20:40 - 1071.80004005.503.914 The only identifiable change is upgrading from old Excel (version unknown…

  • Import Orders

    I have searched the help in my Sage 300 and in this forum and cannot find instructions on how to import a batch of sales orders. Can anyone point me in the right direction please?

  • OE import error "Negative Inventory Levels"

    Hi All, I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…

  • Import Inventory Control Preferred Vendor flag is not working, how do you mass update preferred vendor in the vendor details?

    I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even…

  • Importing Inventory Records

    When attempting to import inventory records we get an error "Category Cannot Be Blank" We have an entry in the category field. We even updated the inventory record with the value manually and then again attempted to import and we still get the error.…

  • Bulk Import of Items in I/C

    I'm wanting to add about 600 items to an already existing list of products in our datasbase. So, I exported 3 lists: I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…

  • System Error received importing I/C Receipt

    Version 6.2 PU1 Sage 300 ERP SQL 2012 I exported an I/C receipt, copy data to it from another spreadsheet and tried to import it back in as a new receipt (i.e. changed the sequence #) and am getting the following error: Description: System error.…

  • Importing Lot Details

    I have 6.0 Version and would like to import Lot information for the first time. what is the best way to do that a part from PO receipt. Please help

*Community Hub is the new name for Sage City