halvorn
29th January 2002, 10:58
In session tipcs2102m000 Maintain Project Status:

When changing Project Status From Active to Finished I get the message "There are still actual sales orders".

I have looked in tdsls045 (sales order line status) and everything seems Processed,

Does anybody know where (which table and field) Baan looks at to know that "There are still actual sales orders".
The message appear at once when the save button is pressed, so I guess it can't be tdsls045,tdsls041,tdsls051 which are large tables.

Thanks.

Kees de Jong
29th January 2002, 11:52
The message "Note: actual sales orders already present" (tipcs2101j) is returned when a sales order is found for the project you try to close.

Actual sales orders can be found in table tdsls041. You can verify which order(s) are causing the problem by searching this table using index 4 with the project code. This is exactly the way in which the application is working.

halvorn
29th January 2002, 12:24
Thanks,
Yes I have done this,
And found that only One order uses the Project.
This order has 24 lines, which I have checked that all have the Status "Processed delivered Sales Order" in tdsls045.

And the necessary Order steps is performed regarding tdsls045 or session tdsls4533m000.

Kees de Jong
29th January 2002, 14:18
I looked into the wrong project status. I looked at the wrong message code. I am very sorry. The check on tdsls041 is only executed when changing the project status to “free”.

When you try to change the status to “finished” (or “cancelled”) a check is done on tdsls045! Checked is whether the Sales Invoice (tdsls4404m000) is printed. The procedure mask for this session must show “e”. If the check fails, another message is returned: “There are still actual sales orders” (tipcs2101a).

Recently a solution was created for a problem, in which it was not possible to finish a project when backorder lines were present in sales. Solution number is: 120716.

I only mention the checks on sales order lines, as this is where you have your question. Of course all other order types are checked as well.

halvorn
29th January 2002, 14:49
Hi,
I could not find this solution at Baan supports Knowledge Base.

Juergen
29th January 2002, 16:39
I guess you are runninn IVc4.

If so please check if you have installed solution 116497.
Thats the latest solution (dated 2001-07-20) for the library tipcsdll2102 that will do the relevant checks to close the project.

Juergen

Kees de Jong
29th January 2002, 18:29
You are right that it was not possible to find solution 120716. I verifed at Support and the status was not correct. They adapted it and now you should be able to find this solution in the Knowledge Base.

In fact solution 120716 is the latest solution on the library tipcsdll2102. It is dated December 11, 2001.

ulrich.fuchs
30th January 2002, 09:11
It's not a bug, it's a feature!

Halvorn,
did you process delivered sales orders (tdsls4223m000)?

Sales order line status must be "to delete" or something like this (I just know the German term "Position löschen".) If it's still on "processed delivered sales orders" then that step is not yet performed and the project may not be finished.


Yours,
Uli

halvorn
30th January 2002, 09:56
Thank you Baan5user,
120716 solved the problem. I was able to download it with PMC, even if it was not available in the search engine.