Search results for query: *

Hello, The powers that be have decided we need to remove all data prior to 2007 from Accpac. Now, using periodic processing I can see what is available to clear for each module but they want absolutely no trace of the data to remain in Accpac and I am not sure if this can be done or if any...

Hello, I am trying to do a dataload to test databse but get an error that Accpac needs exclusive access. When I look at lanpak users, it says there is an open connection to the database in question. The user logged however is an admin (which limits the possible people to 2) and neither of us...

Hello, We have a user on a Windows 7 box with Excel 2013 and Excel 2007. Regardless of which version we associate XLS files with, financial reporter opens up in 2013. On his machine, Excel 2013 was installed second. In my local test environment, I have Excel 2003 and Excel 2010. Regardless of...

Hello, We have GL batches showing as open but won't post with the message "There are no batches no post". The batches in question appear in GLPOST however. I am currently in the process of running data integrity but does anyone have any ideas? We are on Accpac 5.6 PU2 on SQL Server 2008R2.

Hello, We have a user who accidentally loaded an invalid OFX file. Is there an easy way to clear out this bad batch without going to the database doing doing a T-SQL delete? We are on Accpac 5.6 PU2. Thanks for your help in advance.

Hello, I have a .net application which is importing data from a remote MS-SQL database and creating AR Invoice Batches. Do I need to install Accpac locally on the server that will host my web application in order for it to work? I'm not 100% sure how the DLL communicates with the server as I...

Hello, Does anyone know if it is possible to open an external application (like Excel) from a custom visual process flow? If so, could you provide some insight on how to do this? We are taking a look at Sage 300 ERP 2012.

I got a report from our Accounting department they keep trying to post a bank rec. but get the message "Successfully posted 0 bank reconciliations out of 1 banks specified." When I look at the bank rec. they are trying to post, there was only a single check issued out of this account this month...

Hello, I have a stored procedure which is returns 10 resultsets from 10 queries. I am using BCP/xp_cmdshell to save this to a flat file which then gets emailed out each morning. I wanted to do this without using bcp/xp_cmdshell but could not think of a way to do this in SSIS without having 10...

Hello, First let me apologize and say this is my first SSIS project so bare with me as I did a quick search but did not see what I am looking for. I have a project that contains 7 Data Flow Tasks. Each task runs a query and creates a flat file with the results. What I am trying to do is link...

Hello, I am curious what the experience has been for anyone who upgraded to 6.0 from 5.x specifically to take advantage of SData? We have various custom applications in need of work to meet expanding requirements. Seeing as 6.0 introduced SData, it seems natural to upgrade in order to take...

Hello, Does anyone have or know where to find a template for the 5.6 GL Account Code changer? I do not have one in the office and the documentation on the web/help file is dreadful. Thanks in advance.

Hello, I have been asked to convert some vb windows apps into c#. I seem to be unable to create a dblink although I have had no problems in anything else I have done. Here is the code I have so far: [code] public AccpacSession OpenSession(AccpacSession session) {...

Hello, We are running into an issue where AR Receipts are missing from the bank reconciliation module but they are on the G/L. Naturally, I advanced the reconciliation date and all the items that were missing are magically there. Now I was under the impression that the deposit date was...

Hello, We running the financial suite for 5.6 Product Update 2 on SQL Server 08/Windows Server 08. When I run the data integrity check on bank services it constantly freezes after running for 10 minutes or so. I know this module can be slow so I let run for 24 hours but nothing happened and I...

Hello everyone, I have a VBA module that sorts worksheets in Alphabetical order. I created a new menu option that has a link to the a macro that is created when I import the sheet sorting module. I would like to give the users the ability to use this custom menu to sort any workbook but right...

Hello, Our issue is we're trying to see if it is possible to print an AR Invoice batch to PDF but rather than create 1 PDF with X number of invoices we'd like it to create 1 PDF for each invoice in the batch. Has anyone managed to do something along these lines? I'm guessing we might be able...

Hello all, I want to customize the subject and body of the message. I see $Customer_contact which makes sense but how do I specify a specific field related to the invoice such as Ship-to location? What about Ship-to location's contact name? Do I need to use print boss to achieve this or can...

Hi guys, I have a stored procedure which is getting a list of IDs that need to have data populated from various tables. I'm creating a temp table and then using updates to get those values. An example of one update statement is: update #ATemp set AMT = AMTTOT from H h join D d on ... join C...

Hi guys, Here is my problem. I have a report I've made that queries a custom my-sql database using a command to get an integer ID field and a datetime field. The report is only going to be used by Accpac users so I was hoping to be able to add it to their Accpac desktop and be done with it...