Friday, July 9, 2021

Business Central - How to connect to an ODATA web service with filters

 https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-flowfilters-in-odata-uris

  • Business Central Administration>ODATA>Enable OData Services
  • Web Services>Enable Web Service for your object
  • Access ODATA Link with filters in link, example COA with Date filter range
    • http://desktop-tr74u66:7048/BC180/ODataV4/Company('CRONUS%20USA%2C%20Inc.')/Chart_of_Accounts?filter=date_filter%20gt%2001011900%20lt%20t
    • http://desktop-tr74u66:7048/BC180/ODataV4/Company('CRONUS%20USA%2C%20Inc.')/Chart_of_Accounts?filter=date_filter gt 01011900 lt 01012023

Friday, June 11, 2021

Wednesday, June 2, 2021

BC When debugging - Check if PublicWebBaseUrl has been properly set

  •  BC Server Admin-Client Services
  • Restart VSCode

Monday, May 17, 2021

Wednesday, May 12, 2021

LS Central - Discount Offer Priority

 Lowest numbers are highest priority

LS Central - Qty sold not Posted Report

 There is no report available, however, the field QtySold(POS) can be added to the item page using design or an extension