存档

2017年9月 的存档

NAV2017 累计更新- 10#

2017年9月29日 没有评论

 

Cumulative Update 10 for Microsoft Dynamics NAV 2017 (Build 18197)

发布版本号 Build No. – 18197

发布日期 Release Date – 2017年9月

下载链接

更新项:

ID

Title

Functional area

Changed objects

221853

A notification email is sent to an incorrect recipient when a document is rejected.

Administration

COD 1535

222410

Writing/Handling of temporary records causes a physical write.

Administration

COD 1521 COD 1535 COD 1550

222512

"Root element is missing are surfaced when debugging My Notifications" error message when a call to System.Xml.XmlDocument.Load fails.

Administration

COD 1530 COD 6224

222564

Recurring failed job queue entries are deleted if another job queue entry that uses the same report with different parameters is successful.

Administration

COD 453

222577

The Maximum No. of Attempts to Run function does not work for a job query that has been set to Ready again or Restarted.

Administration

TAB 472

222608

Job queue log entries are recreated incorrectly with a different GUID when you reopen the client and the Task Scheduler function is enabled.

Administration

COD 455

222692

Text variable in the Send Incoming Document to OCR codeunit is incorrect.

Administration

COD 133

222724

All tables are exported when you change the status of a table to the Completed status and run the Export to Template function.

Administration

COD 8616

222891

The Remaining Amount field is displayed as 0 and the Close field is displayed as Yes for unpaid posted prepayment invoices.

Administration

COD 442 COD 444

223526

"An attempt was made to change an old version of an Approval Entry record. The record should… (continued)" error message if you reject an approval request.

Administration

COD 1535

223667

On the User Card page, when you try to assign a Windows user name that is already assigned to another Dynamics NAV user, the error message that displays does include the Windows user name that you are trying to assign.

Administration

PAG 9807

223694

Test Toolkit error message that is related to the mandatory English language usage leaves the dialog in a suspended state.

Administration

COD 130400

224171

The Suggest Vendor Payments function does not work correctly with the last used options and filters function.

Administration

REP 393

224319

The company creation wizard allows spaces in company names.

Administration

PAG 9192

225224

If you enter an approval comment, the posted approval comment line is empty and the Comment field on the Posted Approval Entries page displays “No”.

Administration

COD 1535

223614

The Bank Acc.-Det.Trial Bal. report displays a value of 0 and a continued text on the first and second page if the report spans over multiple pages.

Cash Management

REP 1404

223618

"You must apply the excessive amount of [variable] manually" error message if you try to post a payment reconciliation journal with bank account that is the Account type.

Cash Management

COD 370

221818

When you attempt to post a sales order, the error message that is displayed during the Preview Posting process is different than the received message.

Finance

COD 19

221966

On the Adjust Exchange Rates report, the description in general journal lines is truncated.

Finance

REP 595

222694

Missing VAT entries after you unapply for credit memos and invoices when using the Adjust for Paym. Discount function.

Finance

COD 12

223267

On the Account Schedule page, the Underline and Double Underline options print a line across the whole page instead of a line for each column.

Finance

REP 25

223290

If you block a dimension value of a global dimension code, the blocked value is displayed when you look up the page’s dimension value list, and it is not displayed if the blocked dimension value belongs to other dimension codes.

Finance

TAB 36 TAB 37 TAB 38 TAB 39 TAB 5900 TAB 5901 TAB 5902 TAB 81

224721

The Request page of the Trial Balance report displays an unwanted Integer tab.

Finance

REP 6

221770

Inconsistent standard cost calculation when it is run from an item card or when statistics is displayed in a production order.

Inventory

COD 5836

223061

"The value "2,4" can’t be evaluated into type Decimal" error message when you validate the Default Value column on the Item Category page.

Inventory

PAG 5734 PAG 7504 TAB 7501 TAB 7504

223070

The Line Dimension column does not display any value on the Post Inventory Cost to G/L report in Preview.

