Search results for query: *

Hi There, I was able to stop reporting numbers in the current column of AR Aging by adjusting the AR Options (statement tab). Thanks Etienne. One other question: Can I have the AR Aging Report suppress the Current Column now that there are no numbers going to it? Thx, Mike

Thanks for the reply. When I go to AR Setup Options, I see that I have 'Age Unapplied Credit Notes...' and 'Age Receipts...' both set to 'By Date'. But it seems most of credit notes are aged in the columns except I do have one from February that still shows in Current. Any ideas? I guess I...

Hi There, Does anyone know what the 'Current' column is for in AR Aging? How is it different from '1 to 30'? I am using the Accpac Insight tool to query the AR Aging from several databases and cannot determine how to replicate what goes in the 'Current' column. Your help is greatly...

Ok...I understand. So an action has to be taken in Accpac to process the data before an external pull can be done in order for the data to be there?

Thanks Djangman. So no matter what, I have to run the report in Accpac prior to accessing the data as running the report is what populates the table...correct? Thanks.

I am using our Upstream Weblink program and grabbing this data and bringing it into HFM. I modified our GL Pull script and was able to do it relatively easily (I am surprised too).

I don't really have a budget for this project so I have to code it myself. Can anyone confirm if the statements in my approach are correct. Much Appreciated, Mike

I am looking to produce an AR Aging Report for our entire company which consists of many Accpac (v5.4) databases and many different companies set up on many different servers. I am thinking the approach to do this is to query the ARAGED table using an ADO / ODBC connection which I have been...

Hopefully someone else will have the solution.

I am having a lot of trouble running any macros from the web on version 5.4 that involves running reports. My code seems to trip up on the SaveWebReportToLocal part. Is anyone using this function in v5.4? If so, do they have a snippet of code they could send me of how to run a web report in...

I can't seem to run reports on the web from my macros anymore since we upgraded to v5.4. Does anyone have any sample code of a report that runs properly on the web from a macro? Much Appreciated, Mike

I went and found the Accpac Spy tool and I monitored the AccpacCOMAPI Report. The second last line says this: (SaveWebReportToLocal) Not a web report, HRESULT=0x80004005 Am I looking in the right place?

Yes, the report parameters have been updated and the report generates properly on the desktop version. The error I get specifically is... Run-Time error '-2147467259 (80004005)': Method 'SaveWebReportToLocal' of object 'IAccpacReport' failed. Any ideas?

I have recently converted to Accpac Version 5.4 and I am finding my macros involving web reports and those that are launched from Excel no longer work. Did something change with 5.4? They work with 5.3 perfectly. Some example code not working anymore: This macro runs a report and right after...

Can anyone help w/ this? I can create a batch and can add lines of detail to the batch but only if the first line has already been entered. That is, I can only add lines to the batch detail after there is one line of data already entered. I suspect I have my updates and inserts in the wrong...

Miraculously, I was able to get a little further in this process by using RVSPY. I am attempting to replicate a GL Batch Entry using VBA for a Norming Acquisition Entry. I am able to update the Batch Number and Batch Description, however, I keep getting errors when I try to update the...

The Excel File would be an export from another system. It would be a starting step and then I would look to directly interface between the other system and Asset Manager. Mike

This would be to replace the process of manually entering a batch from a list of invoices on a monthly basis. I know that you can import in additions into the Asset Register but this doesn't produce an Acquistion Batch in Asset Manager. It only adds the assets into your register and then...

Thanks. I am actually looking to write data...ie create the ability to use an excel file to populate an Acquisition Batch Entry. It seems like it is missing the File...Import feature that is available on most other Accpac modules. We don't use the ODBC feature here so I would have to go the...

Thanks. If anyone has any examples of creating an Asset Management Acquisition Batch via vba code, it would be greatly appreciated. Thanks, Mike