MTL_MATERIAL_TRANSACTIONS

INV, BoM, WIP, Cost, etc
Post Reply
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

I am performing a test, which I am changing the value of a transaction in MTL_Material_TransActions.
I have a transaction whose fields are:

Select all

ACTUAL_COST = 11 
TRANSACTION_COST = 11 
PRIOR_COST = 0 
NEW_COST = NULL
So, I change these fields to:

Select all

ACTUAL_COST = 15 
TRANSACTION_COST = 15 
PRIOR_COST = 0 
NEW_COST = NULL
After this change, I change the COSTED_FLAG field for 'N', and I expect the cost manager to reprocess the transaction. And for my frustration, after this execution, the transaction does not have its changed cost, that is, the current_cost field of 15 turn to 11, and the Transaction_Cost continues as 15.

Querying the transaction In materials transactions, the cost continues with the old value.

Someone would know inform me, from where he seeks the old cost in the actual field_cost, since this transaction is a diverse transaction?

If someone has some help, I thank you very much!
Hugs,
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

Did you delete the records that have Transaction_ID from the MTL_Transaction_AcCounts table so that the Cost Management does not reconstitute the cost of the transaction?
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

This change is via screen or straight update at the base, have you already verified if there is any trigger in this table?

Hugs
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

Are you using the pac for costing? If so, it will be easier to use the PAC transaction valuation feature.
This functionality allows the cost change of various transactions made, however, I do not know if there is API for this.
In the attached manual there are more details of this functionality in the topic valuation of transactions.
CLL_F032_PAC_UG_PTB.pdf
(618.74 KiB) Downloaded 543 times
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

Did you delete the records that have Transaction_ID from the MTL_Transaction_AcCounts table so that the Cost Management does not reconstitute the cost of the transaction?
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

I'vê been through a short time, you need to change the cost in the MTL_CST_TXN_COST_DETAILS table as well, another thing, you should make all changes before the cost, that is, as soon as the insert occurs in the table, otherwise after the COST Manager, can not change more.
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

I change the value in this table, with the stopped cost manager. And yet, the transaction returns with the old cost.
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

Let me ask you 2 things:

1- You are doing this on a test basis, right?
2- Why are not you using the cost upgrade only, rather than update? (Inv -> Costs -> Average Cost Update)
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

If you are using the PAC goes on Brazilian locations and the value of the transactions and changes there.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest