prh_hist conversion question

[lmjking]

In V9 there is a table prh_his and it has amongst other fields the field prh_last_vo, prh_inv_qty and prh_project.

These fields are no longer in prh_hist table in Eb2.1

1. prh_last_vo I presume is a voucher number. How does it relate to prh_hist in EB2.1, which table is it on now?

2. prh_inv_qty, is this the same as prh_qty_ord in EB2.1 or should I be looking for this in another table?

3. I am clueless as to what prj_project is. I don't see it in the table in EB2.1

Any help will be appreciated.

 

[Kishor Chari]

I would pick the qty & project from tr_hist , Lat voucher seem to be discarded altogether.

 

[montamig]

In Eb2.1 MFG has a new table pvo_mstr (Pending Voucher Master) where are all vouchers related with receptions. This table you access with:

pvo_internal_ref = prh_receiver and pvo_line = prh_line.

If you want consult the historial then:

vph_hist (Voucher Invoice History) where vph_pvo_id = pvo_id.

The field vph_ref is the number of voucher.

Bye.