Browse By Tags

Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…

Hello, I am trying to build a data model based on the LOG_VIEW_USAGE table from the SEI database and I'm getting the error below when trying to add tables in the data model designer : Nectari.DAL +++: Index was outside the bounds of the array…

Where can I find the information I need to calculate customer aging over time? Usually when I get stuck I can copy something one of my predecessors did, but no one knows of any report like this previously. I want to be able to show a sales person, for…

Hello, I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…

Hi There, Client is recieving an error when running sage intelligence reporting, an unexpected error occured, the pastel auto connection system failed to create a link to your data, the error returned was: An erro occured in the pervasive.SQL layer the…

I use Microsoft Access to automatically generate pick tickets from BW based on available inventory. My problem is I cannot get the line items to "sort" correctly to match how they print on BW Invoices and Sales Orders. How does BW sort order the line…