Inventory

COD 5802 REP 1002

223204

The Filter by Attributes function displays incorrect items.

Inventory

COD 7500

223256

The record from Item Attribute Value Mapping table is not deleted when the related item is deleted.

Inventory

TAB 27

223288

The Unit Amount field on the Item Journal page is incorrect when the line has a positive adjustment and you use an alternate unit of measure.

Inventory

TAB 753 TAB 83

223453

The Item Attribute Value Mapping table is assigned incorrect values when you enter 0 in a decimal type attribute.

Inventory

PAG 7504

218919

If you delete a job card, there is no check whether there are unposted time sheets.

Jobs

COD 361

221003

You cannot manage the planning and invoicing of a job in a foreign currency when the customer has the foreign currency.

Jobs

PAG 88 TAB 167

223034

It is possible to enter and submit (and approve) time sheet lines that are associated with a resource where the Blocked check box is selected.

Jobs

TAB 950 TAB 951

224283

The Invoiced Date and Transferred Date fields are not populated on the Job Invoices page.

Jobs

PAG 1029 TAB 1003

222065

"Status must be equal to ‘Certified’  in Production BOM Header: No.=X. Current value is ‘Closed’" error message when you run the Calc. Regenerative Plan function on the Planning Worksheet page.

Manufacturing

TAB 246

222194

The Calculate Net Change Plan function generates inconsistent results depending upon whether the Item Card page has parameters set on the Planning tab or whether or only the stockkeeping unit is set up under the Location Mandatory setup.

Manufacturing

TAB 99000850

222611

When you use the Combine Transfer Orders option, the Carry out in Planning Worksheet page does not combine all requisition lines that have the same transfer-from and transfer-to locations into the same transfer order.

Manufacturing

REP 99001020

222911

The Scrap % field is considered twice when you create a production BOM where one component is also defined as a production BOM.

Manufacturing

COD 99000773

223038

Performance issue when you certify a routing.

Manufacturing

COD 99000752

223174

The Qty. to Reserve and Unreserved Quantity fields display incorrect quantities on the Reservation page header when you run the Reserve action from the Planning Worksheet page for a manufactured item where suggested quantity is greater than 1.

Manufacturing

PAG 498

223253

"Previous Operations for "Item no" cannot be found" error message when you post an output for a released production order from an inventory put-away. The output cannot be posted when the location includes the Bin Mandatory and Require Put-away settings.

Manufacturing

COD 99000772

223571

The IC Partner Code field is missing on the Vendor Card page.

Purchase

PAG 26

224000

The Order report prints incorrect amounts when the purchase order has a prepayment and the Show Internal Information option is checked.

Purchase

REP 405

224764

The Vendor Item No. field from Stockkeeping Unit Card page is not validated on the Requisition Worksheet page.

Purchase

TAB 246

220434

Outlook Add-in does not set the time correctly when the Services Default Time Zone field is set to Serve Time Zone.

Sales

COD 5301 COD 5302

221651

If you create a new sales order from the Blanket Sales Order page, the Document Date field is filled with the document date of the blanket sales order.

Sales

COD 87 COD 97 TAB 38

213363

Standard Report logo needs to be set to FitProportional instead of Fit or Original to avoid image stretch or overlap.

Sales

REP 116 REP 117 REP 118 REP 1304 REP 1305 REP 1306 REP 1307 REP 1316 REP 204 REP 205 REP 206 REP 207 REP 208 REP 210 REP 215 REP 216 REP 418 REP 5900 REP 5902 REP 5911 REP 5912 REP 5913 REP 5970 REP 5972 REP 6631 REP 6646 REP 28072 REP 28074 REP 10069 REP 10073 REP 10074 REP 10075 REP 10076 REP 10077 REP 10473 REP 10474 REP 11730 REP 11731 REP 11732 REP 11733 REP 31000 REP 31001 REP 31002 REP 31020 REP 31021 REP 31022 REP 31088 REP 31089 REP 31090 REP 31091 REP 31092 REP 31093 REP 31094 REP 31095 REP 31096 REP 31097 REP 31098 REP 31099 REP 10570 REP 10571 REP 10572 REP 10573 REP 10574 REP 16555 REP 12154

223056

"Fields!SelltoCustNo_SalesHdrCaption.Value" error message if you print the Sales Return Order Confirmation report and the sell-to customer is different than the bill-to customer.

Sales

REP 6631

223272

Some reports are printed with the Letter format when they should use the A4 format.

Sales

REP 205

223274

The Order Confirmation report uses the Letter format by default.

Sales

REP 205

223282

Inconsistent error messages occur when you try to post, ship, or invoice a sales order with prepayments.

Sales

COD 80 COD 90

223294

"The following C/AL functions are limited during write transactions because one or more tables will be locked" error message when you validate the blanket order number on the Sales Order page.

Sales

TAB 37

223431

Make the task of changing a contact on the sales order header more usable.

Sales

PAG 41 PAG 42 PAG 43 PAG 507

223518

"Type must not be in Sales Line: Document Type=Return Order, Document No.=X, Line No.=Y" error message when you change the bill-to customer in a sales return order.

Sales

TAB 37 TAB 39

222748

Interactions that are saved to disk cannot be opened after an upgrade.

Upgrade

REP 5181 TAB 5062

223342

"The Warehouse Journal Batch already exists. Identification fields and values: Journal Template Name=’RECLASS’,Name=’DEFAULT’,Location Code=’WHITE’" error message when you select a warehouse periodic activity.

Warehouse

COD 7302 TAB 7310 TAB 7311 TAB 7337 TAB 7338

223762

Items are not picked according to FEFO when you run the Calculate Bin Replenishment function and create movements.

Warehouse

COD 7312

223765

Created picks only partially recognize available units while there are more units available with another lot number and expiration date.

Warehouse

COD 7312

224615

"The filter "|WHITE" is not valid for the Location Code field on the Warehouse Request table. The left side of ‘|’ operators cannot be empty" error message when you create warehouse shipments for a sales order where an item with a service type exists.

Warehouse

COD 5751 COD 5752

分类: Uncategorized 标签:

NAV2016 累计更新- 23#

2017年9月29日 没有评论

 

Cumulative Update 23 for Microsoft Dynamics NAV 2016 (Build 49146)

发布版本号 Build No. – 49146

发布日期 Release Date – 2017年9月

下载链接

更新项:

ID

Title

Functional area

Changed objects

221829

On the User Card page, when you try to assign a Windows user name that is already assigned to another Dynamics NAV user, the error message that displays does include the Windows user name that you are trying to assign.

Administration

PAG 9807

224078

If you enter an approval comment, the posted approval comment line is empty and the Comment field on the Posted Approval Entries page displays “No”.

Administration

COD 1535

220826

Slow performance when you post a large number of G/L transactions through a recurring journal.

Cash Management

COD 13

221094

If you block a dimension value of a global dimension code, the blocked value is displayed when you look up the page’s dimension value list, and it is not displayed if the blocked dimension value belongs to other dimension codes.

Finance

TAB 36 TAB 37 TAB 38 TAB 39 TAB 5900 TAB 5901 TAB 5902 TAB 81

223277

Missing VAT entries after you unapply for credit memos and invoices when using the Adjust for Paym. Discount function.

Finance

COD 12

223792

On the Adjust Exchange Rates report, the description in general journal lines is truncated.

Finance

REP 595

224720

The Request page of the Trial Balance report displays an unwanted Integer tab.

Finance

REP 6

222394

The Unit Amount field on the Item Journal page is incorrect when the line has a positive adjustment and you use an alternate unit of measure.

Inventory

TAB 753 TAB 83

218918

If you delete a job card, there is no check whether there are unposted time sheets.

