Note: it is not recommend by SAP to manually change system table fields value but besides use Diapi or Service layer to resend those emails, this is the only way to do that for customers.

SAP Business One SBO Resend Emails

SAP Business One SBO Resend Emails

For some reason, SMTP server could reject those Email you sent by using SBO Mail service. Those Email will be saved in sent queue but with the status "Error". If Cusotmer want you to resend them when the SMTP server back to normal, here's the method.

update ALR1 set Status = 'U' where Code = '9257'                            ALR1 is the queue of messages to be sent table (OALR is the message detail information table)
update OAOB set WasSent = 'N' where AlertCode = '9257'             Both OAOB and AOB1 are message sent tables
update AOB1 set Confirmed2 = 'N' where AlertCode = '9257'
update AOB1 set ConfDate2 = null where AlertCode = '9257'
update AOB1 set ConfTime2 = null where AlertCode = '9257'

All those Messages will have a Code or AlertCode in database, please check it to match your record in B1 with AOB1 or ALR1 table. 

You dont have to restart the SBO Mail server. The SBO Mail server will check those fields when the time is up and send those Emails in the queue again.

To check if the Email is resend or not, use the following query

select * from AOB1 where AlertCode = '9257'

If  "Confirmed2" = 'Y', the Email is successful sent. If "E", please check SBO Mailer server - event viewer - Windows Logs - Application for troubleshooting.

SAP Business One SBO Resend Emails

If you need assistance, feel free to contact us.

Contact Us

by MTC Systems on Aug 5, 2016 10:26:20 AM

Leave a comment

Related posts

No Restriction When Setting Revenue Accounts in SAP

SAP Business One is designed to fit all types of businesses. For example, usually we set the revenue accounts of a business as...

MTC Systems
By MTC Systems - November 14, 2017
Tips When Reading Forms in SAP Business One

It can be inconvenient when you company receives a document with a long list of items. Finding a specific item can also be...

MTC Systems
By MTC Systems - November 10, 2017
Tracking the Inventory Counting in SAP Business One

Inventory is an important direction of most of the manufactural companies. Inventory counting and tracking can be helpful in...

MTC Systems
By MTC Systems - February 2, 2017