Best Of
Re: Job Queue with Task Scheduler and User ID
Hi, we faced the same issue after upgrading to 2017 some time ago. I am not sure about your version, but in ours there were not sufficient events to subscribe to so we ended up having to modify the MS code.
When a Job Queue Entry is Inserted/Rescheduled etc, we added an IF condition to ensure the field "User ID" is only overwritten with "USERID" if it is currently empty.
We also had to customise the code in COD453 - "EnqueueJobQueueEntry"
so after the Task has been scheduled, we modify the user set on the Scheduled Task, to the User ID of the Job Queue Entry.
TASKSCHEDULER.CREATETASK does not have a parameter for User ID, so we had to resort to renaming it after the Scheduled Task had been created.
In your version they may have added an event "OnAfterJobQueueScheduleTask" which you could subscribe to, in order to make this change. Which is how we would have done it, but the event doesn't exist in our version.
When a Job Queue Entry is Inserted/Rescheduled etc, we added an IF condition to ensure the field "User ID" is only overwritten with "USERID" if it is currently empty.
We also had to customise the code in COD453 - "EnqueueJobQueueEntry"
so after the Task has been scheduled, we modify the user set on the Scheduled Task, to the User ID of the Job Queue Entry.
TASKSCHEDULER.CREATETASK does not have a parameter for User ID, so we had to resort to renaming it after the Scheduled Task had been created.
In your version they may have added an event "OnAfterJobQueueScheduleTask" which you could subscribe to, in order to make this change. Which is how we would have done it, but the event doesn't exist in our version.
Re: Access Username & Password protected folder share (Windows) through NAV 5.0
I used following scenario a years before:
net use <drive letter> <path> /user <name> <password>
...do something
net use <drive letter> /delete
net use <drive letter> <path> /user <name> <password>
...do something
net use <drive letter> /delete
lubost
5
Re: What are the fields (Date, document no., Amount ..etc..)nav 2016 use auto match bank reconciliation
I guess posting date and amount. I don't think there is any kind of configuration to set the rules. Now, we've a specific software for bank reconciliation and the criteria is quite the same.
KTA8
5
Re: Virtual table : 2000000082 Report Layout - empty
System table has certain Protocols unlike of that Usual NAV Tables.
Read it Please -
https://docs.microsoft.com/en-us/dynamics-nav/system-tables
Read it Please -
https://docs.microsoft.com/en-us/dynamics-nav/system-tables
Re: Remove SQL modifications after uninstalling and unpublishing NAVapp
Try
Sync-NAVApp -ServerInstance $ServerIns -Name ''XXX -Mode Clean
Sync-NAVApp -ServerInstance $ServerIns -Name ''XXX -Mode Clean
SanderDk
6
Re: How to show License permission in BC?
Weird one.
I can create a page to show license permissions, and if I set it as startupPageID it shows what I expected it to, but it is not searchable or showing up as a button.
If I change from using runobject to actually coding the page.runmodal it shows up as expected:
So the answer would be to change your button from RunObject to code on trigger OnAction
I can create a page to show license permissions, and if I set it as startupPageID it shows what I expected it to, but it is not searchable or showing up as a button.
If I change from using runobject to actually coding the page.runmodal it shows up as expected:
So the answer would be to change your button from RunObject to code on trigger OnAction
SanderDk
5
Re: Getting the First Date of a Shortage
In my opinion, create a report then define Item table to be data source. then recursive into sales order line to find the first date of shortage.
I just show you an example code for guiding (it need to be refined a little bit if you want more complete result).
I just show you an example code for guiding (it need to be refined a little bit if you want more complete result).
Item - OnAfterGetRecord()
CALCFIELDS(Inventory);
CLEAR(ShortageDate);
ShortageQty := Inventory;
SalesLine.RESET;
SalesLine.SETCURRENTKEY("Posting Date");
SalesLine.SETRANGE("Document Type",SalesLine."Document Type"::Order
SalesLine.SETRANGE(Type,SalesLine.Type::Item);
SalesLine.SETRANGE("No.",Item."No.");
IF SalesLine.FIND('-') THEN
REPEAT
SalesLine.CALCFIELDS("Posting Date");
ShortageQty := ShortageQty - SalesLine."Outstanding Qty. (Base)";
IF ShortageQty < 0 THEN
BEGIN
ShortageDate := SalesLine."Posting Date";
SO := SalesLine."Document No.";
END;
UNTIL (SalesLine.NEXT = 0) OR (ShortageQty < 0);
wolfskin
5
Re: File does not exist on NAV-server
The code happens on the NAV server, when you fileName := FileMgt.OpenFileDialog(XXXX) it browse the client.
When you use File.open(XXXX) you use server side.
The fix could be
ServerPath := FileMgt.UploadFileSilent(filename);
Myfile.open(ServerPath)
When you use File.open(XXXX) you use server side.
The fix could be
ServerPath := FileMgt.UploadFileSilent(filename);
Myfile.open(ServerPath)
SanderDk
5
Re: Round decimal field in report
MortenSteengaard wrote: »Thanks a lot BlackTiger. I'll look into this next week.
I forgot to write that the report is made using the "Sections" and not "Layout". Is your answer still correct?
No. I meant RDLC reports. Use "ROUND(Value,0.01)" in control's expression.
Re: How to Add My Business on Mibuso?
For now, use the feedback form to let us know and we will contact you through mail.
In the future it should be possible to maintain your data through the website though.
In the future it should be possible to maintain your data through the website though.
