Stefan Nachev's Blog

Can APAPR Laser Checks for SL print checks or check copies to a PDF?

2009-11-20T17:54:00Z

The actual printer can be configured to do that. Then when checks or check copies are printed, if the printer has been configured so, it will create a PDF file instead of printing to paper.

In APPR Laser Checks for SL - Do check copies print as the checks are printed or is there a separate process which does that?

2009-11-20T17:50:00Z

There is an option to have the application print copies automatically right after the actual checks print. There is also an option to print copies at a later point, whenever the user needs to do that (there is a special screen for that purpose).

Charge It Object info.....

2009-11-18T21:10:00Z

The chargeIT object uses constants to generate various error messages. The constants are defined as:

Private Const vbObjectError = -2147221504

Private Const kERROR_DATA = 1

Private Const kERROR_PCCHARGE = 2

Private Const kERROR_MAINTMODE = 3

Private Const kERROR_BATCLOSE = 4

Private Const kERROR_INVALIDCARD = 5

Private Const kERROR_INVALIDEXPDATE = 6

The message that are raised are as per below: Err.Raise kERROR_DATA + vbObjectError, "Add Transaction", "Cannot charge a counter sale in AR."

Err.Raise kERROR_DATA + vbObjectError, "XCCTran.Save", "Must enter all key fields to before saving."

Err.Raise kERROR_DATA + vbObjectError, "XCCTran.Save", "Field data invalid. Cannot save at this time. " & sResults

Err.Raise kERROR_DATA + vbObjectError, "Submit_Card", "Incomplete data for processing transaction. " & sResults

Err.Raise kERROR_PCCHARGE + vbObjectError, "Submit_Card", "Error Transaction Processing Software not Running"

Err.Raise kERROR_MAINTMODE + vbObjectError, "Submit_Card", "CEP Charge It! is in maintenance mode. You cannot process transactions at this time. Please try again later."

Err.Raise kERROR_BATCLOSE + vbObjectError, "Batch Close in progress. Please try again later."

Err.Raise kERROR_INVALIDCARD + vbObjectError, "CardNbr", "Attempting to set card number to an invalid credit card."

Err.Raise kERROR_INVALIDEXPDATE + vbObjectError, "ExpDate", "Attempting to set expiration date to an invalid date."

The client application (your ASP page) will see the above errors with various numbers as below:

kERROR_DATA + vbObjectError = -2147221503

kERROR_PCCHARGE + vbObjectError = -2147221502

kERROR_MAINTMODE + vbObjectError = -2147221501

kERROR_BATCLOSE + vbObjectError = -2147221500

kERROR_INVALIDCARD + vbObjectError = -2147221499

kERROR_INVALIDEXPDATE + vbObjectError = -2147221498

In other words, if you get an error with number -2147221503, the error message could be "Cannot charge a counter sale in AR." or "Must enter all key fields to before saving.", "Field data invalid. Cannot save at this time. " , "Incomplete data for processing transaction. "

MaxQ AP and Payroll Laser Checks for Dynamics GP (with Crystal Reports) now available

2009-07-29T20:02:00Z

MaxQ APPR Laser Checks for Dynamics GP (with Crystal Reports) is now available. Please contact MaxQ for additional information - sales@maxqtech.com; support@maxqtech.com

MaxQ Document Agent now supports Site level contacts for sending Purchase Orders

2009-04-23T20:56:00Z

MaxQ Document Agent now supports Site level contacts for sending Purchase Orders. For details please contact MaxQ support.

MaxQ Charge It support for PCCharge Payment Server v5.8.0

2009-03-18T17:52:00Z

MaxQ Charge It support for PCCharge Payment Server v5.8.0.

PCCharge Payment Server v5.8.0 is now available and supported by MaxQ Charge It for PCCharge.

Attached is a file outlining important information regarding this new PCCharge version.

2009 Rate and Zone information for UPS and Fedex is now available for MaxQ Freight and MaxQ Worldship Link

2009-01-08T23:08:00Z

2009 Rate and Zone information for UPS and Fedex is now available for MaxQ Freight and MaxQ Worldship Link.

These updates are available for Dynamics SL 6, 6.5 and 7.

In order to obtain the necessary files please contact our support desk at support@maxqtech.com.

BI: Add Advanced Functionality to Your Matrix Reports by Using the INSCOPE Function

2008-12-08T17:16:00Z

A Matrix report is a powerful tool for delivering complicated statistical reports to your users. Often your data will not have a static number of rows and columns which may make grouping and subtotaling a challenge. Fortunately, Reporting Services has an answer for you. It’s the Matrix control.

With the matrix control you can create a report with a dynamic number of rows and columns and any number of row and column groups in a jiffy. Also, with just a few clicks you can generate group totals at any level. Like all reporting tools there are some limitations. One common reporting need, that becomes a major challenge, is calculating group averages rather than group totals. Although this sounds fairly trivial it requires that your tool allows you to use nested aggregates in your calculations, which Reporting Services 2005 does not.

Figure 1 illustrates the results that you get if you attempt to use the Avg() function. Notice that the Average of the Total line is not correct. Fortunately, there is a workaround. With a bit of code and an understanding of the way that Reporting Services evaluates the various row and column groups in your matrix report, you can add many advanced calculations to your reports. To understand when the matrix group totals are being evaluated and when they are not, you must use the Inscope() function. This function returns true or false and takes a group name as an input parameter.

Figure 2 illustrates the scope of each row and column group as each cell of the matrix is evaluated. Notice that when the column total is being evaluated the column group {Month} is out of scope and when the row total is being evaluated the row group {Division} is out of scope. Also, notice that when the grand total is being evaluated, both the row and column group are out of scope.

Now that you understand when each group total is being evaluated, you must add a custom function to calculate your average or whatever calculation you desire. In this example, there are four different scopes which the function must handle. The function uses the Scope of each group to determine when the column/row cell, subtotal, average, and the average of the subtotals is being evaluated. The custom function for the first two cases simply returns the aggregate value passed in i.e. Sum(amt). The third case will maintain two variables. The first is a running total, the second will be a count of the number of values added to the total. In addition, the function will return the subtotal value. The fourth case will calculate and return the average, and reset the running total and count variables. The call into your custom function from the data cell in the matrix report would look like this.
=Code.SumOrAvg(Sum(Fields!Amt.Value),AVG(Fields!Amt.Value), InScope("GRP_Month1"), InScope("GRP_Division1"))

Figure 3 illustrates our matrix report with the correct average value being calculated for every row of the matrix report.
As you can see from this example, the Inscope() function gives you the power to control the values in every cell of your matrix control. Happy Reporting !!!

Source Code is attached to this blog entry. Please see the attachment below...

Using MaxQ APPR Laser Checks for Dynamics SL when the Usr_Rpts folder is not in the SL application directory

2008-03-24T18:53:00Z

Environment:

-All versions of Dynamics SL (Solomon) using AP/PR Checks

-Multiple SL Application Servers

-Centrally located Usr_Rpts folder is shared between the application servers

Issue:

-Bitmaps won’t print because the links become broken after the folder relocation

Workaround:

-Point the links found in the Crystal reports to the XL folder on ONE of the SL application servers.

Solomon Process Engine fails to process Sales Order type transactions due to a lower case 'D' in the XML message

2008-02-20T22:11:00Z

The MaxQ Solomon Process Engine will error on Sales Order type transactions if the 'D' in the 'CompanyID' tag is a lower case 'd'.

2008 Rate and Zone Import data for MaxQ Freight Manifesting and MaxQ Freight Worldship Link is now available

2008-02-13T23:20:00Z

In order to obtain the new zone/rate import files, you need to be on a current product support agreement with MaxQ.
If you do have such an agreement in place please contact MaxQ at 203-840-8930 x225.

Getting message 'Operation Failed' in MaxQ Document Agent

2008-02-13T20:29:00Z

If using a Terminal server, the reason for this error may be the following:

When you connect to a terminal server, by default, the printers attached to your workstation are “mapped” into the terminal services session . This applies to fax printers as well.

The cause of the “operation failed” messages seems to be that when someone with a fax printer defined on their own computer connects to the Terminal server, there will be two fax printers defined and this will cause the error.

Also there doesn’t seem to be a way to programmatically select a fax printer through the objects exposed by Microsoft at this time.

The work-around is to disable Windows printer mapping on the Terminal server. This can be done through the Terminal Services Configuration program located in Administrative Tools.

MaxQ Document Agent, Dynamics SL Process Engine and Deposit Processing for Dynamics SL v7 are now released

2008-02-13T17:15:00Z

In order to obtain these new releases please contact MaxQ at 203-840-8930 x225.

ACA deduction screens populate grid with incorrect values when using the 'CM Search screen'.

2008-02-10T17:34:00Z

This is ACA bug 4088.
Example:

1. Enter new ACA batch - select customer, then click 'Check Deductions' 
- when prompted to save, save the batch.
2. On the 'Check Deductions' screen enter a deduction on the first row
(approved or unapproved).
3. Click on the 'CM Search' button, save when prompted. Run 
the search and select 2-3 CM/s from the ones that are returned. 
Click 'OK' to bring them back in the grid.
4. The CM/s will come back in the grid, however these new 
'reapplication' lines will have the deduction code of the deduction 
on the first line, as well as the Account and Subaccount values.

The fix can be downloaded here:

http://maxqtech.com/CS/forums/thread/3597.aspx

SQL Server Message 10215 Invalid object name dbo.XMaxQ_RoundRandom

2008-02-08T00:36:00Z

May get this error if using MaxQ Freight Manifesting v7.2.0
or MaxQ Freight Worldship Link v7.1.0 for Dynamics SL v6x.

Download the fix for Freight Manifesting from here:
http://maxqtech.com/CS/forums/thread/3594.aspx

Download the fix for WS Link from here:
http://maxqtech.com/CS/forums/thread/3595.aspx