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)

Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

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
jdrco 481 on at

Like (0)

Report

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,037 on at

Like (0)

Report

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

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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,037 on at

Like (0)

Report

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

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

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