Home | Logon | Contact | Newsletters | Search:- 

MAILPAC Common Issues and Solutions - Pre SDK

MAILPAC Issues & Solutions

Using Mailpac 6.1 with Gmail

When using Mailpac 6.1 with Gmail, the following settings apply:

SMTP Use SSL – Yes
SMTP Server – smtp.gmail.com
SMTP User ID – your Gmail user e.g. bob@gmail.com
SMTP password - Your Gmail user password
SMTP Port – 587 (or 465)

Error: Print engine not opened

This error occurs when emailing from MAILPAC.

This issue solution only applies to MAILPAC 5.5 and 5.6 when using Outlook 2007 with Windows 7 or Windows 2008 R2.

The solution is to install Accpac Hot Fix 28947 dated 12th May 2010.

Using POPOR04 and OEINV04 with Mailpac 5.5 and above

MAILPAC is designed and tested for use with POPOR01.rpt (datapipe) not POPOR04.RPT (odbc), however you can modify your report based on POPOR04 to operate with MAILPAC. (The same principal applies to OEINV04.RPT and similar changes can be made to it for use with MAILPAC).

The standard version should still be used if printing direct from purchase orders.

Change the Crystal report selection criteria (Report-SelectionFormula-Record) to comment out some lines as highlighted in orange.

These lines refer to delivery method which MAILPAC handles itself and so are not required when printing via MAILPAC.

//Selection Criteria Query String now build in UI and passed into @SELECTION_CRITERIA

if {?SWDELMETHOD} = "1" then //Selection partly done in UI - sortto and sortfrom is the same
(    
{POPORL.COMPLETION}=1 and 
{POPORH1.PONUMBER} = {?PORFROM}) //and 
//(({POPORL.STPRINT}=0) OR (ToNumber({?DPRINTED})=1))
//)
else // No selection in UI
(
{POPORL.COMPLETION}=1

AND ( (({POPORH1.PORTYPE} = 1) AND (ToNumber({?ACTIVE})=1)) 
OR (({POPORH1.PORTYPE} = 2) AND (ToNumber({?STANDING})=1)) 
OR (({POPORH1.PORTYPE} = 3) AND (ToNumber({?FUTURE})=1)) 
OR (({POPORH1.PORTYPE} = 4) AND (ToNumber({?BLANKET})=1)) )

AND ({POPORH1.ISPRINTED}=0 OR ToNumber({?PRINTED})=1) 
AND ({POPORH1.PONUMBER} >= {?PORFROM}) 
AND ({POPORH1.PONUMBER} <= {?PORTO}) 
AND (({POPORL.STPRINT}=0) OR (ToNumber({?DPRINTED})=1)) 
AND ({POPORH1.ONHOLD} = 0) //and 
// if delivery method is 3, always select vendor 
// else select vendors that have delivery method of mail 
//( 
// {?SWDELMETHOD} = "3" or 
// ( 
// {?SWDELMETHOD} = "2" 
// and 
// {APVEN.DELMETHOD} = 0 
// )
//)
)

Print Destination may need to be reset

When upgrading MAILPAC, the Accpac print settings may need to be reset.

This issue presents as MAILPAC asking for an email file format when sending documents. 

To reset go into Print Setup in Accpac, choose Print Destination as Email with Adobe Acrobat (PDF)  as the email file format, then click OK and close Print Setup.

This will reset the user's Accpac email settings.  You can now reopen Print Setup and set your Print Destination as it usually is e.g Printer, Preview etc. 

You will need to reset settings for each Accpac user in turn.

Incorrect email subject and message

This issue solution only applies to MAILPAC 5.6

When more than one document in a MAILPAC delivery run had a destination of email, all email subjects and messages would be the same i.e. they would contain incorrect customer or vendor substitution values as per the first email recipient.

The solution is to install MAILPAC Hotfix dated 29/04/2010.

Invalid tlv record error message

This can have a couple of causes:

1) MAILPAC successfully sends/prints the first few documents of the batch (eg 20 documents) but then every subsequent document fails with an error such as "Invalid tlv record". However, the standard report provided with MAILPAC runs successfully.

This can occur if the report file being processed is too large. For example, placing a high resolution company logo into the apremitp.rpt report can make the apremitp.rpt very large in size (eg > 1MB), causing the error to occur. It appears the error is either RAM, printer or email software memory related. The solution is to reduce the size of the crystal report file by saving the image in a different format (or with lower resolution). An easy way to do this is to copy the image into Microsoft Paint and save the image as a jpg file. This should cut down the size considerably. Then insert the new image into the report and try again, checking that the crystal report file size has descreased satisfactorily.