Jobs

COD 361

221002

You cannot manage the planning and invoicing of a job in a foreign currency when the customer has the foreign currency.

Jobs

PAG 88 TAB 167

224282

The Invoiced Date and Transferred Date fields are not populated on the Job Invoices page.

Jobs

PAG 1029 TAB 1003

224897

It is possible to enter and submit (and approve) time sheet lines that are associated with a resource where the Blocked check box is selected.

Jobs

TAB 950 TAB 951

222383

The Order report prints incorrect amounts when the purchase order has a prepayment and the Show Internal Information option is checked.

Purchase

REP 405

223035

The Vendor Item No. field from Stockkeeping Unit Card page is not validated on the Requisition Worksheet page.

Purchase

TAB 246

220433

Outlook Add-in does not set the time correctly when the Services Default Time Zone field is set to Serve Time Zone.

Sales

COD 5301 COD 5302

221756

"The following C/AL functions are limited during write transactions because one or more tables will be locked" error message when you validate the blanket order number on the Sales Order page.

Sales

TAB 37

222527

Some reports are printed with the Letter format when they should use the A4 format.

Sales

REP 205

222537

The Order Confirmation report uses the Letter format by default.

Sales

REP 205

223281

Inconsistent error messages occur when you try to post, ship, or invoice a sales order with prepayments.

Sales

COD 80 COD 90

223517

"Type must not be in Sales Line: Document Type=Return Order, Document No.=DocumentNumber, Line No.=LineNumber" error message when you change the bill-to customer in a sales return order.

Sales

TAB 37 TAB 39

218658

Created picks only partially recognize available units while there are more units available with another lot number and expiration date.

Warehouse

COD 7312

222722

"The filter "|WHITE" is not valid for the Location Code field on the Warehouse Request table. The left side of ‘|’ operators cannot be empty" error message when you create warehouse shipments for a sales order where an item with a service type exists.

Warehouse

COD 5751 COD 5752

223761

Items are not picked according to FEFO when you run the Calculate Bin Replenishment function and create movements.

Warehouse

COD 7312

分类: Uncategorized 标签:

NAV2015 累计更新- 35#

2017年9月29日 没有评论

 

Cumulative Update 35 for Microsoft Dynamics NAV 2015 (Build 49144)

发布版本号 Build No. – 49144

发布日期 Release Date – 2017年9月

下载链接

更新项:

ID

Title

Functional area

Changed objects

221835

On the Account Schedule Overview page, if you set the Dimension filter field using “*”and drill down on the values, the filter on the drill down page is incorrectly set.

Finance

COD 408 PAG 490

223793

On the Adjust Exchange Rates report, the description in general journal lines is truncated.

Finance

REP 595

223889

The Request page of the Trial Balance report displays an unwanted Integer tab.

Finance

REP 6

223888

Assemble-to-Order link record is not deleted when you change Qty. to Assemble to Order field to 0 in sales order lines.

Inventory

TAB 904

221001

You cannot manage the planning and invoicing of a job in a foreign currency when the customer has the foreign currency.

Jobs

PAG 88 TAB 167

222559

The Invoiced Date and Transferred Date fields are not populated on the Job Invoices page.

Jobs

PAG 1029 TAB 1003

224896

It is possible to enter and submit (and approve) time sheet lines that are associated with a resource where the Blocked check box is selected.

Jobs

TAB 950 TAB 951

220325

Outlook Add-in does not set the time correctly when the Services Default Time Zone field is set to Serve Time Zone.

Sales

COD 5301 COD 5302

223280

Inconsistent error messages occur when you try to post, ship, or invoice a sales order with prepayments.

Sales

COD 80 COD 90

223516

"Type must not be in Sales Line: Document Type=Return Order, Document No.=DocumentNumber, Line No.=LineNumber" error message when you change the bill-to customer in a sales return order.

Sales

TAB 37 TAB 39

