没有合适的资源?快使用搜索试试~ 我知道了~
ax2012_导入客户交易记录的方法.docx
需积分: 5 0 下载量 117 浏览量
2021-03-15
20:50:12
上传
评论
收藏 268KB DOCX 举报
温馨提示
试读
9页
ax2012_导入客户交易记录的方法.docx
资源详情
资源评论
资源推荐
Dynamics AX 2012 Customer transactions/balances
Import using Excel Add-in
Dynamics AX 2012 Excel Add-in – Customer transactions/balances Import
Purpose:The purpose of this document is to illustrate how to use
Microsoft Dynamics AX 2012 Excel Add-in for import of customer
open transactions.
Challenge: Data model changes in Microsoft Dynamics related to
high normalization and introduction of surrogate keys made some
imports more complex. In fact the data model forming General
Journal was not dramatically changed and import principle remains
the same – populate the journal and then post the journal. However
some information which is usually automatically generated in
Microsoft Dynamics AX 2012 Rich Client by means of number
sequences such as voucher number will have to be provided.
Additionally with introduction of segmented control to specify multi-
type account on General Journal line it became more challenging to
work with customer and vendor transactions using Excel.
Solution: Microsoft Dynamics AX 2012 ships with General Journal
AIF Web Service (LedgerGeneralJournalService) which can be used
in integration scenarios. Also General Journal AIF Web Service can
be used in Excel for import of customer open transactions. In order
to import customer open transactions using Excel the mentioned AIF
Web Service will be used. Some additional work will be done after
initial import to align customer account.
Assumption: The assumption is that appropriate reference data
such as customers, etc. was created in advance.
Data Model:
Table Name Table Description
LedgerJournalTable The LedgerJournalTable table contains
all the defaulting and state
information pertaining to a single
journal. The transaction details of a
journal are managed in the
adingkui
- 粉丝: 0
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0