Search results for query: *

My boss asked what this tek-tips group has to offer on this subject. We are wondering what is the necessary steps required to do an update and what needs to be done to test it to ensure that it is correct. Is this something that can be automated via a form of a script and if so could someone...

I am trying to import a G/L batch and all that gets added is the header and the fisrt line of the entry. It doesn't give an error message but tells me that 1 header was inserted and 1 detail was inserted. There is however over 1400 lines that need to be entered. We are using ACCPAC Advantage...

I am trying to import an excel file into our accounting package and it wants it to be a string. If the account number does not have the non printing character (') with the number it stops and will not go any further. What I need to do is to have each entry in one column include the ' character...

Is there a way that an excel file can be protected from being deleted. I know that there is ways to protect the data in a sheet or workbook but would also like to have the file protected from a user deleteing the file. I am using Excel 2003 with Service Pack 2. Any help or suggestions would...

We are experiencing a huge dilema today as we have noticed that posted transactions have disappeared. I looked at the tables for journal entries GLJED and see the transactions for an account and when you look at the details in that account there is nothing in it. The GLPOST table does not have...

I am wondering if anyone can give me some information about the ACCPAC product G/L Consolidations. We are needing some method to help us with our financial information that we have. The question we want to know is if G/L Consolidations is the wya we should go with ACCPAC. Currently we are...

I am in the process of modifying our AR statement and need some help as to get all transactions in the currrent month for which the statement is being ran for. In the past our customers have enjoyed the benefit of seeing all transactions in the current month with the applied details with it...

I am working on cleaning up our ar statement and wondering what these two options actually do. The statement has too many documents on them and we want to show all current transactions in the month the statement is being ran. By clicking the include paid transactions and include applied...

I was trying to see what a modification to our AR statement and in order to do so I have to run the statement. When this is done I receive the following error. 1 E Error occurred when opening view AR0111. 2 E View 'AR0111' is not a valid View ID. 3 E Error occurred when activating ACCPAC Data...

I have created an import file in excel to import the reorder quantities for IC5.2A in MSSQL. The period startdate and period enddate won't import properly and the date that it shows is 06/01/1900. How to I enter the dates so that they import properly. The people running there PO's based on...

We are using OE Advantage 5.3 with MSSQL. I have created an excel template for importing credit notes into OE. The question that I have is how to import it and not have it automatically posted in OE. I would like to have the Credit Note imported and then it can be reviewed before the posting...

I have been asked if the security can be changed for a user in IC 5.2A so that they don't have access to pricing maintenance. The idea is that only certain people need access to change item pricing and others need to only view the item and the prices attached to them. The person who handles...

We are experiencing dayend processing problems and it gives an error message that it can't process all the transcations because an account set code attached to an item does not exist. What is the best method for finding the actual transaction that is creating the problem. We are using ACCPAC...

I am having trouble running macros. I can record a macro and veiw it but when I try to run one that is prexisting it tells me the class is not registered. What might be the problem and how do you fix it.

I am wondering if it is possible to add a field in ap invoice entry to track capital project numbers. I have looked in the invoice details table and see a field for project code called PROJECT. I would like to use this field but it is not available or shows up during ap invoice entry. How is...

We are wanting to use a newer version of Crystal Reports to modify and print existing reports. We have version 6, 8, 9, and 10 but cannot find version 7. We are seeing that some are saying that we are limited to using version 7 and others are saying that we can use up to version 9. If we use...

Just wondering if anyone has gone through the task of creating a crystal report that will print the payroll data directly on to T4 for taxation purposes. Every year we go through the pain staking process of trying to have this done and always run into problems. If someone has created a crystal...

We are looking at adding additional modules to our current ACCPAC environment. We are using ACCPAC Advantage and modules are version 5.2A and use MSSQL. We are looking for comments on as too whether there are any companys using it and their experience, any issues with these modules, and would...

Were are trying to import an IC adjustment and are recieving an error message. We are using IC5.2A with service pack 4 and with MSSQL. The message is as follows: 1: E Invalid Input. Cost must be greater than zero. 2: I Failed to insert record 3: I Stopped processing at record 0 in...

I am wondering if anybody is experiencing the same type of issue we are having. The Day End Processing is taking a considerable amount of time to complete. In tracking this issue we have narrowed it done to when there are no new transactions in OE, PO, or IC that the Day End Keeps on running...