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.

All responses (4)

Answers (0)

Martinaaaaa 15 on at

Like (2)

Report

RE: Last Purchase Invoice Number in Vendor Card

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

YUN ZHU 85,819 Super User 2025 Season 1 on at

Like (0)

Report
RE: Last Purchase Invoice Number in Vendor Card

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
Suggested answer

Vinita_Kas 336 on at

Like (0)

Report

RE: Last Purchase Invoice Number in Vendor Card

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
Suggested answer

MahGah 15,445 on at

Like (2)

Report

RE: Last Purchase Invoice Number in Vendor Card

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.