Purchase receipt and invoice table relation

(0) Share

Report

Posted on by Amy Racz

Hi all,

if I create a new purchase invoice, i get receipt lines and i post it, where can I find relation of purchase receipt and invoice? The table puchase invoice line has "Description" field which includes purchase receipt nr. like "Receipt No. 16/100051", but I can't work with this data.

Thank you!

Amy

*This post is locked for comments

All responses (12)

Answers (0)

ManishS 6,578 on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

Assuming your are on correct line, have you checked all lines.
Amy Racz on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

Hello Suresh,

it's about posted purchase invoice. When I use Ctrl+F8 on purchase inv. line, I can't find any fields like Receipt No.

Amy
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

Amy,

Zoom on the purchase line using Ctr+ F8 and you will see the fields Receipt No. and Receipt Line No. as shown in the figure
Amy Racz on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

I create a new invoice and use get receipt function then I post it.

We would need to match up purchase orders with purchase invoices for further development.
The problem is that we don't have any fields we could pair purchase invoice lines with orders.
If we make the invoices with the get receipt lines function, the order no remains empty after (I'm aware it exists, but
it's empty before and after posting,

It only works if we are posting the invoice from the purchase order.

Thank you!
Suggested answer

RockwithNav 6,562 on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

Probably if you can attach the screenshot, there seems a level gap.

In the Sub-form you will find Get-receipt Lines.
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

If you using 'Get Receipt lines' function then you can find order no and order line no in Purchase Invoice .Based on this info you can find receipt no
Amy Racz on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

Hi Suresh,

thanks for the answer. I use NAV 2009, in this version I can't see any receipt no, it's just in Description field on purchase inv. line. However, i can't work with this format like "Receipt No. 16/100051".
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

Amy,

I believe you are using the Get Receipt Lines function to apply some item charges for that receipt ? Please check on the invoice for the Receipt No.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

check No. series for the posted purchase invoice.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Purchase receipt and invoice table relation

Hi Amy,

As suggested by Alexander , you can search by order No. in the posted purchase Invoice and posted Purchase receipt.