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?
Thanks.
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?
Thanks.
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…
Hi,
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…
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.…
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…
Hi,
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…
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
Ann