Welcome to the Sage BusinessWorks Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
What is the link between the OESalesOrder table and OELineItem. I'm pulling the data via ODBC and trying to identify the key between the two tables. Any insight or documentation you can direct me towards would be greatly appreciated! (BW 2019)
SMUSERTASKS - if this is too technical of a question we can ignore it(delete).
As a BW user for 28 years our file SMUSERTASKS has grown to nearly 10MB and takes 4 to 5 minutes to backup or restore (SYSTEM backup) . Should this file be this large and…
I import journal entries (JE) into the General Ledger module, some of which affect cash accounts. However, they do not depict on the Cash Account Register in the Cash Management module. I have to manually re-enter the JEs via the "Enter Bank Transaction…
i have not closed Journal entries in G/L for 12months, so while posting it indicates that i cannot post for more than 12months without closing for the months. i decided to go back and close, then this error appeared.while closing G/L For month of June…
Does anyone know how to use code to get a date range... I've tried using SQL code to get a specific date and it continues to come back as an error. I know dates are tricky things to work with in SQL.
I need to know what table the Job Transaction Report pulls from. I am trying to create a custom report and I need all the data, but I need to know where the data from the Reference field is stored so that I can include it in my report. How do I go about…
After a few days ago our workstartions frozen after 2-3 minutes , and came up errors about database connection , such this ones:
Unable to get Database Names count
(7004: Failes to connect to the named server and/or database)
And derive to…
