Send Email Then Delete Order - E-ship Used

Savatage

I would like a report that runs thru some "selected" orders - sends a "Sales Confirmation Email"
then deletes the order.

The email is easily sent but I cannot delete the order. Apparently when the email is sent a field
called E-Mail Notification Handled (boolean) is update. So when I go to delete the order it says

"Another user has modified this Sales Header after you have retrieved it from the database"
"Enter your changes again in the updated window, or start the interupped activity again"
"Identification Fields & Values"
Document Type='Order',No.='1234567'

OnAfterGetRecord()
SendNotificationEmail;
DeleteOrder;

SendNotificationEmail()
emailmgt.SendSalesConfirmation("Sales Header",TRUE);

DeleteOrder()
"Sales Header".DELETE;

Anyways around this? I would like to mass notify & delete selected orders that we will not ship. doing 100's one at a time sucks. I guess I could call another report that does the deleting :-k

Alex_Chow

You could break the processes into 2 steps. Send the e-mails first then another process to delete it.

Savatage

yea it looks like i need to run or runmodal a deletion report.

I'll mark it as solved because that does work. Hate to use two report up

Alex_Chow

Savatage wrote:

yea it looks like i need to run or runmodal a deletion report.

I'll mark it as solved because that does work. Hate to use two report up

A pack of 100 report is very economical considering what you're getting out of Navision.

garak

is

SendNotificationEmail()
emailmgt.SendSalesConfirmation("Sales Header",TRUE);

CallbyValue or CallbyReference (Flag VAR)?

SigGunn

I think changing the DeleteOrder function to

DeleteOrder()
"Sales Header".GET("Sales Header"."Document Type","Sales Header"."No.");
"Sales Header".DELETE;

is the way to go.

Savatage

your right - here's the final

OnAfterGetRecord()
SendNotificationEmail;
DeleteOrder;

OnPostDataItem()

SendNotificationEmail()
EMailMgt.SendSalesConfirmation("Sales Header",TRUE);

DeleteOrder()
"Sales Header".LOCKTABLE;
"Sales Header".GET("Sales Header"."Document Type","Sales Header"."No.");
"Sales Header".DELETE;

Savatage

Ouch just realized it just deletes the Header & Leaves the LINES!!!!!

garak

"Sales Header".DELETE; <- this delete only the Header, not the lines, not the dimensions, not the comments, and so on.

I was wondering why you doesn't make a "Sales Header".delete(true);, but i didn't say anything because i thought it was not the whole code (sorry) and you delete the other tables some lines later ....

Regards
René

Savatage

Yea - over looked it. not a problem

create a boolean in the sales line table - if header exists, took 2 seconds.
Selected all that said no & & deleted them - then removed the field.

Thanks for your input!

garak

there are no Dimensions for the header or comments or other related tables?

Savatage

no

DaveT

Hi Harry,

Just for future reference, if you use "Sales Header".DELETE( TRUE ); -it will run the code in the ondelete trigger of the sales header table which delete the sales lines and all depending tables.

Savatage

yeah I know , slipped my mind - that's what happens when you rush at the end of the day :oops: