Share
ReportI already tried the FlowField method and AutoFormatExpression
Please help to solve this issue...
You’re offline. This is a read only version of the page.
40
I already tried the FlowField method and AutoFormatExpression
Please help to solve this issue...
Hi Amit,
Thank you so much... Once I update the schemaUpdateMode I got the Line Amount in the Cue...
Hi,
Pls change schemaupdatemode = Force. when it will compile and publish, then restore the schemaupdatemode = Synchronize mode.
https://erpconsultors.com/schemaupdatemode-in-al-in-launch-json-in-d365-bc/
Regards
Amit Sharma
Press Yes if info is useful.
Hi,
I Changed the table,
field(1041; "S.I.Amt"; Decimal)
CalcFormula = sum("Sales Line".Amount WHERE("Document Type" = FILTER(Order)));
but I am getting the error in VS Code
The request for path /v2.0/Sandbox/dev/apps?SchemaUpdateMode=synchronize&DependencyPublishingOption=default failed with code UnprocessableEntity. Reason: TableExtension 50112 CueTable :: The field 'S.I.Amt' cannot be located. Removing fields is not allowed.
Hi,
Pls use Sales Line table instead of Sales Header. Because Amount filed in Sales Header is also a flow field. That why you are getting error.
Regards
Amit Sharma
Press Yes if info is useful.
Hi Amit,
Once I created the Custom field in the Cue table with the below code
field(1041; "S.I.Amt"; Decimal)
{
CalcFormula = sum("Sales Header".Amount WHERE("Document Type" = FILTER(Order)));
Caption = 'Ongoing Sales Orders';
FieldClass = FlowField;
}
And, I am getting these errors in the dashboard
Error: An unexpected error occurred after a database command was cancelled..
Hi,
Go to Sales Que table and Create Sales Invoice Amount field--> Nature of field is flowfield and Take Sales Invoice Line table--> Line Amount--> Quantity <> 0
Regards
Amit Sharma
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (