web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Getting error in App.j...
Business Central forum

Getting error in App.json file.!

(0) ShareShare
ReportReport
Posted on by Manikanta_501 245

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).
 
Reservation.PNG
 
Can any one Suggest me the Solution.
Categories:
Purchasing
Web and mobile experience
Business Central
Inventory and warehouse management
Other
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

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

  • Manikanta_501 Profile Picture
    Manikanta_501 245 on at

    I tried like below

    "Source Subtype" = CONST ('')

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

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

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

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

  • Manikanta_501 Profile Picture
    Manikanta_501 245 on at

    Thank you., It's Working

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans