Accounts Receivable

Passing Parameters to external URLs

Hi guys - has anyone been able to - either by embedded URL, javascript iFrame or nav link - been able to pass a parameter of the imis ID to a 3rd party URL when a user logs into the public website. (kind of like the IQA dynamic filter of @Me or @SelectedUser)

Eg

imisid = 1000

External Link: http://mysite.com/id=
External Link: http://mysite.com/id=1000

I am hoping to use an ifram within a html ipart - or embedded url ipart (or event a nav link) to achieve this.

Passing Parameters to external URLs

Hi guys - has anyone been able to - either by embedded URL, javascript iFrame or nav link - been able to pass a parameter of the imis ID to a 3rd party URL when a user logs into the public website. (kind of like the IQA dynamic filter of @Me or @SelectedUser)

Eg

imisid = 1000

External Link: http://mysite.com/id=
External Link: http://mysite.com/id=1000

I am hoping to use an ifram within a html ipart - or embedded url ipart (or event a nav link) to achieve this.

Internet Batch - Transaction date shows paid thru instead of actual batch date

Hi,

The dues payment transactions in our internet batch always show a Trans.TRANSACTION_DATE = 6/30/2013 (the paid thru date) instead of the actual batch date (e.g. 7/9/2012) like the other transactions in the batch.
Has this ever happen to anyone else or do you have any idea what could be causing it?

Thanks in advance!
Silvie

iMIS, ACCPAC and Crystal Reports: crpe32.dll

We are having problems with clients that have both iMIS 15.2 and ACCPAC (financial package) installed on workstations.  Following the upgrade of iMIS from 10.6 to 15.2, some machines were having problems runnig custom Crystal Reports, with a message reading "iMIS Crystal Runtime Error. Unable to load report." Standard Crystal Reports were running fine, and we narrowed it down to a known issue with multiple copies of the crpe32.dll.  ASI/iMIS community advice is to delete or rename this file in every location except the one in C:\Program Files (x86)\Common Files\Crystal Decisions\2.0.

iMIS 15.1.3.8850: PK error generated in Pre Posting Accrual dues stagewhile Dues Billing.

I noticed that the PK error was due to the process not generating a IN AR line item for an ID but creating it in the next transaction number. In the next transaction number the value for line ID was twice that of what it should be.

To explain further, we are billing 10 line items, based on special prices. Process picks up all ten items in insert statement but does not add the 11th line as the IN AR line to give total due. Then next ID transaction number is correct from 1 to 10 line numbers but has a IN AR item with line number as 21 and not 11.

Multiple currencies

Hi there,

How can we support multiple payment currencies in iMIS?

Scenario: the organization I'm working with receives donations in both Canadian and US dollars. They update exchanges rates every month. They need a mechanism to track the original USD amount and the exchange rate so that they report CAD equivalents in financial reports.

How can currencies be setup for the desktop application?

Thanks,
Annie

iMIS 10.6 new dues billing behavior with account receivable?

Hi everybody,

I have a question for the community.

We had migrate to imis 10.6 few weeks ago. We have a new behavior and I'm not sure it is good. In iMIS 10.2, if a create a new bill in the customer/billing tab with a dues item and after I make a payment, I receive a pop-up with this message :

There is and underpayment of ####

Click Yes to confirm the creation of an AR item

Credit card logo display

I have been asked by a client to look at display of credit card icons on the checkout page for both

  • e-Series
  • Public Views

I've done some documentation searches and have not found anything helpful.  Am I missing something simple?

How to generate New and renewed CM members export report?

Our organization upload list of new and renewed corporate members to our website monthly and I'm trying to find a simple way to export these list to excel from iMIS. Is there iMIS built in report (crystal?) that shows new and renewed members? eg. all members who become new member by paying membership (from biling or on-line) in specific month and members who renewed in same month? We need to export report to excel file for web diretory update.  Currently,  I created two ad-hoc quaries; One using Join_Date (new member) field and renew with MT_CHANGE_DATE (member type change), but this search option is not accurate and doesn't pick up member when join_date value is missing...
Please advise me if you have better solution for this report. Thanks,
*We currently use iMIS V15.1.2

iMIS Simple Orders - how do the Trans, Orders, Invoice and Subscription tables link together?

I am using iMIS 15.1.1.3632 on SQL Server 2005. For our Finance Department, I have been asked to create a report listing all transactions relating to a specified product code, or to a specified user. Unfortunately, we cannot use one of the built-in Crystal reports as none of them allow you to see all transactions for a given user. I have tried to write a 2-part SQL script to get the information but I am not clear how the tables link together. For the first part, which is all transactions for one-off orders, I am trying to link the three tables dbo.Name, dbo.Invoice, dbo.Trans and dbo.Orders. For the second part, which is transactions from repeating subscriptions, I am trying to link the three tables dbo.Name, dbo.Subscriptions and dbo.Trans. Neither seem to give anything like the same results as the iMIS front end, so I guess I haven't linked the tables right. I also tried to find out how the built-in Crystal reports link the tables, but I couldn't work it out. Does anyone know how these tables link together? Thanks for any help you can give.