Search results for query: *

Thanks again LB! Looks like I've got the report running properly now.

Thank you again for your help LB. What I'm trying to accomplish is to let the user decide on either a single date or range of dates. Through the setup of the parameter, the user has the option to enter either a discrete value or a range value. Granted, the user could add both, but I don't...

Thanks LB, will this also work for the range of dates option as well?

Hello, I know how to display multiple records for string parameters using the join({?param}, ",") function, but how do you do this for dates? Thanks!

Oops, forgot to mention that I'm using Excel 2000. Currently, I have broken up the cells by using the year(), day(), and month() functions and formatting the cells to show two numbers for day and month. Thanks!

Hello, I am having a problem keeping the leading 0s in my fields when combining multiple fields. Basically, I am formatting the date to look like yyyyddmm, but it always cuts out leading 0s for the day and month. So instead of getting 20040305, I am getting 200435. Can anyone help with that...

Oh dear god, how did I miss that? Thank you so much!

Hello, I am trying to autofill an excel spreadsheet using the following format: 1 1 2 2 3 3 4 4 etc. Everytime I enter in those values and then try to drag down to run the autofill, it doesn't pull whole numbers. Eventually it starts to triple up on some numbers (ie. 4.987, 5.013, 5.432 all...

I'm trying to add the AR and IC module to Pro Series 7.2 for a client of mine, and I keep getting an error that I've never seen before. When I click on the link to GL button and enter in their company number, the error "GL Chart of accounts has not been set up for this company." pops up, and I...

I have a client that is using ACCPAC Pro Series 6.0 with Message Master installed as well. Last night they started receiving an error message saying "File access is denied" I asked him if they had recently changed anything within their IT infrastructure or if they had upgraded their Adobe...

Thanks for the help LB. I ended up working it a slightly different way. With those values, I ended up tweaking the formula used to derive the sum and used that in my calculations.

Is this possible or can I go about it some other way? Here is my situation... I have a running total of a field called @AmountApplied. That runnnigtotal is being subtracted from an invoice amount so that we can display an actual balance per transaction. At the end of that section, I need to...

I figured that might be the case, and I apologize for being so vague about it. Basically, I have a report that contains information sorted by vendor regarding invoices and credits to those invoices. However, in the main report, the invoices and credits are both stored in the same field of the...

I was trying to set up an array to capture 4 different values per entry (reference, invoice, applydate, and amount). I then needed to have these records printed up in the subreport sorted by the overall Invoice number. Does anyone have an idea as to how I might go about doing this? Thanks!