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

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

There can't be one-to-one relation, as you can have multiple posted receipts and one posted invoice, or visa versa, or even many and many of both - all for the same purchase order.

If you search for the relation, both posted receipts and invoices have the same relation to initial purchase order. There is a field "Order No." in the headers of both posted receipt and posted invoice.

Was this reply helpful? Yes No
Amy Racz on at

Like (0)

Report

If I create a new purchase invoice and get receipt lines, "Order no." is empty. If I post purchase order, then "Order no." gets value, but I do it on the first way.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Amy,

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

check No. series for the posted purchase invoice.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Amy Racz on at

Like (0)

Report

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".

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Amy Racz on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No