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…

  • Job related PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found."

    Project and Job Costing (Job related) PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found.". All other PO receipts have no issues. Please help us to solve this issue. Our Version is Sage 300 ERP 2019 and Database is Sql server…

  • Exporting Data from Sage 300 Pervasive SQL Database on a Recurring Basis

    We are working with a company using Sage 300 on a Pervasive SQL database. They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. I'd like to know if there are…

  • Importing Transactions into Project and Job Costing

    Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…

  • 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…

  • The values of "Category" in timecard import sheets

    Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR

  • GLJED CompanyID field with incorrect company ID

    We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…

  • loading data error

    Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks

  • Data Integrity Check

    Hi, We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed. 1 Error found in Administrative Services. Any ideas?

  • 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…

  • Day end error: Transaction History. Database error. (Operation=INSERT) (Error=824)..

    We using Sage 300ERP V.6.0 PU2. The error message when day end is show "Transaction History. Database error (Operatin=INSERT) (Error=824). Please advise, what happen and how we can solve this problem.

  • 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…

*Community Hub is the new name for Sage City