Fragmented problem record-continuous update ...

Source: Internet
Author: User

1.Transaction Historical Summary

On the date 31-dec-2008, quantity was 0.00341. Since the 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 Development Preparation ...

Put the TEMPLATE.FMB,APPSTAND.FMB, folder resource under the Unified folder, such as under C:/ORACLE1/ORA90/FORMS60, and then enter the registry, modify the Forms60_path value of c:/ ORACLE1/ORA90/FORMS60; C:/oracle1/ora90/forms60/resource; C:/oracle1/ora90/tools/open60/plsqllib

The form builder can be used smoothly at this time

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) is costed.

Standard cost update increased the inventory valuation. Since the backdated transactions costed after this
Transaction they hit the inventory valuation with a new cost. Since Customer is
Running till 30th April, this standard the cost update transaction (transaction_date
In May) "value is not" coming in the "the" showing value in negative.

Clearly this isn't a bug. Customer can run the "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 into the future to Avoi D
These type of problems.

--from Me

This is a good news. I run the "on" the "6th May", 2009 for the item ' Poatsfbr-775bhcz ', and get the result
This 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 "the" on 30th Apr 2009,the the "the" the "unit" cost on 30th Apr 2009,right.
2.After Standard Cost Update, if I create transaction currently, it's normal. If Creating transaction date before Standard Cost update date, we'll get variance when we run the [Rollback date B Efore Standard Cost update date).
Is my understanding correct?

--from Oracle

Customers understanding is correct. Please insist the customer does not have backdated transactions in the future.
Also suggest the customer to explore cost cut of date feature.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.