Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #28115 All Revisions ] Back to Issue ]
Summary 0028115: [Costing] Add "Is Cost Permanent" transactions as input transactions in Costing tab, Inventory Transactions field
Revision 2014-11-13 10:59 by psanjuan
Steps To Reproduce In QA Testing client create a new product named "Costing GM1 no incremental". Select a purchase price list. Enter a unit/list price of 11.00

Go to purchase order window and create a new one dated on 29/10/2014. Enter 820 units. Book the order.

Go to goods receipt window and create a new one dated on 3/11/2014. Select the order and receipt 820 units. Complete the receipt

Go to process request window and launch costing background process.

Go back to goods receipt window and post it. Realize that value posted is 9020 ( 820 units * 11.00 €/unit)

Go to Goods Movement Window and create a new one dated on 13/11/2014

Move 400 units from Spain Warehouse to another warehouse named Spain West Warehouse, for instance. Complete the movement.

Go to process request window and launch costing background process.

Go to goods movement and post it. Realize that the value posted is 4400 ( 400 units + 11 €/unit)

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and press the button "Manual Cost Adjustment".

In total cost field enter a total cost amount = 4000. Enter 18/11/2014 as accounting date and do not select the flag "Incremental". Press Done/OK.

Go to Cost Adjustment window and realize that a manual cost adjustment has been created, adjust amount = -400 (4400-4000).

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and realize that it is marked as "Is Cost Permanent = Yes". Transaction original cost = 4400, Total Cost and Unit Cost = 4000

Go to costing tab and realize that there are 3 lines:

Line 1 - Cost 11 related to Vendor receipt (V+) dated on 3/11/2014 - total mov qty 820. Spain Warehouse.

Line 2 - Cost 10 (4000/400 units) related to Goods Movement To (M+) dated on 13/11/2014 - total mov qty 400 . Spain West Warehouse

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse.

Line 3 is not correct. It should be:

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] related to Goods Movement From (M-) dated on 13/11/2014 - total mov qty 420. Spain Warehouse.

After this a purchase invoice needs to be created dated on 8/11/2014. Create it by using Create Lines From, select the receipt. Realize that 820 units are shown. Change the price from 11.00 to 15.00. Complete and post the invoice. Realize that total value posted is 12300 (820 units * 15.00 €/unit).

Go to process request window and run price correction background process.

Go to cost adjustment window and realize that a price correction adjustment has been created related to vendor receipt dated on 3/11/2014 Adj Amount 3280 ( 12300-9020).

Go to product window, search the product and navigate to costing tab. Realize that there are 4 lines:

Line 1 - Cost 15 related to Vendor receipt (V+) dated on 3/11/2014 - total mov qty 820. Spain Warehouse.

Line 2 - Cost 10 (4000/400 units) related to Goods Movement To (M+) dated on 13/11/2014 - total mov qty 400 . Spain West Warehouse

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse.

Line 4 - Cost 19.76 [(420 units * 11.00) + 400 + 3280 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse.

This is not correct, correct lines should be:

Line 1 - Cost 15 related to Vendor receipt (V+) dated on 3/11/2014 - total mov qty 820. Spain Warehouse.

Line 2 - Cost 10 (4000/400 units) related to Goods Movement To (M+) dated on 13/11/2014 - total mov qty 400 . Spain West Warehouse

Line 3 - Cost 19.76 related to Goods Movement From (M-) dated on 13/11/2014 - total mov qty 420. Spain Warehouse.
Revision 2014-11-07 12:24 by psanjuan
Steps To Reproduce In QA Testing client create a new product named "Costing GM1 no incremental". Select a purchase price list. Enter a unit/list price of 11.00

Go to purchase order window and create a new one dated on 29/10/2014. Enter 820 units. Book the order.

Go to goods receipt window and create a new one dated on 3/11/2014. Select the order and receipt 820 units. Complete the receipt

Go to process request window and launch costing background process.

Go back to goods receipt window and post it. Realize that value posted is 9020 ( 820 units * 11.00 €/unit)

Go to Goods Movement Window and create a new one dated on 13/11/2014

Move 400 units from Spain Warehouse to another warehouse named Spain West Warehouse, for instance. Complete the movement.

Go to process request window and launch costing background process.

Go to goods movement and post it. Realize that the value posted is 4400 ( 400 units + 11 €/unit)

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and press the button "Manual Cost Adjustment".

In total cost field enter a total cost amount = 4000. Enter 18/11/2014 as accounting date and do not select the flag "Incremental". Press Done/OK.

Go to Cost Adjustment window and realize that a manual cost adjustment has been created, adjust amount = -400 (4400-4000).

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and realize that it is marked as "Is Cost Permanent = Yes". Transaction original cost = 4400, Total Cost and Unit Cost = 4000

Go to costing tab and realize that there are 3 lines:

Line 1 - Cost 11 related to Vendor receipt (V+) dated on 3/11/2014 - total mov qty 820. Spain Warehouse.

Line 2 - Cost 10 (4000/400 units) related to Goods Movement To (M+) dated on 13/11/2014 - total mov qty 400 . Spain West Warehouse

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse.

Line 3 is not correct. It should be:

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] related to Goods Movement From (M-) dated on 13/11/2014 - total mov qty 420. Spain Warehouse.

