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...

Thank you xlhelp that is exactly what I want.

I already have the file set as read-only. The user can still delete the enoire file and this is what we want to stop the ability to do so.

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...

The batch status is posted with no errors.

That is why it is so funny to look into because all the journal entry's and batches are there but nothing is in the accounts. It is as if soemone went into the GLPOST table and deleted the information in the accounts that have been messed up. We want to know if it is an employee that did this...

That is what we were thinking has happened but how could we find out if someone had deleted the information.

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...

Our joint ventures all have percentage owned less than 100%. If this is correct that it will only handle 100% owned jv's then we will need to go another route. So ettiene are you absoluely sure that it only handles 100% owned jv's. Thank you all for your thoughts.

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...

If it nearly impossible to do in Crystal then how would you do statements then, showing the current transactions with applied details and all outstanding invoices. I would like to be able to use some thing for this month if possible.

What would that look like I have tried some different things but can not get desired results.

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 would like to restart this conversation. 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...

I am doing thst but csn not seem to make it work the way that our customers have been acustomed to. Any suggestion would be greatly appreciated.

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...

That is what I thought would be the solution I have to wait for IT then to do this. Thank you Jay.

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...