How can I archive production order for customized item (on order)?
Standard session allows archive production orders only for standard items(anonymous).

Thanks

Maurice

Production orders, which are related to a project are archived together with the project. The session "Archive Projects" (tipcs2260m000) archives most project related data (production orders, integration transations etc.). So, that's the session you'll have to run.

Karin

I've doing the same thing with projects/prod orders and receiving an error message that a reference exists for aprod order 'TO tisfc001 FROM tisfc010' (production order table tisfc001 - production planning by order table tisfc010). I've run some other sessions that clear up orders, process delivered purchase orders and purchase statistics and still receive this error. Does anyone have any other ideas?

Thanks,

-Tim

When a production order is closed, the production planning in tisfc010 should not exist anymore (at least in 4c). The archive process only selects closed production orders. Is it possible that production orders were closed through General Table Maintenance? If that's the case, you might have to do some more GTM.

We have archived a range of projects successfully. However, there are a handful of projects that did not archive in our range. These projects had subcontracting purchase orders on the production order. So I ran the process delivered with delete order data to yes. I also ran update purchase statistics. Tried to archive the individual project and still receive a message about a subcontracting order present. Is there something that I'm missing?

-Tim

Have a look at the subcontracting order. The following are the possible reasons, that might prevent a fully processed and paid subcontracting order from being deleted:

- an inbound advice for the order still has to be generated and/or processed

- a transport order is linked to the purchase order

If the project is closed, the subcontracting order must have been fully processed and paid, but since it appears (from your earlier messages) as if there has been some GTM involved, I would also check, whether the subcontracting order has been properly paid and matched to the invoice.

The way to do that: in GTM, table tdpur045, form 2, check the field "Delivery Status". That should be on "All Approved". If it is not, I would check with your Finance department and make sure that the invoice has been paid. If it has been paid, then the invoice hasn't been matched to the order. If that doesn't bother your Finance people, you can change the field to "All approved" in GTM and delete the order with "Process Delivered Purchase Orders".

Regards,
Karin
www.maxsc.com

I checked the inbound data of one p.o. and there was nothing to inbound. There doesn't look like a transport order is linked either.

I then checked the tdpur045 table for this p.o. There are 5 lines. Each line has two sequences 0 and 1. The delivery status for sequence 0 is 'Free'. The status for seq. 1 is 'All Approved'.

In the meantime, I will check with finance to make sure this p.o. is invoiced and matched.

That sounds ok. Only the lines with sequence no. 1 have to be on "all approved".

I forgot one possible cause: are there open backorders for the lines? If the field "Back Order" in tdpur041, form 3 shows a quantity <> 0, then that would prevent the order from getting deleted.

I checked with finance and they double checked for invoice matching, backorders were zero. Everything checked out to be ok for the process delivered session. There's nothing else they know of to check at least from finance's side.

-Tim

I assume the invoice date and the receipt date are before the date you selected in session "Process delivered Purchase Orders" and the company number in tdpur045, form 4, field "Company" is the same as the company in which you're running the session?

The fastest way, to find out what the problem is, is to run the session in debugger mode (works only if you've got the program scripts) and step through the program.

Nope that's the problem...me..

I only processed up to 1999 and these p.o.s were invoiced in 2000. I processed the 2000 and re-ran the archive session and they successfully archived.

Thanks so much for your help Karin!!


-Tim

You're very welcome, Tim. I've got those days too...

Karin

I'm trying to archive one project. The first attempt, I set 'archive general data' to NO. I received an error message 'reference does not exist' between the tables tipcs022 and tipcs021 in the archvive company for the project number I'm archiving.

The second attempt, I did the same thing but set 'archive general data' to YES. It processed for a while and them errored out with a reference does not exist between tables tiitm001 and tiitm100 in the archive company for an item. I re-ran it again and received the same error, this time with a different item.

Has anyone seen something like this before?

-Tim

Do those references exist in the production/original company?

I've seen these problems if there is corrupt data in the original company.

The problem with this project was in the tipcs022 table. Customized Bill of Material. This project had a couple lines with blank manufactured items tied to it. This was a problem once we went live.

Anyways, I removed these lines from the custom bom and then rearchived this project. It was successful.

-Tim