-
Update Allow posting From/To on the General Ledger Setup
Hi, I'm new to NAV so excuse me if it's not the smartest question. I have a developer license and I'm trying to update the "Allow posting from" and "Allow Posting To" fields in the GLS to the next month at midnight Could anyone please let me know how this can be done? I'm trying to find from where those fields are…
-
Using FlowFilter on Query object via ODataV4 (NAV17)
Hello, I am trying to create a simple Query with Item Inventory, then I want to call it with OData using Location_Filter. I created a Query object: and when I call/ODataV4/Company('TEST04')/ItemStock?$filter=No eq '16721' it works fine, but when I try to filter on Location:/ODataV4/Company('TEST04')/ItemStock?$filter=No eq…
-
Extension Page Name instead of original page name (BC 20)
Hi All, i notice since BC version 20 on the cloud, it will show our extension page name, instead original page. for example i have page extension for Warehouse Receipts page,i named it as PagExtWarehouseReceipts. so when user search it will show as PagExtWarehouseReceipts instead of Warehouse Receipts. is there any setting…
-
How to allow user to only select boolean once per record?
How would you approach the following example... A list page has been created where the user can create a description (e.g. blue paint) and select a series of checkboxes (i.e. gloss/matt/satin/special). For entry 1 the user has created a description and selected the checkbox 'gloss'. For the next entry, the user will create…
-
How to print a report without user interaction directly to a specific printer name ?
The customer import some orders through EDI and after that the realising it is done automatically. After releasing they want to print also a report direclty to a specific printer. The printer name it is set up on sales person table, so it is a different printer per sales person. How can I accomplish this ? Should I use…
-
Factbox with code
Hi experts, We are talking about NAV 2015. I have made a factbox with some lines in. I would like that my code would be run, when the user press a button inside the factbox (on every line or one single button below the lines). The code should work with the active line in the factbox. Otherwise the code may be run when the…
-
Business Central SaaS: User License
Is there an easy way in AL to check if a user has a Team Member License or a Full License?
-
Microsoft Forms with Business Central
Has anyone used MS forms with BC? Is there any guidance for custom build, feeding data from MS Forms to BC Thanks
-
XMLPort - Job Queue
I've an XMLPort I'd like to run via the Job Queue. In the Job Queue Log Entries, I'm getting the message: Client callbacks are not supported on Microsoft Dynamics NAV Server. Here is my Job Queue Entry codeunit; SalesHeader.SETRANGE("Document Type",SalesHeader."Document Type"::Order);…
-
Account Schedules D365 Business Central totaling question
Hi, Account Schedules overview values with formula totaling type in old versions can be opened to check if amounts are matching, now it seems only Total Accounts and Posting Accounts can be used for balance sheet etc. Are there any options to open values similarly as Formula totaling type?
-
NAV2013 R2 -> As data are inserted into imported Excel file, the style (layout) is changed
Hi All, System: NAV2013 R2 Errors: Issue #1 -> Excel file cannot be edited by the NAV, if any style is applied on the sheet. Issue #2 -> Styles are changed as Excel file is edited with some data from Job record. Functional steps: 1. on page "Job Card" user clicks on button "Populate Excel" 2. function to copy the template…
-
Can i change the posting date while doing the reversal of payment
Hi folks. My client requirement is they want reversal entry posting date should be the date on day they are posting, For e.g. My payment posting date is 3/08/2020 and i am reversing it on 19/08/2020, so my reverse entry posting date should be 19/08/2020. Kindly Suggest
-
Dynamics NAV XMLport Generator v1.3
Dynamics NAV XMLport Generator v1.0.0.1 Have you ever created a XMLport from scratch? You created the port line by line based on a schema file. Then tried to import a document and nothing happened because one or more of the dozends of tags have wrong minOccurs and/or maxOccurs values? Then the debug session. Maybe you have…
-
Add Attachment in Notification Approval Email
Hi all.. i have attach these files in documents. once I send approval to manager. i want to attach these attachments in notification email. is that possible? Thanks
-
Attachment Factbox move from details tab
Hi All, i create new document attachment as factbox anyone know how to move i from details tab? it keep showing at details instead of attachment
-
YggDrasil NavPad v1.1
YggDrasil NavPad With Dynamics NavPad Control Add-in, you edit big amouts of texts in some kind of textpad, and store it in Navision-tables (in pieces) to be able to show the content in a subform. The fieldlenght of a piece of text is adjustable. The pieces of text will be cut of at a "Space" or "Carriage Return". This…
-
Write XMLElement nil="true"
I try to set the following attributes in an XML element:<mactive xsi:nil="true"/>. With the statement XMLElement3.SetAttribute('nil','true') I unfortunately miss "XSI:", For information I would be grateful _________________________________________________________________________________________________ AL: XMLDoc :=…
-
NAV 2016 Bank Recon: Problem when using "suggest Lines" a second time
Hi, In my first month in Navision 2016. Trying to play catch up on some bank recs that haven't been done. The issue is we have a bunch of charges that come in on auto-pay. So as I'm going through the reconciliation, I am constantly having to enter new cash receipts journals for items that have hit the bank statement but…
-
Proper way to use filters with business central API in On-Prem multitenant environment.
Greetings to Everyone. I am having trouble figuring out the proper usage of filter with OnPrem Business Central Api. We have used multi-tenant deployment. This is working http://localhost:7048/gasorgn/api/BizNP/biobizapi/v1.0/companies(3530cd87-f0b2-ec11-9111-82e8be684e31)/generalledgerentries?tenant=gasmaster But while…
-
Is there a way to debug a standard API call?
Since the objects are hidden i can't find a way to debug them. I copied the entire salesOrder API to replicate it but i get different results passing the same Json. A "you must specify a document id to get the lines." Error on the custom API but it works on the standard API { "customerNumber": "10000", "salesOrderLines":[{…
-
Passing a single nested JSON to create two different records
Hi, my goal is to pass a single nested JSON to create a sales order and a customer bank account . Is it possible without having to add a bankData field in the sales order table? Right now all i can think of is creating a table extension and custom API for sales orders so i can pass the bank data into the sales order table…
-
Unable to credit a purchase prepayment
Hi, My client has an issue with trying to credit a prepayment PO. The scenario is below, they are currently running an Azure cloud version. There version is CA Business Central 19.5 The scenario is as follows: A PO was created and a 100% prepayment was posted. Purchase & Payable setup allows them to receive etc on the PO…
-
xml Structure
Hi all I have an xml port and can't figure out how to get the structure as shown below. My aim is this structure of the xml-port (red marked area): Actual state is this: There is no table for the CustomFields. For example, my challenge is to make form : <VKOrderNo>2021-60217</VKOrderNo> an output like this: <CustomField…
-
"The value for the WSFederationLoginEndpoint configuration settings cannot be empty" OpenID Issue
Hello everyone, I'm trying to setup Azure AD authentification with OpenID connect but i find myself enable to move forward. I used this documentation : https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/authenticating-users-with-azure-ad-openid-connec and followed every instruction but…
-
Cloud BC - Intelligent Cloud error
Hi all, i have done migration from BC on prem to BC Cloud but i get this error message. "Data from table Ess. Business Headline Per Usr is unavailable. Intelligent Cloud replication for this table was unsuccessful." any advise? Thanks.
-
Convert Classic Report to RDLC Report During NAV 4.0 to Business Central Upgradation.
Hi Everyone, I have to Upgrade Classic report to RDLC. How can i do? If i don't want any paid-up tools. How can i proceed? Please guide me.. Thanks, Mani.
-
Delete rows in excel file
I need to edit an excel file. After reading it, I edit some cells and delete some rows. With .net I was able to complete this task. Using target: onCloud there is a way?
-
Tables in SQL
Hi all Please refer the attached picture. I do not see these tables under Object Designer but available in SQL Database tables section? What are these table used for? No records at all.
-
How to connect to and authenticate an external web service from BC cloud
I am trying to connect to the ABN Amro sandbox. The API example is as follows: curl -X POST "https://auth-mtls-sandbox.abnamro.com/as/token.oauth2" \ -v \ --cert CertificateCommercial.crt \ --key PrivateKeyCommercial.key \ -H 'Cache-Control: no-cache' \ -H 'Content-Type: application/x-www-form-urlencoded' \ -d…
-
after creating a field in customer record how to Flow the value of same field on Sales Header & Line
After creating a field in customer record how to Flow the value of same field on Sales Header and Sales Line.How to do this?