Sage 300

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…

Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …

I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…

Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520

Hello all. We believe we have found an issue with the Item Finder Qty on Hand field. When the user applies a filter using an Optional Field, the finder will display the wrong qty on hand. For example, if we filter for "Item Number" starts with 20149…

How do I write a SQL query to select only today's date in OEINVH.invdate. I see that the invdate is not in a date format but in a decimal format.