零碎的问题记录--持续更新中......
来源:互联网 发布:铃声剪辑器 mac 编辑:程序博客网 时间:2024/04/27 19:03
1.Transaction historical summary
On the date 31-DEC-2008, quantity was 0.00341. Since the report is showing upto 2 digits after the decimal, it is showing as 0.00
If the customer want to show till 5 digits after decimal, they have to change the
profile 'INV: Dynamic Precision Option for Quantity on Reports'. Set the
profile value to '-99,990.00000'.
For more information, run the following query
SELECT MEANING "Profile Format", lookup_code "Precision"
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'INV_SRS_PRECISION'
AND ENABLED_FLAG = 'Y'
ORDER BY LOOKUP_CODE;
2.form开发准备...
把TEMPLATE.fmb,APPSTAND.fmb,文件夹resource放在统一文件夹下,比如放在C:/Oracle1/ora90/FORMS60下,然后进入注册表,修改FORMS60_PATH的值为C:/Oracle1/ora90/FORMS60;C:/Oracle1/ora90/FORMS60/resource;C:/Oracle1/ora90/TOOLS/OPEN60/PLSQLLIB
此时就可以顺利使用form builder
3.Transaction historical summary
--from Oracle
The development updated with the following:
We have analyzed the data provided for the item 'POATSFBR-775BHCZ'. Basically this issue is because of backdated
transactions.
Backdated transactions[Created for April period(transaction_date) in May(creation_date)] 47121626, 47132585, 47132558,
47132541, 47139981, 47147475 were costed after the standard cost update
transaction 47125140(May Period) was costed.
Standard cost update increased the inventory valuation. Since the backdated transactions costed after this
transaction they hit the inventory valuation with new cost. Since customer is
running till 30th April, this standard cost update transaction(transaction_date
in may) value is not coming in the report showing value in negative.
Clearly this is not a bug. Customer can run the report on 6th May, 2009 to check
quantity and value matching.
We suggest the customer to explore cost cut of date feature and not to create backdated transactions in the future to avoid
these type of problems.
--from me
Here is a good news. I run the report on 6th May, 2009 for the item 'POATSFBR-775BHCZ',and get the result
that is normal. Please refer to attachment "Transaction historical
summary_280809.txt".
For this issue, I have some questions as follows:
1.When I run the report on 30th Apr 2009,the report will get the unit cost on 30th Apr 2009,right?
2.After standard cost update, if I create transaction currently, it's normal.Ifcreating transaction date before standard cost update date, we will getvariance when we run the report(Rollback date before standard cost update date).
Is my understanding correct?
--from Oracle
Customers understanding is correct. Please insist the customer not to do any backdated transactions in the future.
Also suggest the customer to explore cost cut of date feature.
- 零碎的问题记录--持续更新中......
- 【开发问题记录,持续更新..】
- 问题记录(持续更新)
- 问题记录(持续更新)
- 问题记录(持续更新)
- Allegro软件报错问题记录(持续更新中)
- 记录(持续更新中)
- 记录oracle11g使用过程中遇到的一些问题,会持续更新。
- 关于FLEX的一些文章记录(持续更新中)
- 使用phpstom的点点滴滴记录,持续更新中...
- 记录开发中遇到的坑或者Bug<持续更新...>
- linux问题零碎记录
- 零碎问题记录
- ReactJS前端项目 问题与解决记录(刚接触前端,根据项目中遇到的坑持续更新)
- 常用Linux命令记录( 持续更新中。。。)
- 常用通讯术语记录(持续更新中)
- git使用记录(持续更新中)
- Linux命令记录(持续更新中)
- flex的分层数据AdvancedDataGrid
- 基金选择指标
- 一个简单的Squid服务器
- 标准C++的类型转换符
- 类型转换--c语言
- 零碎的问题记录--持续更新中......
- C++中的虚函数表
- 正则应用之——日期正则表达式
- C++界面库 - Xtreme Toolkit Pro
- Redhat 5.3 Cluster测试二三事
- SWT中的(文件目录对话框)和(文件对话框)
- volatile的用法
- 覆铜经验之我谈
- querystring用法