Browse By Tags

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

  • How can I go about joining the SINVOICED table to the STOJOU table?

    As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

  • Sage 100 Standard 2020: How do I import a bank statement to Sage 100?

    Hi all, 

    I'm new to Sage 100 and trying to become more efficient at my job. I learned recently that it is possible to import a bank statement onto Sage 100 and automatically create invoice entries for them. After doing some preliminary research, there…

  • Export data from Sage 50 CA using SDK

    Hi all,

    Is there anyone has an idea to export the data from Sage 50 CA? I was looking at the method w the class "CustomerLedger" but it has only the Save method it does not have the get method, Please let me know if you have any idea of hints to solve…

  • Export files

    I am setting up a batch job to export some stock information to send out through my EDI program.  We've done this several times in the past and accounted for the name of the file being the same by timing of the various scheduled jobs needed to do this…

  • 500 or more new GL Account import

    I am going to use an excel file and only need to enter new GL Account numbers and description of the each account.

    What should I name the 2 columns in the excel spreadsheet so that  GL import process will except it? 

    Is there a sample GL Account import…

  • Sage 300 Data Activation

    A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed.

    sage 300 has detected module update inconsistencies that requires activation. The…

  • Bank Import Error

    Hi When I imported one transaction to see how reconciliation works, i got the below error. It says 1 updated but It does not reconcile that transaction, please could someone throw some light ?

  • Importing Bank Statements to Reconcile Bank Account


    I want to import bank statements into Sage 300 - I am not sure what the below fields do and what their exact column name would be for my import file. Could someone please help ?

    Cleared Y/N - Integer   (Column Name ?)

    Used Y/N  - Boolean    (Column Name…

  • SAGE x3v11 ACGGRP field description

    Hi everyone,

    I'm looking for the description of this field:

    Table - FXDASSETS field ACGGRP_0
    The description must be similar, but I have not been found a table yet with this description, please someone has an idea where I…
  • VI Export Job - Conditional export of two data fields into one column

    I want to export SO_InvoiceDetail data.  In one of the columns, I need the value to be the ItemCode, unless there is an AliasItem, in which case I want the AliasItem to be exported in the column.  My export currently looks like:

    InvoiceNo - Col 1


  • Visual Integrator - Export Job - Error 12

    Running Sage 100c 2018

    I had a job get stuck and attempted to unlock.  In doing so, it now gives me the error that a file could not be found and an error #12


    Is this an easy fix?



  • Importing CSV

    Hi all and glad to be here.

    I am using Sage50 to keep track of accounting that needs to be imported using QB CSV files.  I don't know if there is an easier way but I finally resorted to exporting Sage files to then populate using the QB data (hopefully…

  • Unable print _Manual check and payment register_databace connector error


    There is error message on the Sage100 as shown below. 

    How to fix the error?

    Thank you in advance for your help!

  • Oops, skipped a database conversion!

    We've skipped a database conversion during multiple upgrades (2017 to 2021), and now the database shows as "incompatible" and cannot be converted. The recommended solution is to get Professional Services involved. I'm wondering if I could start over with…

  • Importing Transactions into Project and Job Costing


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

  • error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

    In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753  12:00:00 AM and 12/31/9999 11:59:59 PM"

    What is this?

    I write reports, and get client databases to work in. This is the…

  • How to Import part of a previous database into Timeslips 2020?

    Need to import a Timeslips 2007 database into newly installed Timeslips 2020. Do not need much of the old data, but do need last several years of data. Is there a way to export the 2007 data and edit it before importing it to 2020?

  • new password database error message, and i don't even use passwords. what does it mean?

    the following error message appeared unprovoked today:

    firebird database error

    cannot attach to password database

    class: EIBNativeException

    code: 335544653

    i can't even open the database. the minute i double click the icon, the error appears. can't get…

  • Open PO Qty vs On PO qty discrepancy

    Hello All,

    We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty.

    SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts

    In the below example, in main I m seeing a open PO qty but in the orders…

  • Sage 100 ERP 2013: Remove price overrides for 10 specific customers at once in batch process?

    Hi everyone, 

    I'm using Sage 100 ERP 2013 and I'd like to remove the price overrides for about 10 specific customers. The customers have customer numbers that aren't sequential, but are scattered, in case that matters.

    I want to do this in…

  • Data export before decommission

    Dear Group members

    Our business no longer uses Sage for active data entry. We had used in past till 2019. We are looking to decommission the application in our organization. Before we do, there is a compliance requirement to store data records for next…

  • Integrity Audit Table problem

    Index version does not match Table version.  Is this a significant erro and can it be solved simply by deleting the table?

  • Betrieve Error #2

    I am currently using Sage DacEasy 2012.  I am currently trying to switch my "server" shared windows 7 pc to a window 10.  Somehow got messed up but still on windows 7 for time being. Have full version but currently only use ACC and POS.  Im coming…

  • Migration

    We are implementing Sage 300 ERP on premises.  Due to current situation, implementation taking longer than planned.  The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300?