Query

[Former Member]

hi

i have a udf field Shift . i want a query that Sale orders entered on 14th in a particular shift also exists in the next date & shift . If there is missing S.O i should be able to get those Sales Order.

Thanks

[Former Member]

Closed.

[Former Member]

Hi,

Your question is not very clear. Give an example to show.

Thanks,

Gordon

[Former Member]

Hi

Suppose i created 2 Sales Order on 13th with shift 'M' . Then i run Program developed through SDk which copies these 2 records for the next day i.e 14th , same shift . I want query that it should verify that given above example all these 2 Sales Orders have been created for the next day. If 1 is not copied then it should display.

Thanks

[Former Member]

mmm look odd

but i think you should use a user field like "copied" , then whenever you copy the SO you need to update the field "copied"

then your query just need to see if "copied" is null...

I dont know if I get your question but I hope this can help

[kvbalakumar]

Hi Saini,

I also agree with Christian.

Better use an additional udf in SO with valid values of 1.Not copied and 2.Copied.

Set the default value as "Not copied" and while copying through SDK just update the same field to "Copied".

Then it's easier to write a query where the udf is "Not copied" to get the list of non-copied SO.

Regards,

Bala