Posted Purchase Invoice (Header Table) Table Number 122

kwajahathydro · 2013-09-26

Hi,

In Navision 2009 SP1 under purchase order (table 38) there is a field called Vendor Shipment No and we fill in this field with some values and post the purchase order where navision creates a posted purchase invoice. Under Posted Purchase Invoice this field Vendor Shipment No is not shown so I am sure with flowfield we can manage to display it. But how shall I put the flowfield, can someone tell me how to do it.

Regards
KH

mohana_cse06 · 2013-09-26

This field is available in Purch. Rcpt. Header.
You can use Vendor Invoice No. in Purch. Inv. Header.

If you completely receive and Invoice the Order then PO will be deleted so we cannot get it fropm Order.
Only way is to get it from Purch. Rcpt. header.

If you are posting Invoice from PO then you can use Order No. in both Purch. Rcpt. Header and Purch. Inv. Header.

kwajahathydro · 2013-09-26

Hi Mohana,

when you said the vendor shipment no. field is available in Posted Purchase Receipt Header, can I use flow field and pull this vendor shipment no. from purchase receipt header into purchase invoice header. How to write a flow field that looks up from purchase receipt header and flows into purchase invoice header

Regards
KH

mohana_cse06 · 2013-09-26

mohana_cse06 wrote:

If you are posting Invoice from PO then you can use Order No. in both Purch. Rcpt. Header and Purch. Inv. Header.

Try this and let us know if didnt work with what you have tried.

kwajahathydro · 2013-09-26

Hi Mohana,

Well we are posting the invoice and receipts from the PO only. so how to write the flow field details

regards
KH

mohana_cse06 · 2013-09-26

kwajahathydro wrote:

so how to write the flow field details

I have already given some idea to you how to write FlowField.
Please try yourself and let us know if didnt work.

kwajahathydro · 2013-09-26

well i didnt see any idea from your reply. anyhow thank you

mohana_cse06 · 2013-09-26

mohana_cse06 wrote:

mohana_cse06 wrote:

If you are posting Invoice from PO then you can use Order No. in both Purch. Rcpt. Header and Purch. Inv. Header.

Try this and let us know if didnt work with what you have tried.

May be this is 3rd time I am posting this. You dont think it as an Idea? :-k

You can use Order No. field in both Rcpt. Header and Purch. Inv. Header to get Vendor Shipment No.

kwajahathydro · 2013-09-26

Thanks. didnt catch it. its clear now. let me try it out and update you if it works or not

Posted Purchase Invoice (Header Table) Table Number 122

Comments

Categories