开发工具:
文件大小: 148kb
下载次数: 0
上传时间: 2019-07-27
详细说明:NULL
博文链接:https://mlh.iteye.com/blog/685813Activity 2: Creating a Columnar Section
Steps to complete
1. Expand the Psio2 ERW Training project and focus on the Objects node
2. Click add
3. Choose Batch Application and click OK
4. Enter the following information
Field
Value
Object Name
R55xXXX
Description
G/L Transaction detail
Product Code
55
Product System Code
55
Object Use
161
Do not choose the Table Conversion option. This option is for converting data
5. On the Design Tools tab, launch the report design tool by clicking the Start Report Design Aid
button
Introducing the report director
The report Design Director guides you through the steps for creating a basic report template
Only one detail section can be created initially, more detail sections can be added once the basic
report template is created
From the first form of the Director, you can choose other supporting sections such as
Report header
Page header
· Page footer
° Report Footer
6. From the report director. choose
Page Header
Columnar
7. Click Next to accept your choices
8. Click the following option
Automatically add the default informational fields shown below to my page header section
Prepared by: Ang Hooi Ling
Date:03 Feb 2010
This option automatically populates the page header with the fields represented in the page
header graphic, such as
° Report Template Namc
Company namc
· Report Title
Date and Time
Page Number
9. Click Next
10. The Business view Selection Option form has the following two options
I'd like help in finding an Appropriate Business view- This option presents a list of
Business view Favorites. Customers have determined that these business views are used
frcqucntly, and they arc shipped with the softwarc. You can add own busincss vicw favorites
to the list
Ill find a business view myself.
1. Choose the second option as shown below:
I'll find a business view myself
This option allows a search of all of the business views in the system
12. Click Next
13. On the Object Name QBE line, enter following business view name and click Find
Description
Name
G/L Transaction Detail Report
V0911G
This business view was created over the fo91l-Account ledger table
14 Click Next
15. On the Section Layout form, choose the following fields in order
Description
Alias
Batch number
ICU
Document Type
DCT
Document( Voucher, Invoice, etc)
DOC
Journal entry Line number
JELN
Business unit
MCU
Object Account
OBJ
Subsidiary
SUB
Prepared by: Ang Hooi Ling
Date:03 Feb 2010
Amount
AA
16. Click Next
17. Data Sequencing allows the user to choose the order of the fields that are presented in the report
section
18. On Section Data Sequencing, choose the following columns in order
Description
Alias
Batch number
ICU
Document(Voucher, Invoice, etc)
DOC
Journal entry line number
JELN
19. Click Next
20. On Section Data Selection. enter the following data selection
Operator
Left operand
Comparison
Right operand
Where
Batch Number
equa
Blank
And
Object Account
Is cqual to
Blank
21. Click Next
22. Create a version name it VErooo1
23. On the Report director, click Finish
24. View Report Template, in Solution Explorer, type BV in Fast path
25. Run the report
26. Save report template
Prepared by: Ang Hooi Ling
Date:03 Feb 2010
Directed Exercise Example: R55 xxxx
Business view: Vo911G-G/L Transaction Detail Report
上L
⊥ d. bess CaTEr
的1效2
0 IT sedan wh I
厂数
上L
HaI-
2
10
0生
1
0
的1上
题日淀
的1上
的1
30
sATra
13"
的1上
的1正E
的1
bitaL
scAm
的上
的1
TEn
PeR t
s5sd前时
+4L
1粒觉
22上
11C
tHE
22正
上E
2:2改
2103
上
Sample report: Columnar
P
d by: Ang Hooi Ling
Date:03 Feb 2010
activity 3 Creating a Group section
Steps to complete
1. Expand the Psio2 ERW Training project and focus on the Objects node
2. Click add
3. Choose Batch Application and click OK
4. Enter the following information
Field
Ⅴalue
Object Name
R554lXXXX
Description
Inventory by Branch/Plant
Product Code
55
Product System Code
55
Object Usc
161
5. On the Design Tools tab, launch report Design Aid
6. From the Report Design Director, choose to create the following
Page header
grout
p
7. Choose the following option
automatically add the default informational fields shown below to my
page header section
8. Click Next to accept the auto-create feature for the Page Header
9. Create Version veroool
10. Click finish
11. Focus on the group section and choose the following from the menu:
Section
Select business view-V41021E
Prepared by: Ang Hooi Ling
Date:03 Feb 2010
12. Focus on the group section and choose the following from the menu
ection
Quick section
13. On the Section Layout form, choose the following fields in order
ription
las
Business unit
MCU
Location
LOCN
2nd Item Number
LITM
Unit of Measure -Primary
UOMI
ription
DSCI
Quantity on Hand- Primary Units
POOH
14. Data Sequencing
Business unit- MCU
2nd item Number- LITm
5. Data selectio
Operator
Left Operand
Comparison
Right Operand
here
ocation
Is not equal to
Blank
And
Quantity on Hand
Is greater than
Zer
Primary Units
16. Save and preview the report
17. Test and run the re
P
d by: Ang Ho
Date:03 Feb 2010
Directed Exercise Example: R5541xxx
Business view: vA102lE-ltem location. tem master join
D【H品cmr
-1m
ner B r"pan
.rd lier h
二rGn
eur arMs
mess t
lEasr 5- 1
|
语品币
Cur ar ms
sans据nd
rd|匚h
Hourani
二nP
Jm画
程rd
ra Fish
r经作
Wushen
:relish
〓rG直
P口p
uar JnE
Mux hsee r
rA liar h
wi -np
Jp色
warm an Man=
410
据r吧
lacud-n t b
Cuan an Hana
TusseR
r|吧N
M41
到t
a"m an ian彐
Dlir
edar
suam an ana
BunniEs r
.relier H
M15
〓rGn
山糖A
了K生
lsr
i=sn
ain据rd
.rd h
4120
Jeerta'nk Lima
二nH
m据r
二:值
lExier 1-
Ine wver
已 ua an ias
wundt
口二
|·
二r
指C
12
J酽睡A
Sample report: Group section
P
d by: Ang Hooi Ling
Date:03 Feb 2010
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台,提供交流渠道,下载内容来自于网络,除下载问题外,其它问题请自行百度。
- 本站已设置防盗链,请勿用迅雷、QQ旋风等多线程下载软件下载资源,下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载,请稍后再次尝试;或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎,请到消费记录里找到下载记录反馈给我们,经确认后退回积分.
- 如下载前有疑问,可以通过点击"提供者"的名字,查看对方的联系方式,联系对方咨询.