How to update currency exchange rates in BC by using «Eidgenössische Steuerverwaltung ESTV» (Federal Tax Administration - FTA) backend service?
Only core fields with ultimate relvance to the functionality with the ESTV service are mentioned here.
Be aware that your
- Check out the link to the daily rates XML file
«Service URL» = https://www.backend-rates.ezv.admin.ch/api/xmldaily - Create a «Currency Exchange Rate Service» ( Curr. Exch. Rate Service List (1650, List) )
Caption «Parent Node for Currency Code» | Source = /wechselkurse/devise
Caption «Currency Code» | Source = /wechselkurse/devise/@code
Caption «Starting Date» | Source = /wechselkurse/datum
Caption «Exchange Rate Amount» | Source = /wechselkurse/devise/waehrung
Caption «Relational Exch. Rate Amount» | Source = /wechselkurse/devise/kurs
- Create «Transformation Rule» for «Starting Date» ( Transformation Rules (1237, List) )
«Transformation Type» = Date and Time Formating
«Data Formatting Culture» = en-CH - Create «Transformation Rule» for «Exchange Rate Amount» (Transformation Rules (1237, List)
«Transformation Type» = Regular Expression - Replace
«Find Value» = (e.g. AUD|EUR|GBP|JPY|NOK|PLN|SEK|USD ) - Update Currency Exchange Rate Service created in step 2. ( Curr. Exch. Rate Service List (1650, List) )
Caption «Starting Date» | Transformation Rule = (the code used in step 3) - Update Currency Exchange Rate Service created in step 2. ( Curr. Exch. Rate Service List (1650, List) )
Caption «Starting Date» | Transformation Rule = (the code used in step 4)
Play around with enable, preview ;-)
- Details
Hello World App
- Businesscentral Admin Center ...
- MS Learn - BusinessCentral (administrator, developer, functional-consultant, solution-architect)
- Visual Studio Code (AL Language, AZ AL Dev Tools/AL Code Outline)
>> View >> Command Palette >> AL:Go!
>> in file launch.json (below "startobjectid") add «"tenant":"myTenantID",» and «"environmentName":"mySandBox",»
>> (command Palette) Download Symbols ... follow the instructions (the code needed is copied to the clipboard automatically)
>> build = ctrl+shift+b
>> F5 = build & deploy - AL: Clear credentials
The Page Inspector
top right «?» --> Other resources --> Help & Support --> (Troubleshooting) Inspect pages and data ...
OR --> CTRL + ALT + F1
Mandatory Fields in AL and Business Central
- Toutorials by Krzyztof Bialowas (AL for Beginners) / Erik Hougaard / Kauffmann NL / Steve Endow
- Docker Container Helper on FreddysBlog.com
- MS Docs - Business Central (Main)
- MS Docs - Table, Table Fields, and Table Extension Properties
- MS Docs - FieldType Option Type https://docs.microsoft.com/en-us/dynamics-nav/sql-server-data-types
- MS Docs - SQL Server Data Types (be aware NAV not BC)
- MS Docs - FlowFields
- MS Docs - Table Keys
- MS Docs - Triggers
- MS Docs - Pages Overview
- MS Docs - Available Fonts
- Tutorial - Customizing Standard Reports
- MS Docs - Create and Modify a Custom Report or Document Layout (i.e. Report Layout Selection >> Custom Report Layouts {RDLC & Word})
- Tool - Visual Studio (for the RDLC files)
- Next >> how to copy Belgium VAT reports into CH localised SandBox..
11 G/L - VAT Reconciliation
12 VAT Statement
13 VAT Register
19 VAT- VIES Declaration Tax Auth
20 Calculate and Post VAT Settlement
31 VAT Exceptions
32 Batch VAT Registration No. Check
209 Sales Reservation Avail.
409 Purchase Reservation Avail.
740 VAT Report Print
2500 Day Book VAT Entry
11310 VAT Statement Report
11312 Checklist Revenue and VAT
- Details
-----------------------------------------------------------------------
A)
A)
-----------------------------------------------------------------------
select
*
from
dbo.[Permission]
WHERE
[Object ID] IN ('214', '752', '11512', '50051', '5172327')
AND
[Object Type] = 3
ORDER BY
[Role ID], [Object Type]
-----------------------------------------------------------------------
- Details
------------------------------------------------
Item
------------------------------------------------
SELECT
[No_],
[Description],
[VAT Prod_ Posting Group],
[Location Code],
[Country_Region of Origin Code]
FROM dbo.[MyCompany$Item]
where [Description] LIKE '%A%'
ORDER by [VAT Prod_ Posting Group]
GO
------------------------------------------------
- Details