Best Of
Re: Username authentication from WebClient.
UserName is Windows auth.
Maybe you mean NavUserPassword..?
Server Instance need to match client.
So Create a second instance.
Maybe you mean NavUserPassword..?
Server Instance need to match client.
So Create a second instance.
Juhl
5
Re: Can you help on 64 bit encoding please?
[Topic closed because of double posting]
See https://forum.mibuso.com/discussion/69516
This topic will be deleted after a week.
See https://forum.mibuso.com/discussion/69516
This topic will be deleted after a week.
kriki
5
Re: [Nav 2016] Problems with xRec.Status
Hi, I worked a bit on this and found that by doing an xRec.GET before testing Rec vs xRec it will work.
And you can even trick the system and do it in the OnAfterModify event if you have another event subscriber get the xRec OnBeforeModify and DON'T get it in your OnAfterModify event subscriber.
Try something like this:
And you can even trick the system and do it in the OnAfterModify event if you have another event subscriber get the xRec OnBeforeModify and DON'T get it in your OnAfterModify event subscriber.
Try something like this:
OnRun()
Bin.GET('BLUE','A1');
Bin.Description := FORMAT(CURRENTDATETIME);
Bin.MODIFY;
LOCAL [EventSubscriber] BinOnBeforeModify(VAR Rec : Record Bin;VAR xRec : Record Bin;RunTrigger : Boolean)
xRec.GET(Rec."Location Code",Rec.Code);
MESSAGE('xRecBeforeModifyEvent: '+xRec.Description+'\'+'RecBeforeModifyEvent: '+Rec.Description);
LOCAL [EventSubscriber] BinOnAfterModify(VAR Rec : Record Bin;VAR xRec : Record Bin;RunTrigger : Boolean)
//xRec.GET(Rec."Location Code",Rec.Code);
MESSAGE('xRecAfterModifyEvent: '+xRec.Description+'\'+'RecAfterModifyEvent: '+Rec.Description);
Re: vendor summary aging
Hi,
I dont know what version of nav you are running.
anyway I looked for that code in R305 and it is like this on integer predataitem event:
IF PrintAmountsInLCY OR NOT PrintLine THEN
CurrReport.BREAK;
Currency2.RESET;
Currency2.SETRANGE("Vendor Filter",Vendor."No.");
Vendor.COPYFILTER("Currency Filter",Currency2.Code);
IF (Vendor.GETFILTER("Global Dimension 1 Filter") <> '') OR
(Vendor.GETFILTER("Global Dimension 2 Filter") <> '')
THEN BEGIN
Vendor.COPYFILTER("Global Dimension 1 Filter",Currency2."Global Dimension 1 Filter");
Vendor.COPYFILTER("Global Dimension 2 Filter",Currency2."Global Dimension 2 Filter");
END;
on aftergetrecord:
IF Number = 1 THEN
Currency2.FIND('-')
ELSE
IF Currency2.NEXT = 0 THEN
CurrReport.BREAK;
Currency2.CALCFIELDS("Vendor Ledg. Entries in Filter");
IF NOT Currency2."Vendor Ledg. Entries in Filter" THEN
CurrReport.SKIP;
PrintLine := FALSE;
LineTotalVendAmountDue := 0;
FOR i := 1 TO 5 DO BEGIN
DtldVendLedgEntry.SETCURRENTKEY("Vendor No.","Initial Entry Due Date");
DtldVendLedgEntry.SETRANGE("Vendor No.",Vendor."No.");
DtldVendLedgEntry.SETRANGE("Initial Entry Due Date",PeriodStartDate,PeriodStartDate[i + 1] - 1);
DtldVendLedgEntry.SETRANGE("Currency Code",Currency2.Code);
DtldVendLedgEntry.CALCSUMS(Amount);
VendBalanceDue := DtldVendLedgEntry.Amount;
InVendBalanceDueLCY := InVendBalanceDueLCY2;
IF VendBalanceDue <> 0 THEN
PrintLine := TRUE;
LineTotalVendAmountDue := LineTotalVendAmountDue + VendBalanceDue;
END;
I would suggest see if dtldVendLedgEntry.''Initial Entry Global Dim. 1" has values using debugger, see what filters have been applied to vendor and so on.
I dont know what version of nav you are running.
anyway I looked for that code in R305 and it is like this on integer predataitem event:
IF PrintAmountsInLCY OR NOT PrintLine THEN
CurrReport.BREAK;
Currency2.RESET;
Currency2.SETRANGE("Vendor Filter",Vendor."No.");
Vendor.COPYFILTER("Currency Filter",Currency2.Code);
IF (Vendor.GETFILTER("Global Dimension 1 Filter") <> '') OR
(Vendor.GETFILTER("Global Dimension 2 Filter") <> '')
THEN BEGIN
Vendor.COPYFILTER("Global Dimension 1 Filter",Currency2."Global Dimension 1 Filter");
Vendor.COPYFILTER("Global Dimension 2 Filter",Currency2."Global Dimension 2 Filter");
END;
on aftergetrecord:
IF Number = 1 THEN
Currency2.FIND('-')
ELSE
IF Currency2.NEXT = 0 THEN
CurrReport.BREAK;
Currency2.CALCFIELDS("Vendor Ledg. Entries in Filter");
IF NOT Currency2."Vendor Ledg. Entries in Filter" THEN
CurrReport.SKIP;
PrintLine := FALSE;
LineTotalVendAmountDue := 0;
FOR i := 1 TO 5 DO BEGIN
DtldVendLedgEntry.SETCURRENTKEY("Vendor No.","Initial Entry Due Date");
DtldVendLedgEntry.SETRANGE("Vendor No.",Vendor."No.");
DtldVendLedgEntry.SETRANGE("Initial Entry Due Date",PeriodStartDate,PeriodStartDate[i + 1] - 1);
DtldVendLedgEntry.SETRANGE("Currency Code",Currency2.Code);
DtldVendLedgEntry.CALCSUMS(Amount);
VendBalanceDue := DtldVendLedgEntry.Amount;
InVendBalanceDueLCY := InVendBalanceDueLCY2;
IF VendBalanceDue <> 0 THEN
PrintLine := TRUE;
LineTotalVendAmountDue := LineTotalVendAmountDue + VendBalanceDue;
END;
I would suggest see if dtldVendLedgEntry.''Initial Entry Global Dim. 1" has values using debugger, see what filters have been applied to vendor and so on.
txeriff
5
Re: How can I read all the files from a path?
The problem is almost certain no access.
If the server accesses a file, it does so with the credentials of the service user.
If you want to access a file with the credentials of the client user, upload it first (or, if you absolutely must, use client side Dotnet).
If the server accesses a file, it does so with the credentials of the service user.
If you want to access a file with the credentials of the client user, upload it first (or, if you absolutely must, use client side Dotnet).
vaprog
1
Re: First NAV 2013 R2 to NAV 2016 upgrade failing : The UPG Item does not exist
Sync-NAVTenant without -Force should be the solution but is not practicable in customer databases. In our update we came from NAV 2009 with many modules over 2013 and there are tons of unused fields in the upgraded database which are removed fine with Sync-NAVTenant -Force. For me the following modification of CU 104000 did the trick:
[UpgradePerCompany] UpdateItemNextCountingPeriod()
WITH Item DO BEGIN
IF FINDSET THEN
REPEAT
//Change++
//UPGItem.GET("No.");
IF NOT UPGItem.GET(Item."No.") THEN BEGIN
UPGItem."No." := Item."No.";
UPGItem.INSERT;
END;
//Change--
ForwardPeriodInfo(
UPGItem."Next Counting Period","Next Counting Start Date","Next Counting End Date");
MODIFY;
UNTIL NEXT = 0;
END;
[UpgradePerCompany] UpdateItemNextCountingPeriod()
WITH Item DO BEGIN
IF FINDSET THEN
REPEAT
//Change++
//UPGItem.GET("No.");
IF NOT UPGItem.GET(Item."No.") THEN BEGIN
UPGItem."No." := Item."No.";
UPGItem.INSERT;
END;
//Change--
ForwardPeriodInfo(
UPGItem."Next Counting Period","Next Counting Start Date","Next Counting End Date");
MODIFY;
UNTIL NEXT = 0;
END;
hitt123
5
Re: Order Import through XML Skips Order Nr
NAV Sets the order number when importing via XML automatically. So if it is skipping 1 every time, check the posted order document for that skipped number. If its not there , then i guess there must be a problem/modification in no series management which is causing this error.
devdrone
5
Re: Detecting the Development Environment (classic client) license
You can only check license programmatically when C/AL code is executed. The DEV Env does not run execute any NAV code anymore.
Even if you change the license temporarily in DEV Env it will only allow you to modify objects. If you try to run any of object it will be run by the NST with the license uploaded into the server/database, not with the license loaded temporarily into DEV Env.
Slawek
Even if you change the license temporarily in DEV Env it will only allow you to modify objects. If you try to run any of object it will be run by the NST with the license uploaded into the server/database, not with the license loaded temporarily into DEV Env.
Slawek
