Hi All,

    In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table.

    But there is no entries for 3, 4, 5 in AOM.

    Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH?


  • Querying SQL server Invoices vs Sales History discrepancy

    I am trying to validate some data for our team and am stuck trying understand the data layout. My boss is using stonefield reports to generate a monthly sales report and he has 2 versions generating different #s. There seems to be confusion on what date…

  • Journal Entry errors: unable to add new GLJED row because of multiple error


    I am doing customization to add multiple lines to GLJED. But I get multiple error that I cannot find out why it is happening, note that I only trying to add to GLJED, not GLJEH

    Below is my code. Instead of getting the record by Batch in GLBCTL, I…

  • Use Browse() with "NOT IN" where clause/filter

    Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.…

  • One on one training - Intelligence Reporter with Connector

    I am looking for one-on-one training for Intelligence Reporter with Connector.  I have done all the Sage training courses so I am comfortable with the feature.  I have a strong understanding of relational databases and I have a basic knowledge of programming…

  • Get List of Companies database using MSSQL Query


    I want to create a Business Intelligence Report by using Report Manager & Connector.

    In this report, I want to get rows from table APPYM of all Companies database. 

    But first, I need to know which database is actually a company database for Sage…

  • Sorting data in Excel from Sage download

    Can you sort data if you download into Excel.  I have a large downloaded file that will not sort (filter not working)?

    Appreciate any help