222190

Items are not picked according to FEFO when you run the Calculate Bin Replenishment function and create movements.

Warehouse

COD 7312

分类: Uncategorized 标签:

NAV2013R2 累计更新- 47#

2017年9月29日 没有评论

 

Cumulative Update 47 for Microsoft Dynamics NAV 2013 R2 (Build 49153)

发布版本号 Build No. – 49153

发布日期 Release Date – 2017年9月

下载链接

更新项:

ID

Title

Functional area

Changed objects

222804

Missing VAT entries after you unapply for credit memos and invoices when using the Adjust for Paym. Discount function.

Finance

COD 12

222565

Assemble-to-Order link record is not deleted when you change Qty. to Assemble to Order field to 0 in sales order lines.

Inventory

TAB 904

221000

You cannot manage the planning and invoicing of a job in a foreign currency when the customer has the foreign currency.

Jobs

PAG 88 TAB 167

224894

It is possible to enter and submit (and approve) time sheet lines that are associated with a resource where the Blocked check box is selected.

Jobs

TAB 950 TAB 951

221051

The Overdue Amounts (LCY) field on the Check Credit Limit page is calculated differently than the Overdue Amounts (LCY) field in the Customer Statistics FactBox.

Sales

PAG 343 PAG 9082 TAB 18

222044

Inconsistent error messages occur when you try to post, ship, or invoice a sales order with prepayments.

Sales

COD 80 COD 90

222055

"Type must not be in Sales Line: Document Type=Return Order, Document No.=X, Line No.=Y" error message when you change the bill-to customer in a sales return order.

Sales

TAB 37 TAB 39

分类: Uncategorized 标签:

NAV2013 累计更新 – 54#

2017年9月29日 没有评论

 

Cumulative Update 54 for Microsoft Dynamics NAV 2013 (Build 49147)

发布版本号 Build No. – 49147

发布日期 Release Date –  2017年9月

下载链接

更新项:

ID

Title

Functional area

Changed objects

224565

Analysis view budget entries are not updated if records in the G/L Budget Entries table are changed.

Finance

PAG 120 PAG 9203

223058

It is possible to enter and submit (and approve) time sheet lines that are associated with a resource where the Blocked check box is selected.

Jobs

TAB 950 TAB 951

分类: Uncategorized 标签:

记一次NAV项目升级之数据迁移(5)

2017年9月10日 没有评论

 

接下来进行数据上传,在NAV早期版本中,通常我们应用Dataport进行数据导入,但是从NAV2013开始,微软已经移除此功能,因此在这里介绍如何开发XMLPort并导入数据。

 

下面我们以导入Gen. Journal Line未示例介绍。

 

1. 首先创建XMLPort

2. 设置XMLPort结构如下:

Node Name

Prefix

Node Type

Source Type

Data Source

GenJournals

Element

Text

<GenJournals>

GenJournal

Element

Table

<Gen. Journal Line>(Gen. Journal Line)

  Line_No.

Element

Field

Gen. Journal Line::Line No.

  Account_Type

Element

Field

Gen. Journal Line::Account Type

  Account_No.

Element

Field

Gen. Journal Line::Account No.

  Description

Element

Field

Gen. Journal Line::Description

  Currency_Code

Element

Field

Gen. Journal Line::Currency Code

  Amount

Element

Field

Gen. Journal Line::Amount

 

3. 设置XMLPort属性

TextEncoding  为 UTF-8

Format 为 Variable Text

 

4. 设置Table GenJournal属性

Temporary 为 Yes

AutoSave 为 No

以上两项设置表示数据上传到当前记录时为临时存储,不保存到系统中。

 

5. 在Import: OnAfterInsertRecord后添加代码

Gen. Journal Line – Import::OnAfterInsertRecord()

