Display the Unit Price of Posted Sales Invoice in a Customer Subform (Help)

(0) Share

Report

Posted on by jdrco

481

I have a custom subform (created using a repeater in a ListPart page) where I want to display posted sales invoices (Sales Invoice Header) associated with the current record. Along with from inside the Sales Invoice Header, I also want to display the Unit Price of that specific invoice in my subform as well.

This is my attempt:

But results in 0.00 for each of the Unit Price fields within my custom subform:

Screen-Shot-2022_2D00_09_2D00_10-at-12.43.37-PM.png

What am I doing wrong here?

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

YUN ZHU 90,354 Super User 2025 Season 2 on at

Like (1)

Report

RE: Display the Unit Price of Posted Sales Invoice in a Customer Subform (Help)

Hi, just adding some info for FlowFields (Sum, Average, Exist, Count, Min, Max, Lookup).

https://yzhums.com/5802/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,035 on at

Like (0)

Report

RE: Display the Unit Price of Posted Sales Invoice in a Customer Subform (Help)

Hi,

Display the Unit Price of Posted Sales Invoice in a Customer Subform (Help)

As per the above query, he want Unit Price total. That why i told for new field. Because Amount Field in Sales Header show Unit Price * Quantity of all sales line.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: Display the Unit Price of Posted Sales Invoice in a Customer Subform (Help)

You already have the amount field in the Sales invoice header table. So why do you need to create another field?

You should just display the amount filed where you need it.

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,035 on at

Like (0)

Report

RE: Display the Unit Price of Posted Sales Invoice in a Customer Subform (Help)

Hi,

Pls create flow field in Sales Header Table and then shown in Pages as normal. you will get the result.

Creation of Flowfield-> https://erpconsultors.com/flowfield-in-dynamics-365-bc/

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

RE: Display the Unit Price of Posted Sales Invoice in a Customer Subform (Help)

How do I make a field within a repeater a FlowField? I get an error when I try to:

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,035 on at

Like (0)

Report

RE: Display the Unit Price of Posted Sales Invoice in a Customer Subform (Help)

hi,

According to your customization, Pls create Invoice Total field is flowfield and then value is coming as per you requirement.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No