Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
NAV/Navision Classic Client
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.7K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
317
Dynamics CRM
109
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.6K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
259
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Documentation for data conversion from 3.7 to 4.0
support1
Member
Posts:
18
2005-06-05
edited 2005-06-07
in
NAV/Navision Classic Client
I have a customer that wants to upgrade from Navision 3.7 to 4.0 and I am trying to find documentation on how to convert the data. I am hoping that someone can tell me where to find this. Any information would be greatly appreciated.
0
Comments
Tim81
Member
Posts:
68
2005-06-06
What about the "Microsoft Business Solutions - Navision 4.0 Upgrade Toolkit"?? Download it from PartnerGuide and read the instructions.
0
JanStepanek
Member
Posts:
6
2005-06-07
This is Microsoft fix (NA 4.00 SP2):
Codeunit 104048 Upgrade 4.00 Step 2:
=== Before ===
IF ("Invoiced Quantity" <> 0) AND BalanceExpected THEN BEGIN
TotalInvoicedQty := TotalInvoicedQty + "Invoiced Quantity";
IF TotalInvoicedQty = ItemLedgEntry.Quantity THEN BEGIN
InvoicedQty := TotalInvoicedQty;
CALCSUMS(
"Cost Amount (Expected)","Cost Amount (Expected) (ACY)","Sales Amount (Expected)","Purchase Amount (Expected)");
CostAmtExpected := "Cost Amount (Expected)";
CostAmtExpectedACY := "Cost Amount (Expected) (ACY)";
SalesAmtExpected := "Sales Amount (Expected)";
PurchaseAmtExpected := "Purchase Amount (Expected)";
END ELSE
InvoicedQty := "Invoiced Quantity";
======
=== After ===
IF ("Invoiced Quantity" <> 0) AND BalanceExpected THEN BEGIN
TotalInvoicedQty := TotalInvoicedQty + "Invoiced Quantity";
IF TotalInvoicedQty = ItemLedgEntry.Quantity THEN BEGIN
InvoicedQty := TotalInvoicedQty;
// Mod begin
ValueEntry2.copy(ValueEntry);
ValueEntry2.FIND;
ValueEntry2.CALCSUMS(
"Cost Amount (Expected)","Cost Amount (Expected) (ACY)","Sales Amount (Expected)","Purchase Amount (Expected)");
"Cost Amount (Expected)" := ValueEntry2."Cost Amount (Expected)";
"Cost Amount (Expected) (ACY)" := ValueEntry2."Cost Amount (Expected) (ACY)";
"Sales Amount (Expected)" := ValueEntry2."Sales Amount (Expected)";
"Purchase Amount (Expected)" := ValueEntry2."Purchase Amount (Expected)";
// mod end
CostAmtExpected := "Cost Amount (Expected)";
CostAmtExpectedACY := "Cost Amount (Expected) (ACY)";
SalesAmtExpected := "Sales Amount (Expected)";
====
BR,
Jan Stepanek
0
Sign In
or
Register
to comment.
Comments
Codeunit 104048 Upgrade 4.00 Step 2:
=== Before ===
IF ("Invoiced Quantity" <> 0) AND BalanceExpected THEN BEGIN
TotalInvoicedQty := TotalInvoicedQty + "Invoiced Quantity";
IF TotalInvoicedQty = ItemLedgEntry.Quantity THEN BEGIN
InvoicedQty := TotalInvoicedQty;
CALCSUMS(
"Cost Amount (Expected)","Cost Amount (Expected) (ACY)","Sales Amount (Expected)","Purchase Amount (Expected)");
CostAmtExpected := "Cost Amount (Expected)";
CostAmtExpectedACY := "Cost Amount (Expected) (ACY)";
SalesAmtExpected := "Sales Amount (Expected)";
PurchaseAmtExpected := "Purchase Amount (Expected)";
END ELSE
InvoicedQty := "Invoiced Quantity";
======
=== After ===
IF ("Invoiced Quantity" <> 0) AND BalanceExpected THEN BEGIN
TotalInvoicedQty := TotalInvoicedQty + "Invoiced Quantity";
IF TotalInvoicedQty = ItemLedgEntry.Quantity THEN BEGIN
InvoicedQty := TotalInvoicedQty;
// Mod begin
ValueEntry2.copy(ValueEntry);
ValueEntry2.FIND;
ValueEntry2.CALCSUMS(
"Cost Amount (Expected)","Cost Amount (Expected) (ACY)","Sales Amount (Expected)","Purchase Amount (Expected)");
"Cost Amount (Expected)" := ValueEntry2."Cost Amount (Expected)";
"Cost Amount (Expected) (ACY)" := ValueEntry2."Cost Amount (Expected) (ACY)";
"Sales Amount (Expected)" := ValueEntry2."Sales Amount (Expected)";
"Purchase Amount (Expected)" := ValueEntry2."Purchase Amount (Expected)";
// mod end
CostAmtExpected := "Cost Amount (Expected)";
CostAmtExpectedACY := "Cost Amount (Expected) (ACY)";
SalesAmtExpected := "Sales Amount (Expected)";
====
BR,
Jan Stepanek