2) Has been known to occur when the Outlook security prompt window was waiting for the user to respond, however the prompt is showing in the background and is hidden behind the Outlook Window and did not have the focus. The solution is to install ClickYes to automatically click the Outlook prompt for you. Please click on the "Mailpac Outlook Security" link to the left of this page for further information on ClickYes.

Error: Unable to connect: incorrect log on parameters

Has been fixed in v5.5. This error can occur when running a report from MAILPAC.

If using v5.4 and the error occurs running the MAILPAC options or Document Type reports, install the latest MAILPAC service pack.

If it occurs using the AP remit reports, please contact Modulo Software to receive an updated v5.4 report.

Cannot use MAILPAC v5.4 with Purchase Orders 5.3

This issue has been corrected in the latest service pack.

Order Entry Invoices slow to load.

On large Databases, the Process Documents screen can be very slow to load when choosing Order Entry Invoices. This is an issue with both v5.3A and v5.4.

The solution is to install the latest service pack for v5.3 or v5.4, as applicable.

How can I send a document to multiple recipients?

To send to multiple recipients, you can simply enter the email addresses into the email address field, separated by a semi-colon (;). However, this only works if the total number of characters in the email addresses is 50 or less (ie the total characters permitted by the email field). If your email software supports it, one way to work around this limitation is to use Distribution lists. Using your email software (such as Microsoft Outlook), create a distribution list and add the relevant email addresses to the list. Then in Accpac enter the distribution list into the email address field. Then when MAILPAC sends the email, the name of the distribution list will appear in the email "To" field, and your email software should send the email to each address in the list.

Duplicate lines in Remittance Advice

This issue can be caused if an error batch occurred when generating an invoice batch. The MAILPAC apremitp report links to the APIBH table. In the case that an error batch has occurred, there are two entries added to the APIBH table, both with the same vendor and invoice number. Then when the apremitp report links to this table to obtain the invoice data two records are returned, hence duplicate lines appearing on the remittance advice.

Note: It has also been reported that this issue can occur when entering the same check number for different vendors (eg if entering a dummy check number such as 1)

One solution is to edit the report with Crystal and add the highlighted line to the Record Selection Formula. This solution applies only for apremitp.rpt and apremitpeft.rpt in Eftpac versions 5.5 through to 6.0 The datapipe version apremitpipe.eft can’t use this solution as it doesn’t include the APIBH.ERRBATCH field.  

The above solution is only applicable if a customised report has already been created.

For new standard reports, the solution is to install MAILPAC Hotfix (v5.5, 5.6 and 6.0) dated 29th November 2011.  

MAILPAC error after some documents sent successfully

MAILPAC successfully sends/prints the first few documents of the batch (eg 20 documents) but then every subsequent document fails with an error such as "object ~ of ~ failed". However, the standard report provided with MAILPAC runs successfully.

This can occur if the report file being processed is too large. For example, placing a high resolution company logo into the apremitp.rpt report can make the apremitp.rpt very large in size (eg > 1MB), causing the error to occur. It appears the error is either RAM, printer or email software memory related. The solution is to reduce the size of the crystal report file by saving the image in a different format (or with lower resolution). An easy way to do this is to copy the image into Microsoft Paint and save the image as a jpg file. This should cut down the size considerably. Then insert the new image into the report and try again, checking that the crystal report file size has descreased satisfactorily.

Crystal Formula Error
A string can be at most 254 characters long

This issue has been fixed in MAILPAC v5.4

Generally occurs in a datapipe report (eg APREMITPIPE.rpt), in the vendor address formula when more than one vendor address line is used for a particular vendor. Solution is to open the vendor address formula and make sure that each field has TRIM() around it, or you can copy the following code into the formula:

(If Trim({APREMITP.APTCR_NAMERMIT}) <> ""
Then Trim({APREMITP.APTCR_NAMERMIT}) + Chr(13)+Chr(10) Else "") +

(If Trim({APREMITP.APTCR_TEXTSTRE1}) <> ""
Then Trim({APREMITP.APTCR_TEXTSTRE1}) + Chr(13)+Chr(10) Else "") +

(If Trim({APREMITP.APTCR_TEXTSTRE2}) <> ""
Then Trim({APREMITP.APTCR_TEXTSTRE2}) + Chr(13)+Chr(10) Else "") +

(If Trim({APREMITP.APTCR_TEXTSTRE3}) <> ""
Then Trim({APREMITP.APTCR_TEXTSTRE3}) + Chr(13)+Chr(10) Else "") +

