Sales Invoice Header amount is not showing

(0) Share

Report

Posted on by Asif Shahzad

410

hello all,

I am trying to sum amount of Sales Invoice Header table but it is returning 0 though amount exist. What is it? is it because flowfield? How i can get then another page?

        Var
            SaleInvoice: Record "Sales Invoice Header";
            amount: Decimal;
            TempDate: Date;
        Begin 
            TempDate: Today;
            SaleInvoice.Init();
            SaleInvoice.SetFilter("Posting Date", format(CALCDATE('<-CM>', TempDate))   '..'   format(calcdate('', TempDate)));
            if SaleInvoice.FindSet() then begin
                repeat
                    //Message('Sales Amount: '   format(SaleInvoice.Amount));
                    amount  = SaleInvoice.Amount;
                until SaleInvoice.Next() = 0;
            end;
            Message('Sales Total: '   format(amount));
        End;

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Genie Cetas 472 on at

Like (1)

Report
Copy link

Link copied!
Hi Asif,

The Amount in Sales Invoice Header is flowfield. You must use either CalcFields or SetAutoCalcFields to retrive the value for FlowFields.

I have corrected your code.
Var SaleInvoice: Record "Sales Invoice Header"; amount: Decimal; TempDate: Date; Begin TempDate: Today; SaleInvoice.Init(); SaleInvoice.SetFilter("Posting Date", format(CALCDATE('<-CM>', TempDate)) '..' format(calcdate('', TempDate))); if SaleInvoice.FindSet() then begin repeat //Message('Sales Amount: ' format(SaleInvoice.Amount)); SalesInvoice.CalcFields(Amount); //Genie - Added amount = SaleInvoice.Amount; until SaleInvoice.Next() = 0; end; Message('Sales Total: ' format(amount)); End;

For more information about CalcFields & SetAutoCalcFields :

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-calcfields-method

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-setautocalcfields-method

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

And i suggest you to replace SaleInvoice.Init() to SaleInvoice.reset

Was this reply helpful? Yes No
Verified answer

Asif Shahzad 410 on at

Like (0)

Report
Copy link

Link copied!

Thank you Genie, It works.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Sales Invoice Header amount is not showing

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the December Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Sales Invoice Header amount is not showing

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the December Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates