Last Purchase Invoice Number in Vendor Card

(1) Share

Report

Posted on by Martinaaaaa

Is it possible to have a field with the last purchase invoice number in a vendor's card? Moreover, if it is possible, is it updated automatically? If both are possible, how are these done please? Thanks in advance.

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

MahGah 15,613 on at

Like (2)

Report
Copy link

Link copied!

Hi

Nothing out of the box. You need development for that. But in Vendor card you have Buy From Vendor History and from there you can click on invoice and see the last number.

Was this reply helpful? Yes No
Suggested answer

Vinita_Kas 336 on at

Like (0)

Report
Copy link

Link copied!

Hi

The requirement is not correct

Since there can be multiple open invoices for the vendor so which one should be shown?

Ideally, you should look at the balance field on the vendor card as shown below in step 1 and it would then open all the invoices as shown in step 2

Regards

Vinita

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,590 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi, you can try to use flowfield.

For example,

tableextension 50100 MyExtension5 extends Vendor { fields { field(50100; "Last Purchase Invoice Number"; Code[20]) { FieldClass = FlowField; CalcFormula = max("Purch. Inv. Header"."No." where("Buy-from Vendor No." = field("No."))); } } } pageextension 50111 MyExtension5 extends "Vendor Card" { layout { addafter(Name) { field("Last Purchase Invoice Number"; Rec."Last Purchase Invoice Number") { ApplicationArea = All; } } } }

Click the Number.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Martinaaaaa 15 on at

Like (2)

Report
Copy link

Link copied!

I was looking for more of a built in functionality as opposed to customizing it with code. Thanks anyways though!

Was this reply helpful? Yes No