SBX - Search With Button

SBX - Forum Post Title

Getting error in App.json file.!

Dynamics 365 Business Central Forum

Manikanta Adabala asked a question on 12 Jun 2019 12:29 AM

Question Status

Verified

When I am Writing below code in Visual Studio Code for Business Central of Cloud Version(SaaS).

CalcFormula = - Sum ("Reservation Entry"."Quantity (Base)" WHERE ("Item No." = FIELD ("No. "),
"Source Type" = CONST (32),
"Source Subtype" = CONST (),
"Reservation Status" = CONST (Reservation),
"Location Code" = FIELD ("Location Filter"),
"Variant Code" = FIELD ("Variant Filter"),
"Shipment Date" = FIELD ("Date Filter")));
 
 
Getting Below Error(In App.json).
 
 
Can any one Suggest me the Solution.
Reply
Suggested Answer

Try with "Source Subtype" = CONST (''),

Reply
Manikanta Adabala responded on 12 Jun 2019 2:02 AM

I tried like below

"Source Subtype" = CONST ('')

But getting Error : Field type Option is not convertible to field type Text

Reply
Verified Answer

"Source Subtype" = CONST ("0") ?

Check the OptionString property on your Reservation Entry table, it should be 0,1,2,...

Reply
Manikanta Adabala responded on 12 Jun 2019 3:30 AM

Thank you., It's Working

Reply
Verified Answer

"Source Subtype" = CONST ("0") ?

Check the OptionString property on your Reservation Entry table, it should be 0,1,2,...

Reply
Suggested Answer

Try with "Source Subtype" = CONST (''),

Reply

SBX - Two Col Forum

SBX - Migrated JS