WITH "Gen. Journal Line" DO BEGIN
  GenJls.INIT;
  GenJls."Journal Batch Name" := ‘DEFAULT’;
  GenJls."Journal Template Name" := ‘GENERAL’;
  GenJls."Line No." := "Line No.";
  GenJls."Posting Date" := 151231D;
  GenJls."Document No." := ‘Open2015’;
  GenJls.INSERT(TRUE);
  GenJls.VALIDATE("Account Type", "Account Type");
  GenJls.VALIDATE("Account No.", "Account No.");
  GenJls.VALIDATE(Description, Description);
  GenJls.VALIDATE("Currency Code", "Currency Code");
  GenJls.VALIDATE(Amount, Amount);
  GenJls.MODIFY(TRUE);
END;

 

6. 接下来执行运行XMLPort, 导入的文件格式如下所示:

"1000","12/31/2016","OPEN-20161231","G/L Account","11330400","Openning – 20161231","-900","SALES","","","","","","",""
"2000","12/31/2016","OPEN-20161231","G/L Account","11330400","Openning – 20161231","73186","","","","","","","",""

 

分别为Gen. Journal Line / Item Journal Line 创建导入分录并过账,即可完成业务数据导入升级。

 

至此,完成数据迁移。

分类: Uncategorized 标签:

记一次NAV项目升级之数据迁移(4)

2017年9月8日 没有评论

 

接下来执行业务数据迁移,由于需要对原来系统的G/L Entry, Item Ledger Entry, FA Ledger Entry, Bank Ledger Entry, Cust. Ledger Entry, Vendor Ledger Entry进行合并升级,因此,在这里引用了QlikView快速分析数据。

 

相关的数据抽取语句如下:

G/L Entry:

ABC:
Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_ABC]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘ABC’
;

CASHFLOW:
Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_CASHFLOW]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘CASHFLOW’
;
CHANNEL:Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_CHANNEL]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘CHANNEL’
;
CUSTOMER:Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_CUSTOMER]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘CUSTOMER’
;
DEPARTMENT:Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_DEPARTMENT]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘DEPARTMENT’
;
EMPLOYEE:Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_EMPLOYEE]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘EMPLOYEE’
;
GROUP:Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_GROUP]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘GROUP’
;
OTHER:Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_OTHER]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘OTHER’
;
[PRODUCT GROUP]:Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_PRODUCT GROUP]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘PRODUCT GROUP’
;
REGION:Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_REGION]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘REGION’
;
SKU:Mapping LOAD * ;
SQL Select
[Entry No_]
,[Dimension Value Code] as [Dim_SKU]
from [CRONUS$Ledger Entry Dimension]
where [Dimension Code] = ‘SKU’
;

GLEntry:
LOAD
     [Entry No_]
    ,[G_L Account No_]
    ,[Posting Date]
    ,[Document Type]
    ,[Document No_]
    ,[Amount]
    ,[Source Code]
    ,[System-Created Entry]
    ,[Debit Amount]
    ,[Credit Amount]
    ,ApplyMap(‘ABC’,"Entry No_",”) as Dim_ABC
    ,ApplyMap(‘CASHFLOW’,"Entry No_",”) as Dim_CASHFLOW
    ,ApplyMap(‘CHANNEL’,"Entry No_",”) as Dim_CHANNEL
    ,ApplyMap(‘CUSTOMER’,"Entry No_",”) as Dim_CUSTOMER
    ,ApplyMap(‘DEPARTMENT’,"Entry No_",”) as Dim_DEPARTMENT
    ,ApplyMap(‘EMPLOYEE’,"Entry No_",”) as Dim_EMPLOYEE
    ,ApplyMap(‘GROUP’,"Entry No_",”) as Dim_GROUP
    ,ApplyMap(‘OTHER’,"Entry No_",”) as Dim_OTHER
    ,ApplyMap(‘PRODUCT GROUP’,"Entry No_",”) as [Dim_PRODUCT GROUP]
    ,ApplyMap(‘REGION’,"Entry No_",”) as Dim_REGION
    ,ApplyMap(‘SKU’,"Entry No_",”) as Dim_SKU   
;
SQL Select
     [Entry No_]
    ,[G_L Account No_]
    ,[Posting Date]
    ,[Document Type]
    ,[Document No_]
    ,[Amount]
    ,[Source Code]
    ,[System-Created Entry]
    ,[Debit Amount]
    ,[Credit Amount]                                   
from [CRONUS$G_L Entry];

 

 

Item Ledger Entry:

LE:
SQL Select
    [Entry No_]
    ,[Item No_]
    ,[Posting Date]
    ,[Entry Type]
    ,[Document No_]
    ,[Description]
    ,[Location Code]
    ,[Quantity]
    ,[Remaining Quantity]
    ,[Open]
    ,[Document Date]
    ,[External Document No_]
    ,[Qty_ per Unit of Measure]
    ,[Unit of Measure Code]
    ,[Product Group Code]
    ,[Lot No_]
from [CRONUS$Item Ledger Entry];

VLE:
SQL Select
    [Inventory Posting Group]
    ,[Item Ledger Entry No_] as [Entry No_]
    ,[Valued Quantity]
    ,[Item Ledger Entry Quantity]
    ,[Cost per Unit]
    ,[Cost Amount (Actual)]
    ,[Purchase Amount (Actual)]
    ,[Purchase Amount (Expected)]
    ,[Sales Amount (Expected)]
    ,[Cost Amount (Expected)]
    ,[Expected Cost Posted to G_L]
from [CRONUS$Value Entry];

 

Bank Ledger Entry:

BankLedgerEntry:
SQL Select
[Entry No_]
,[Bank Account No_]
,[Posting Date]
,[Document Type]
,[Document No_]
,[Currency Code]
,[Amount]
,[Remaining Amount]
,[Amount (LCY)]
,[Bank Acc_ Posting Group]
,[Document Date]
from [CRONUS$Bank Account Ledger Entry]

 

FA Ledger Entry:

[Acquisition Cost]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 0
    group by [FA No_]
;
[Depreciation]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 1
    group by [FA No_]
;
[Write-Down]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 2
    group by [FA No_]
;
[Appreciation]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 3
    group by [FA No_]
;
[Custom 1]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 4
    group by [FA No_]
;
[Custom 2]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 5
    group by [FA No_]
;
[Proceeds on Disposal]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 6
    group by [FA No_]
;
[Salvage Value]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 7
    group by [FA No_]
;

[Gain_Loss]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 8
    group by [FA No_]
;
[Book Value on Disposal]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 0 and [FA Posting Type] = 9
    group by [FA No_]
;
[Disposal Acquisition Cost]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 1 and [FA Posting Type] = 0
    group by [FA No_]
;
[Disposal Depreciation]:
Mapping LOAD * ;
SQL SELECT
     [FA No_]
    ,sum(Amount)
    From [CRONUS$FA Ledger Entry] where [FA Posting Category] = 1 and [FA Posting Type] = 1
    group by [FA No_]
;

FADepBooks:
LOAD
[FA No_]
,[Depreciation Book Code]
,[Depreciation Method]
,[Depreciation Starting Date]
,[FA Posting Group]
,[Acquisition Date]
,[G_L Acquisition Date]
,[Disposal Date]
,[Last Acquisition Cost Date]
,[Last Depreciation Date]

,ApplyMap(‘Acquisition Cost’,"FA No_",0) as [Amt_Acquisition Cost]
,ApplyMap(‘Depreciation’,"FA No_",0) as [Amt_Depreciation]
,ApplyMap(‘Write-Down’,"FA No_",0) as [Amt_Write-Down]
,ApplyMap(‘Appreciation’,"FA No_",0) as [Amt_Appreciation]
,ApplyMap(‘Custom 1’,"FA No_",0) as [Amt_Custom 1]
,ApplyMap(‘Custom 2’,"FA No_",0) as [Amt_Custom 2]
,ApplyMap(‘Proceeds on Disposal’,"FA No_",0) as [Amt_Proceeds on Disposal]
,ApplyMap(‘Salvage Value’,"FA No_",0) as [Amt_Salvage Value]
,ApplyMap(‘Gain_Loss’,"FA No_",0) as [Amt_Gain/Loss]
,ApplyMap(‘Book Value on Disposal’,"FA No_",0) as [Amt_Book Value on Disposal]
,ApplyMap(‘Disposal Acquisition Cost’,"FA No_",0) as [Amt_Disposal Acquisition Cost]
,ApplyMap(‘Disposal Depreciation’,"FA No_",0) as [Amt_Disposal Depreciation]
;
SQL Select
[FA No_]
,[Depreciation Book Code]
,[Depreciation Method]
,[Depreciation Starting Date]
,[FA Posting Group]
,[Acquisition Date]
,[G_L Acquisition Date]
,[Disposal Date]
,[Last Acquisition Cost Date]
,[Last Depreciation Date]
From [CRONUS$FA Depreciation Book]

 

Cust. Ledger Entry:

CustLedgEntry:
SQL Select
[Entry No_]
,[Customer No_]
,[Posting Date]
,[Document Type]
,[Document No_]
,[Currency Code]
,[Sell-to Customer No_]
,[Customer Posting Group]
,[Salesperson Code]
,[Due Date]
,[Positive]
from [CRONUS$Cust_ Ledger Entry]
;

DetailedCustLedgEntry:
SQL Select
[Cust_ Ledger Entry No_] as [Entry No_]
,[Amount]
,[Amount (LCY)]
,[Currency Code] as DetailedCurrency
from [CRONUS$Detailed Cust_ Ledg_ Entry]
;

 

Vendor Ledger Entry:

VendLedgEntry:
SQL Select
[Entry No_]
,[Vendor No_]
,[Posting Date]
,[Document Type]
,[Document No_]
,[Currency Code]
,[Vendor Posting Group]
,[Due Date]
from [CRONUS$Vendor Ledger Entry]
;

DetailedVendLedgEntry:
SQL Select
[Vendor Ledger Entry No_] as [Entry No_]
,[Amount]
,[Amount (LCY)]
,[Currency Code] as DetailedCurrency
from [CRONUS$Detailed Vendor Ledg_ Entry]

 

通过上表,即可得到完成的日志分录,通过在QlikView中开发相应的垂直表,即可得到需要引入到NAV2016的分录。

 

接下来继续介绍这些分录如何引用到NAV2016中。

分类: Uncategorized 标签:

记一次NAV项目升级之数据迁移(3)

2017年9月6日 没有评论

 

在以上环境运行完成后,接下来进行主数据迁移,执行顺序如下:

1. 在NAV2016中发布WebServices

2. 将WebServices转换成WebAPI

3. 在NAV4.0中,启动Dataport

 

启动Dataport, 需要引入文本文件,文本文件内容如下:

23
27
36
37
42
79
80
82
84
85
88
92
93
94
95
97
98
204
222
225
230
232
233
234
242
244
245
250
251
252
255
257
270
277
279
289
308
309
310
311
312
313
314
315
323
324
325
330
333
334
348
349
352
354
363
402
5050
5053
5054
5079
5083
5122
5218
5404
5525
5600
5603
5604
5605
5606
5607
5608
5609
5611
5612
5619
5620
5622
5623
5633
5634
5644
5645
5647
5714
5717
5718
5719
5723
5748
5769
5800
5813
5911
6216
6502
6505
6635
7023
7111
7112
7113
7116
7118
7132
7152
7300
7301
7303
7304
7309
7327
7328
7354
8000
99000765
99000875
7002
18

接下来执行Dataport, 经过一段时间的运行,以上主表的数据将直接从NAV4.0直接升级到NAV2016中。

分类: Uncategorized 标签: