-
Report in Loop
Good morning. I'm printing simple labels with the customer ID on them. I have to print only labels for specific users that have a specific boolean value set to true. Once i get the records, i loop through them and select only the ones with the boolean = true, but even if the "Rec" is updated on every iteration and…
-
Print from page part
Good morning everybody. Starting from a list of data which represent shelves, i select a shelf and double clicking opens its card page, which is a documen type, that contains all the items placed on that shelf. This document contains some general data, which are a description of the shelf, and a second area wich is a…
-
Auto fit not happens(Excel) while scheduling the report through job queue
while generating a report using code unit- excel buffer through job queue , column auto fit and row merging feature of excel is not working, but the same is working once i tried to run the code unit manually , Is there is any provision to work the auto fit and merging in excel through job queue?
-
Running out of entry numbers – use the ones below zero?
Issue: If a client is using NAV 2009 on SQL for many years, there is a risk of running out of entry numbers, for example in the table G/L Entry. And imagine that it is imperative to continue using the same company instead of creating a new one. Imagine this scenario: The first entry no. was set to 1 (many years ago) and…
-
Opposite of UPPERLIMIT for CalcFormula?
Hello. I need to make a FlowField for G/L account, that sums up balance, but it needs to be filtered to 1 day before the date period in Date Filter. I know about existance of UPPERLIMIT, but could not find anything that could be used to get the "lower limit", and how do I even get 1 day before that date? Sorry if this is a…
-
Trial Run Production Costing
We have lot of trial run production doing outside Navision, so high level expect to know the cost (material consumption and all other cost). Now I plan to create new Item card for Item need to trial run. For example, 1. create (Item-123-trial) for (Item-123) and link (Item-123)'s BOM and Routing to (Item-123-trial) 2.…
-
Can i use settableview sending a temporary table?
Hi friends, How to run a form object variable whose SETTABLEVIEW has Temporary Record set. Actually I want to see real data & temp data from the same form object.
-
Generate a auto receive without apply to original document
Hello all, Imagine this scenario: In our version of Dynamics NAV 2017,a change was made so that orders would create an advanced invoice, using an specific item for this. But the customer pays this advance, the problem is that it is only registered centrally many days later. Causing an analysis error as the customer paid…
-
run report for multiple companies
Hello developers, How to get data from multiple companies in report? NAV2009R2/ Classic report I need to show customer and vendor entries per company in report. Is there any solution?
-
BC 14.6 on prem Permissions!
I want to force users to do the put away on the handheld - removed the delete permission from our warehouse permission set on table data 7324. It works a treat for the one user who only has warehouse - they cannot register the put away! However another user has our operations set - which doesn't contain tabedata 7324…
-
"The specified path is invalid"
Hello, I have recompiled the page "Item Journal", now when I try to run it I get the error "The specified path is invalid" What could be the reason for that? Thanks in advance!
-
clients that run on Microsoft Navision in Belgium
Hi! I'm looking for clients that run on Microsoft Navision in Belgium! Is there someone who can help me? Thank you!
-
NAVISION2015 print PDF square special character in place of thousands space since WINDOWS 11
Hello I have a problem displaying the thousands space on PDF printouts only of Windows 11 PC Does anyone have a solution to resolve this problem please? Thank's for your help . Best regards
-
Setfilter from String to Code?
Hey, I'm new and I need some help. I have a String with different codes, seperated with a "|". Now i want to set a filter only to the selected codes, so multiple codes could be used. Can the SETFILTER function select ALL Codes from the string? I don't think so? Could you give me an advice? Code would be:…
-
NAV 2009 Transformation Tool Error
Hi everyone, I am trying to convert forms to pages using transformation tool. But the following errors keeps hitting. <?xml version="1.0"?> <TransformationLog xmlns="urn:schemas-microsoft-com:dynamics:NAV:ApplicationObjects"> <LogEntry> <LogCategory>Error</LogCategory> <ObjectID>-1</ObjectID> <Description>Could not load…
-
How to correct fixed asset accounting after the fact if one month's accounting has been missed?
is there any standard procedure for this? Thank You.
-
How to find top n order of all customer in the report in nav.
when I run this report it can prints all order of all customer can you please help me solve this issue.
-
Lanham eShip Issues
I can't believe I'm the only one in the world that has encountered this problem with eShip, but I can't seem to find any other examples... We use the Multi-Document feature of eShip extensivley. This is a great feature because it allows us to save a tremendous amount on freight by combining multiple shipments into one,…
-
Custom Approval Workflow
Hello, I have a custom approval workflow which i created from scratch. I have noticed that anytime i delegate approval or use workflow user group that once my document is approved, the status of the document does not change to Approved. But when i use direct approver, it works perfectly. what could be the issue?
-
how to take backup of a System table data before the Deletion of records from a specific table?
Customer want to reduce the size of system table(eg., GL Entry) which is huge in size. he was asking for option for selecting record for specific period and delete the records. Before deletion fo records , he is expecting to take back up of data for the filtered period before the deletion process begins. Up to my…
-
Can you helpme find the code, i want calculated duplicated data and show the 1 result data
I Have a problem with the data in the report, i have a duplicate data but i want calculated the quantitiy from the duplicate data, like a merge data, anyone can help? thankyou
-
Not able to populate pallet total in report "Work Order" within a sales order document.
Hello! We normally view this report and send as notification that order has been placed for some customers. However, we noticed number of pallets is not displaying. I have checked the item card > unit of measures and there is a quantity per pallet there so not too sure why its not showing in the report when we place…
-
Bin selection in put away Documents
Hello all, I have the following question. When I do warehouse shipment and put away is created, by what logic is the bin code defined on the line where the action type is place? Does it depend on some setup?
-
Hello I'm new in here, i want ask for to filterdate
I Have a problem about my filter, i want filter to posting date in same year but different month, like this, if i put the filter range 2023/04/1..2023/04/31 for my filter field show the data about the range, but my code doesnt work, he show the data form my filter untill current month. i wont if i set the filter range the…
-
Microsoft Dynamics NAV 2017: ExcelBuffer => How can I add an AutoFilter function?
I try to add a new function AutoFilter to ExcelBuffer (370). attempt (without succes): XlWrkBk := XlApp.ActiveWorkbook; XlWrkSht := XlWrkBk.ActiveSheet; XlWrkSht.AutoFilter; Anyone ever written something similar and can help me out? Thanks in advance!!!
-
How to create unique records in navision
i have created a table with fields id,name,roll no,age id name rollno age 1 A 1 20 2 b 2 20 3 c 1 20 i will create a actiuon called unique now i have to count unique records in roll no field like it should show message after clicking on action unique then it should show "No of unique records is 2"
-
Discount column missing on sales order
Dear community, I've a question regarding Dynamics NAV 5.0 (2007): Dear Community, perhaps someone can help me. The following: I have added a discount to some of the prices (under "line discounts"). When I create a "quote", these discounts are shown in a separate column, so far so good. However, when I create a "sales…
-
How to change the "Credit Limit (LCY)"
Dear community, I've a problem with Dynamics NAV 5.0 (2007): Could you please indicate how to modify the "Credit Limit (LCY)" of a customer. By default, I always have €1,000.00 filled in, but I want to give a customer more, but unfortunately I cannot edit the field on the customer record. Do you know how this works? I hope…
-
Doubt about SumIndexField
Hi friends... I have a doubt about SumIndexField in a Table Key.... I tried to find it on internet but I can't, so I hope one of you can clarify my doubt... I have one table (Table A) with many keys with diferent fields... and many of them have specified the same field as SumIndexField (Field "Total Importe producción"…
-
Database Restore Failure - Incorrect Checksum
Hi All, I am getting an error when I am restoring Database in NAV 2009 R2. "Database Restore Failure - incorrect Checksum" Can anyone please help me to restore. Raghubir