How can I get to the "posted" purchase orders?

timjad

Hello,

Once a purchase order is invoiced, it's deleted from the purchase order tables. What if I need to lookup an invoiced PO? Is there a way to see those POs? maybe in a different table?

Thanks,
Tim

Tommy_Schou

Errh.. Under Purchases and Payables go to Posted Invoices. A purchase order becomes a posted invoice. To search for a specific order no. just press shift+f8 and select the key order no. and then type the no. in the field "Order no.".

babel

Hi Tim,

each order - even when deleted - is stored in the table "Sales Header Archive". You can have a look at these orders by choosing "Purchases and Payables" -> "Periodique Activities" -> "Archived Orders". I hope the titles are correct, I've a German Navision Version.
Hope this is what you need...

Barbara

Edward_Bloomfield

Hello,

Barbara, while Archiving Orders is a standard Navision feature, the automatic archiving you mention is not (At leats in the W1 & GB versions) & must have been bespoke work done for your company.

In out of the box Navision, the user has to manually use the archive option. If they do not, then the order is not archived and when some one presses F4 or posts it...the order is gone.

The logic of Navision is that all the data that would have been held in the PO is held in the Sales Shipment/Invoice Header and Lines tables, therefore you no longer have any need for the PO and for the sake of data redundancy (& database space) Navision gets rid of it.

Tommy_Schou

Am I mission something here or are you mixing up Sales- and Purchase Orders/-invoices?

babel

Thanks for the info Edward, I didn't know...

timjad

Thanks for all the replies.
Archive tables don't store a copy of the Purchase Order unless the user specificly archives the PO... even then, you might have multiple copies, and no guaranty that the last copy is the one that was posted

I know that the data is in the posted invoices table... but, line items from PO can endup on multiple posted invoices (if not all quatity was invoiced at the same time). Also, the same line item can exist on multiple posted invoices in the case of partial receipts.

I find this to be very odd that the actual Purchase Order practicaly disappears after it's been posted... what if yo uwant to go back and look at an old Purchase Order? there has to be something I'm missing..
Is there a way to have Navision automatically archive the PO just before it's deleted??

Dean_Axon

Is there a way to have Navision automatically archive the PO just before it's deleted??

Ill put my developer/sales hat on today !!! :twisted:

OF COURSE THERE IS

BUT>>> (There's always a but!! :twisted: )

You will need to have it developed.

The code you need resides in CU 80 for all sales and CU 90 for Purchases. Look for the code near the bottom of the function where it mentions "SalesLines.Deleteall" (in cu80)

ningnongjin

Hi all,

I've been reading this thread, in regards to one of 'many' questions i have in relation to the archiving functionality, but i shall keep it to one. I would like to know whether is it possible for me to view all documents i have archived for both sales and purchases, and how do i go about it. Thanks in advance.

awarn

To answer TimJads last question,

From the PO, if you go Purchase -> Receipts or Purchase -> Invoices, you will get a list of the headers for all of the posted receipts and invoices. The Order No. on the header of these posted documents is what links them all together (this is the original PO number).

-a