Physical Inventory Adjustment - Physical Inv Adjust

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

Personally, I would like more a help on the inventory adjustment transaction ...
see the situation below:

Select all

Item: 5586104.00 
Perído Ajuste: SET/12 
 
Transação   	  Quantidade 
----------------- ------------ 
Misc Receipt       500 
Misc Issue        -500 
Physical adj inv   500

1) The Cost of this item in AGO / 12 was R $ 280.50
2) After running the PAC in the period of Sep / 12, the cost of the item rose to R $ 72,377.32
after this, Excluded Misc Receipt and Misc Issue transactions and rode the PAC again to SET / 12

Select all

Item: 5586104.00 
Perído Ajuste: SET/12 
 
Transação   	  Quantidade 
----------------- ------------ 
Physical adj inv   500
The cost in the period of Sep / 12 returned to R $ 280.50.
The initial balance for the period of Set / 12 was quantity = 2 at a unit cost of R $ 280.50.
Question: How do Miscellanious Receipt and Issue transactions affect the calculation of the average cost ??

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

Any transaction carried out in the period is a basis for calculating the average cost.
You have to see what cost (values) were performed these misc ... after all ... misc is not a good to do ever!

Anyway ... gives a deeper check in these diverse transactions.
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

Because it is expensive ... the misc was made but not valued manually ... theoretically should take the average cost, right ??

But what I do not understand is because Misc Receipt / Issue in the same amount are affecting the cost of item so abruptly!
Guys, if someone has a clue ... !!
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

Are you sure Misc Transactions have no value? These transactions must have NULL value in transaction_cost to not affect the average cost.
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

The transaction_cost is with zero value .... this explains the absurd value calculated by the pac ??

The cost was R $ 280.50 and went to R $ 72,377.32!
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

I do not know if it explains the absurd value, but the zero value surely influences the calculations of the PAC.
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

Check that the balance in the tabel CST_PAC_ITEM_COSTS (TOTAL_QUANTITY_LAYER) and CST_PAC_QAUNTITY_LAYERS (QUANTITY_LAYER) are correct. As transaction exclusion (???) This balance may be incorrect and cause error in calculating the average cost.
archive
Rank: OraSauro
Rank: OraSauro
Posts: 595
Joined: Fri, 02 Dec 2016 7:31 am

In fact, only inhibits Misc Receipt / Issue transactions in the same amount, that is, at the end gives 0x 0.
understood ??
The client here thought that Misc Receipt had been valued on the transaction screen !!
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 5 guests