-
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
-
Application Management MAKEDATEFILTER
As usual, something I thought would be simple has turned into a dog-fight. I need to put a control on a report request form to collect a date filter. Looking at a stock example I went to form 490, Acc. Schedule Overview. There, the date filter is a textbox with the source expression "Acc. Schedule Line"."Date Filter". I…
-
Problem in our Stock
We have had some problems with historic stock. Although it was decided at the time that it would be too much work and too time intensive to correct. I’ve been looking and there is also a lack of continuity across different reports for the same stock item. I’ve taken 1 item that I know is a problem (C1144SA), along with…
-
Reverse charge - Business Central
Hi, We have received an invoice which the supplier has advised us we have to use Reverse Charge VAT. Please could you advise how this should be processed and any set up changes we need? We have to process postponed VAT and had to have changes made so I’, assuming this will be similar. Thank you.