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

(0) Share

Report

Posted on by jdrco

485

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)

Sort by

Suggested answer

Amit Baru 3,043 on at

Like (0)

Report
Copy link

Link copied!

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 485 on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

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

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

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 102,857 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

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