After this a purchase invoice needs to be created dated on 8/11/2014. Create it by using Create Lines From, select the receipt. Realize that 820 units are shown. Change the price from 11.00 to 15.00. Complete and post the invoice. Realize that total value posted is 12300 (820 units * 15.00 €/unit).

Go to process request window and run price correction background process.

Go to cost adjustment window and realize that a price correction adjustment has been created related to vendor receipt dated on 3/11/2014 Adj Amount 3280 ( 12300-9020).

Go to product window, search the product and navigate to costing tab. Realize that there are 4 lines:

Line 1 - Cost 15 related to Vendor receipt (V+) dated on 3/11/2014 - total mov qty 820. Spain Warehouse.

Line 2 - Cost 10 (4000/400 units) related to Goods Movement To (M+) dated on 13/11/2014 - total mov qty 400 . Spain West Warehouse

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse.

Line 4 - Cost 19.76 [(420 units * 11.00) + 400 + 3280 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse.

This is not correct, correct lines should be:

Line 1 - Cost 15 related to Vendor receipt (V+) dated on 3/11/2014 - total mov qty 820. Spain Warehouse.

Line 2 - Cost 10 (4000/400 units) related to Goods Movement To (M+) dated on 13/11/2014 - total mov qty 400 . Spain West Warehouse

Line 3 - Cost 15 related to Goods Movement From (M-) dated on 13/11/2014 - total mov qty 420. Spain Warehouse.
Revision 2014-11-07 12:22 by psanjuan
Steps To Reproduce In QA Testing client create a new product named "Costing GM1 no incremental". Select a purchase price list. Enter a unit/list price of 11.00

Go to purchase order window and create a new one dated on 29/10/2014. Enter 820 units. Book the order.

Go to goods receipt window and create a new one dated on 3/11/2014. Select the order and receipt 820 units. Complete the receipt

Go to process request window and launch costing background process.

Go back to goods receipt window and post it. Realize that value posted is 9020 ( 820 units * 11.00 €/unit)

Go to Goods Movement Window and create a new one dated on 13/11/2014

Move 400 units from Spain Warehouse to another warehouse named Spain West Warehouse, for instance. Complete the movement.

Go to process request window and launch costing background process.

Go to goods movement and post it. Realize that the value posted is 4400 ( 400 units + 11 €/unit)

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and press the button "Manual Cost Adjustment".

In total cost field enter a total cost amount = 4000. Enter 18/11/2014 as accounting date and do not select the flag "Incremental". Press Done/OK.

Go to Cost Adjustment window and realize that a manual cost adjustment has been created, adjust amount = -400 (4400-4000).

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and realize that it is marked as "Is Cost Permanent = Yes". Transaction original cost = 4400, Total Cost and Unit Cost = 4000

Go to costing tab and realize that there are 3 lines:

Line 1 - Cost 11 related to Vendor receipt (V+) dated on 3/11/2014 - total mov qty 820. Spain Warehouse.

Line 2 - Cost 10 (4000/400 units) related to Goods Movement To (M+) dated on 13/11/2014 - total mov qty 400 . Spain West Warehouse

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse.

Line 3 is not correct. It should be:

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] related to Goods Movement From (M-) dated on 13/11/2014 - total mov qty 420. Spain Warehouse.

After this a purchase invoice needs to be created dated on 8/11/2014. Create it by using Create Lines From, select the receipt. Realize that 820 units are shown. Change the price from 11.00 to 15.00. Complete and post the invoice. Realize that total value posted is 12300 (820 units * 15.00 €/unit).

Go to process request window and run price correction background process.

Go to cost adjustment window and realize that a price correction adjustment has been created related to vendor receipt dated on 3/11/2014 Adj Amount 3280 ( 12300-9020).

Go to product window, search the product and navigate to costing tab. Realize that there are 4 lines:

Line 1 - Cost 15 related to Vendor receipt (V+) dated on 3/11/2014 - total mov qty 820. Spain Warehouse.

Line 2 - Cost 10 (4000/400 units) related to Goods Movement To (M+) dated on 13/11/2014 - total mov qty 400 . Spain West Warehouse

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse.

Line 4 - Cost 19.76 [(420 units * 11.00) + 400 + 3280 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse.

This is not correct, correct lines should be:


Revision 2014-11-07 12:09 by psanjuan
Steps To Reproduce In QA Testing client create a new product named "Costing GM1 no incremental". Select a purchase price list. Enter a unit/list price of 11.00

Go to purchase order window and create a new one dated on 29/10/2014. Enter 820 units. Book the order.

Go to goods receipt window and create a new one dated on 3/11/2014. Select the order and receipt 820 units. Complete the receipt

Go to process request window and launch costing background process.

Go back to goods receipt window and post it. Realize that value posted is 9020 ( 820 units * 11.00 €/unit)

Go to Goods Movement Window and create a new one dated on 13/11/2014

Move 400 units from Spain Warehouse to another warehouse named Spain West Warehouse, for instance. Complete the movement.

Go to process request window and launch costing background process.

Go to goods movement and post it. Realize that the value posted is 4400 ( 400 units + 11 €/unit)

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and press the button "Manual Cost Adjustment".

In total cost field enter a total cost amount = 4000. Enter 18/11/2014 as accounting date and do not select the flag "Incremental". Press Done/OK.

Go to Cost Adjustment window and realize that a manual cost adjustment has been created, adjust amount = -400 (4400-4000).

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and realize that it is marked as "Is Cost Permanent = Yes". Transaction original cost = 4400, Total Cost and Unit Cost = 4000

Go to costing tab and realize that there are 3 lines:

Line 1 - Cost 15 related to Vendor receipt (V+) dated on 3/11/2014 - total mov qty 820. Spain Warehouse.

Line 2 - Cost 10 (4000/400 units) related to Goods Movement To (M+) dated on 13/11/2014 - total mov qty 400 . Spain West Warehouse

Line 3 - Cost 11.95 [(420 units * 11.00) + 400 / 420 units] do not related to any inventory transaction - total mov qty 420. Spain Warehouse..


Revision 2014-11-07 12:00 by psanjuan
Steps To Reproduce In QA Testing client create a new product named "Costing GM1 no incremental". Select a purchase price list. Enter a unit/list price of 11.00

Go to purchase order window and create a new one dated on 29/10/2014. Enter 820 units. Book the order.

Go to goods receipt window and create a new one dated on 3/11/2014. Select the order and receipt 820 units. Complete the receipt

Go to process request window and launch costing background process.

Go back to goods receipt window and post it. Realize that value posted is 9020 ( 820 units * 11.00 €/unit)

Go to Goods Movement Window and create a new one dated on 13/11/2014

Move 400 units from Spain Warehouse to another warehouse named Spain West Warehouse, for instance. Complete the movement.

Go to process request window and launch costing background process.

Go to goods movement and post it. Realize that the value posted is 4400 ( 400 units + 11 €/unit)

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and press the button "Manual Cost Adjustment".

In total cost field enter a total cost amount = 4000. Enter 18/11/2014 as accounting date and do not select the flag "Incremental". Press Done/OK.

Go to Cost Adjustment window and realize that a manual cost adjustment has been created, adjust amount = -400 (4400-4000).

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and realize that it is marked as "Is Cost Permanent = Yes". Transaction original cost = 4400, Total Cost and Unit Cost = 4000

Go to costing tab and realize that
Revision 2014-11-06 18:11 by psanjuan
Steps To Reproduce to be defined


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker