MaxQ Technologies Community Server

MaxQ's Knowledge Base & Product Release Information

MaxQ Technologies Community Server
Welcome to MaxQ Technologies Community Server Sign in | Join | Help
in Search

Stefan Nachev's Blog

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

    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?

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

    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

    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

    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

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

    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

    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

    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

    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

    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

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

    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

    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
More Posts Next page »

This Blog

Post Calendar

<September 2010>
SuMoTuWeThFrSa
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789
Powered by Community Server, by Telligent Systems