Sage 300

Hi, Is there a way to find deleted entries in GL and the amount. These entries came from AR and AP and they've been posted in Subledger. And I'd like to know if we can find out the User who deleted these entries.

I have noticed that the out-of-the-box Crystal Reports glptls1.rpt and popor01.rpt use two tables (?) GLPTL and POPOPRN that are not listed in the data dictionary. What are these two entities? Any feedback will be highly appreciated. Thanks…

Our warehouse shipped out units with a dummy number that was converted to the correct format and the corrected number is showing as the shipped item on the OE Shipment screen. However, the information did not process correctly in the Bin Transfer records…

Hi, We are on Sage 2014 Service Pack 1 and we would like to know if there is a way to find out who made a post in GL entries and possibly the date and the time. Any clue?

Where can a client access the full list of tables and fields for each module in Sage 300 2014, so they can do a report in intelligence?

Hi Guys, quick question: v2014, in IC Vendor Details, last column --"preferred vendor" yes/no. What data table is this "preferred vendor field" in? Naturally thought it would be in ICITMV, but... it's not there. Thanks in advance.

Hi There A client is running Pervasive v11.2 on Windows Server 2012, they have Sage 2012 and PU4 installed. Just today they get an error " Cannot access database error=98" We have uninstalled and reinstalled, recreated the ODBC Connections, reinstalled…

A potential client wants to be able to encrypt certain fields in Sage 300 Payroll, such as social insurance number, date of birth, etc. He's not interested in "data at rest" encryption but rather active encryption at the field level. I know SQL Server…

Version is Sage 300 version 6.0 on SQL: The client upgraded the SQL box O/S to Windows Server 2012 R2. The upgrade is only O/S upgrade, SQL database still remains the same on the box. After the upgrade, some users' workstations randomly receive the…

We give employees a number when they are hired and they are sorted by their number, not their last name. How can they be sorted by their name and not their number?

Hi, I received an error when trying to detach my Accpac company database.The error related to a process still accessing the database. I ran 'sp_who2' and noticed a program 'jTDS' having multiple connections with my Accpac company database. Killing this…

some of my earning codes are inactive (in payroll setup) I have entered one of theses codes and the employee was paid anyway, my question is this What can be done so this doesn't happen again?

Hi, We have a client using Accpac 54 (SP3) on Windows server 2003 SP2 (64-bit). After logging onto Accpac (the users RDP to the terminal server), if they click on any Accpac icon they get the following error "Error occurred when activating ACCPAC…

I'm a distributor of cigars and premium tobacco. These products have too many attributes for the product description alone so I need another place to list this info. I noticed there are add-on which may help. Do I need an add on or am I missing something…

There seems to be a lot of discussion wrt the SQL Collation to be used, again now with the Vendor Filtering post on this Forum over the last few days. What is the general consensus wrt the correct one to be used with Sage 300 ERP 2012 & 2014? Thanks…