To delete items there is a special menu. (36.25.10, ppptmt05.p)

Be carefull, it is a very powerfull menu! Check the system help.

 

Hi Raymond,

Thanks very much for this very quick response.

Luckily I have a test environment where I can play around, so I guess I'll find out how to work with this.

Kind regards,

Edward

This program still goes through all the checks just like if you did the delete yourself using 1.4.1.  So if there is any inventory, or the part is attached to a BOM or there are open PO's or SO's or WO's etc that use this part it will infact not delete the part and tell you why.  Unfortunately it creates the message for the first error it finds so you may have to run this multiple times fixing the issue that it shows until it finally allows you to delete the part

Okay, no time to try it yet, but that's not a problem.

I just was searching for a way to get rid of the items while still using the mfg logic. I already have a query with which I inventory with which tables an item still has relations. If it finds no relations it is stated that the item can be deleted.

That was going to be my next suggestion LOL.  I created a program a few years ago to do all the testing.  It is surprising just how many tables can affect the deletion.

Another option is if the program has the batch delete enabled.   To check this just go into the program and press ctrlF you will see a line that says "Batch Delete = YES".  If this is the case then you can create a CIM file to do the delete without special programs.

You just need to put a "X" at the end of the record selection screen.  You can get more details on the knowledge base but you CIM should look something like:

@@batchload ppptmt04.p
"910055" "X"
@@end

Thanks for that additional info.

I already tried that, but at the wrong menu option. I didn't know there was a special delete menu, so I tried the X towards 1.4.1 and that didn't succeed. Now I know the correct screen and your example, I guess it's hard not to succeed.

Unfortunately I don't succeed.

When I press Ctrl+F in 36.25.10/ppptmt05, I get this information, without a "Batch Delete"-line :

When I try to create a cim for ppptmt05 through qtcrcim.p, the screen of ppptmt05 opens but when I select an item en press F2, the following errors appear :

Any ideas how to solve this?

That is because ppptmt05.p is a special program already designed to do the delete without the batch delete program.

Your program would just look like:

@@batchload ppptmt05.p
"910055" YES
@@end

Thanks for helping but all attempts still have no results.

I've just searched QAD's knowledbase and end up with the conclusion that our version of the ppptmt05.p needs a fix. We're running the file M:\MFG90\MFG\SRC\PROD\09_QAD\xrc\ppptmt05.p (28-03-2001 16.59).

Due to the findings I've just submitted an incident at QAD for help and/or a fix of the program.

Thanks for the help anyway.