delete sales card in schedule Job

huungan040390

Dear all expert,

I want delete all Sales Order in every 2 AM morning if Requested Delivery Date < TODAY
who can help me how to resolve this problem ?

Thanks & Best Regards !

mohana_cse06

What if the Order is partially/fully shipped/invoiced?

huungan040390

Just one condition is Requested Delivery Date < TODAY

mohana_cse06

Nav wont allow you do delete orders which are shipped and not invoiced..

did you try manually deleting first?

It will throw error message that

Qty. Shipped Not Invoiced must be 0 in Sales Line Document Type='Order',Document No.='1001',Line No.='10000'.

huungan040390

Oke, If I delete sales order which 3 conditions is : not ship + invoiced + Requested Delivery Date < TODAY.
Can you let me know how to do this problem ?

Thanks & Best Regards !

mohana_cse06

You have to develop a report/codeunit to delete the Orders based on your conditions and run it through NAS

huungan040390

Can you help me step by step, please ?, i can not imagine about it.

mohana_cse06

huungan040390 wrote:

Can you help me step by step, please ?, i can not imagine about it.

Sorry.. forum is to help you if you are getting any problems in your process.. not to explain step by step..

please refer report 299 - Delete Invoiced Sales Orders (dont run it - it will delete orders which are completely invoiced)

ssingla

huungan040390 wrote:

Can you help me step by step, please ?, i can not imagine about it.

This will help you.....
http://mibuso.com/howtoinfo.asp?FileID=15

Zephyr

You can create a report in which you can use (as per your requirement)

SORTING(Document Type,No.) WHERE(Document Type=CONST(Order),Completely Shipped=FILTER(No))

and

Delete(true);


It'll help you.

huungan040390

Dear you,

I want delete Sales Order card automatically because I want delete Sales Order which has reservation quantity. If i delete Sales Order which has reservation quantity, so in Bin Content will has enough quantity to sell.

If i delete Sales Order card, it will affect other table or not affect. And if affect, what related table should i delete ?

Thanks & Best Regards !

mohana_cse06

Did you check the report which I told you?

huungan040390

Dear mohana,

I read report 299, I may be understand about 70%.
So, If I want to add 1 condition which is Requested Delivery Date < TODAY => what need i do ?

Thanks & Best Regards !

mohana_cse06

I think you are not a technical person with enough experience to do this task..

Please contact your seniors or partner(if you are a customer) as it is related to deleting the data..

If something goes wrong then you will be thrown out..

huungan040390

Dear mohana,

I reasearching Navision 2009 about 2 months, so i have poor expirence.
I created 1 job in SQL Agent Server for deleting sales order automatically 2 weeks ago, and it was wrong, because not enought related table, but in TEST Database .
You are senior/rich experience about Navision, can you let me know how to do that if i have 1 condition same above reply.

Thanks & Best Regards !

mohana_cse06

The condition you need to write is
"Sales Header".SETFILTER("Requested Delivery Date",'<%1',TODAY);
in Sales Header OnPredataItem trigger..

huungan040390

Dear mohana,

What line is represent a invoiced order in report 299 ?, and if i delete that line, Will be it not invoiced order ?
Because i think that i can delete any order manually.

Thanks & Best Regards !

mohana_cse06

Sorry..I didnt get your question..

huungan040390

Which code will represent for Invoiced Sales Order in report 299 ?

huungan040390

Hi mohana,

Thanks mohana very much, but I can not resolve that problem.

Thanks & Best Regards !

Luc_VanDyck

huungan040390 wrote:

What line is represent a invoiced order in report 299 ?, and if i delete that line, Will be it not invoiced order ?

The property DataItemTableView on the Sales Header dataitem does the filtering for Sales Header records of type Order: "SORTING(Document Type,No.) WHERE(Document Type=CONST(Order))". The C/AL Code in the OnAfterGetRecord-trigger loops through all Sales Order Lines, and deletes the ones which are completely shipped and invoiced. If all lines of a Sales Order are deleted, then the Sales Header is also deleted.