(If Trim({APREMITP.APTCR_TEXTSTRE4}) <> ""
Then Trim({APREMITP.APTCR_TEXTSTRE4}) + Chr(13)+Chr(10) Else "") +

(If (Trim({APREMITP.APTCR_NAMECITY}) = "" and Trim({APREMITP.APTCR_CODESTTE}) = "") then ""
Else Trim({APREMITP.APTCR_NAMECITY}) +
(If Trim({APREMITP.APTCR_CODESTTE}) <> "" Then " " + Trim({APREMITP.APTCR_CODESTTE}) + Chr(13)+Chr(10) Else Chr(13)+Chr(10))
) +

(If Trim({APREMITP.APTCR_CODEPSTL}) <> ""
Then Trim({APREMITP.APTCR_CODEPSTL}) + Chr(13)+Chr(10)+ Chr(13)+Chr(10) Else "") +

(If Trim({APREMITP.APVEN_NAMECTAC}) <> ""
Then "Contact: " + Trim({APREMITP.APVEN_NAMECTAC}) + Chr(13)+Chr(10)) +

(If Trim({APREMITP.APVEN_TEXTPHON2}) <> ""
Then "Fax: " + Trim({APREMITP.APVEN_TEXTPHON2}) Else "")

 

Some Order Entry Invoice Reports are blank
(OEINV04.rpt and OEINV05.rpt)

This issue has been fixed in MAILPAC v5.4

This has to do with the report selection criteria.  If you are using MAILPAC v5.3 or v5.3A, make a copy of the report and rename it (eg OEINV04Mailpac.rpt).  Replace the Report Selection Criteria with the code below (by choosine Reports, Edit Selection Criteria, Record).  Save the report.  Open MAILPAC and choose the newly created report and run the report.

{OEINVH.INVNUMBER} >= {?SORTFROM} AND
{OEINVH.INVNUMBER} <= {?SORTTO} AND
(
{?PRINTED} = "1" OR ({?PRINTED} = "0" AND{OEINVH.INVPRINTED} = 0)
)

Error 2 - licence file does not exist

Occurs when trying to activate MAILPAC using the Options form.  You will receive this error if you are using MAILPAC v5.3A with Accpac System Manager 5.3B.  Install the latest MAILPAC v5.3A service pack.

This issue has been fixed in v5.4.

Error 1000 - File not created or found

May occur because Accpac cannot export pdfs.  Try emailing a standard Accpac report as a pdf.  If this doesn't work, then there is an Accpac issue with crystal and pdfs.  Once you are able to email pdfs from Accpac, then MAILPAC should work as well.

Recipients receive a file attachment winmail.dat

Happens when using Outlook (not Outlook Express) to send emails to people using non Outlook email software. Refer to articles Q197064 and Q138053 on www.microsoft.com Alternately consider setting up MAILPAC to send attachments as PDF format instead of RTF.

Error 2147467259 is reported in the MAILPAC log file.

This is a common error number and could be caused by a number of things:
  • If this occurs with any of the standard MAILPAC reports (eg apremitp.rpt etc), make sure that you have copied the file from the reports directory under your MAILPAC directory to your :\program files\accpac\ap(VERSION)a\eng directory.
  • If this occurs when emailing but not when printing a report, check that:
         (i) Accpac can print to your email software,
         (ii) Your default email program is set correctly in Internet Explorer under Tools-Internet Options-Programs-Email
         (iii) Check that crystal is able to export to pdfs.  To do this, run the MAILPAC report to preview, then select the export button and choose to export the report to pdf.  If the pdf option is not there, or you cannot export to pdf successfully then this is causing the MAILPAC error.  If you have crystal installed then either re-install it, or make sure that the crxf_pdf.dll is in your windows\system32 directory (on in the user profile if a terminal server), if possible copying it from another machine that is working.
  • Only occurs with some users but not others on a terminal server.  This is most likely a crystal installation issue.  Please see point (iii) above and make sure the correct crystal files are in the user's profile.
  • Occurs when printing to printer but does not occur when “Preview documents before printing” option is selected. This happens when the default Accpac printer setting for the user who is logged into MAILPAC does not exist on the machine running MAILPAC. Solution is to use separate Accpac users for each MAILPAC workstation. Can also be resolved by renaming the ??????_p.ism file (where ?????? is the Accpac company ID) in the \user\ directory. Note this last option will reset all Accpac printer settings for all Accpac reports for that user.
Modulo Software