the lines of a posted invoice

sbilly

HI all,
how can I know if the lines of a posted invoice are from a posted receipt ( by using the function : get receipt lines)
thanks

DenSter

Put your cursor on the line that you want to know this about. Do Ctrl+F8 or select Zoom from the Tools menu, and study the fields. See if you can figure this one out yourself.

DenSter

Actually, I take that back. It appears that the Receipt number is not part of the posted purchase invoice line table. It's in the purchase line table but not in the posted purch invoice line table.

bummer...

Yashojit_Pandhare

Hi,

There are Receipt Document No. and Receipt Document Line No. fields in Purch. Inv. Line. But I suppose these fields are updated only if Receipt & Invoice is done together while posting from PO

:thumbsup:

dans

Yashojit Pandhare wrote:

Hi,

There are Receipt Document No. and Receipt Document Line No. fields in Purch. Inv. Line. But I suppose these fields are updated only if Receipt & Invoice is done together while posting from PO

:thumbsup:

Isn't that customization ? As far as I know, standard NAV doesn't have that.

Sog

It's only available on the sales side, not on the purchase side. (fields 63&64 on sales invoice line)

Yashojit_Pandhare

dans wrote:

Yashojit Pandhare wrote:

Hi,

There are Receipt Document No. and Receipt Document Line No. fields in Purch. Inv. Line. But I suppose these fields are updated only if Receipt & Invoice is done together while posting from PO

:thumbsup:

Isn't that customization ? As far as I know, standard NAV doesn't have that.

Doesn't look like customization to me... I am using 2009R2 ... the field numbers in Purch. Inv. Line are 16516 and 16517 respectively.

Sog

The guy above me wrote:

Yashojit Pandhare wrote:

Isn't that customization ? As far as I know, standard NAV doesn't have that.

Doesn't look like customization to me... I am using 2009R2 ... the field numbers in Purch. Inv. Line are 16516 and 16517 respectively.

And instant proof it is localisation: field numbers > 10000 and < 50000 (don't know the upper limit for localisation) are not W-fields.

dans

Yashojit Pandhare wrote:

Doesn't look like customization to me... I am using 2009R2 ... the field numbers in Purch. Inv. Line are 16516 and 16517 respectively.

16516 and 16517 are part of Country specific range.

ssingla

dans wrote:

16516 and 16517 are part of Country specific range.

Yes the fields are part of Indian Localization.
Coming to the original topic there is no other way in W1 Version other than the indirect route of Value Entry - Item Ledger Entry. No values are updated in Purch. Inv. Line refering to Purch. Rcpt. Line and vice versa.