Expose GST Line Amount of Sales Invoice Line to a Custom API

(1) Share

Report

Posted on by Kev L

Hi Experts,

I tried to create a custom API that expose Sales Invoice Header and Sales Invoice Line in a single API call.

I'm not using the standard API as I'd want to include my custom fields.

However, I noticed that there're no easy way to expose the GST line amount in Sales Invoice Line (where GST line amount = Line Price including GST - Line Price excluding GST).

Any suggestions?

Thanks.

Regards,

Kevin

Categories:

Business Central

All responses (1)

Answers (0)

Suggested answer

Yi Yong 1,391 Super User 2024 Season 2 on at

Like (0)

Report
Expose GST Line Amount of Sales Invoice Line to a Custom API

Hello,

You can create a var decimal and calculate the GST using onaftergetrecord function.

layout { area(content) { repeater(Group) { field(DocNo; Rec."Document No.") { } field(LineNo; Rec."Line No.") { } field(GSTAmt; GSTAmt) { } } } } var GSTAmt: Decimal; trigger OnAfterGetRecord() begin Clear(GSTAmt); GSTAmt := Rec."Amount Including VAT" - Rec."Line Amount"; end;