0035015: Organization's natural tree error in cost adjustment line's structure

Test Plan 1
As F&B International Group Admin
  - Go to Product window
    Create new Product for "*" organization. Define Price for "Bebidas Alegres"= 10 and "Tarifa de ventas"= 20
  - Go to Purchase Order window
    Register Purchase Order for "España region norte" organization, "Bebidas alegres" business partner and date = 13-01-2017.
    Add line for previous product and price=10. Process it
  - Go to Goods Receipt window
    Register Goods Receipt for "España region norte" organization, "Bebidas alegres" business partner and date = 13-01-2017.
    Run "create lines from" process, select previous order and process it
  - Go to Process Request window
    Run Costing Background process and verify that transaction has been properly calculated
  - Go to Goods Shipment
    Register Goods Shipment for "España region norte" organization, "Alimentos y Supermercados" business partner and date = 19-01-2017.
    Add line for previous product. Process shipment
  - Go to Process Request window
    Run Costing Background process and verify that transaction has been properly calculated

  - Go to Purchase Order window
    Register Purchase Order for "España region sur" organization, "Bebidas alegres" business partner and date = 05-01-2017.
    Add line for previous product with price = 12. Process it
  - Go to Goods Receipt window
    Register Goods Receipt for "España region sur" organization, "Bebidas alegres" business partner and date = 05-01-2017.
    Run "create lines from" process, select previous order and process it
  - Go to Process Request window
    Run Costing Background process and verify that transaction has been properly calculated
  - Go to Costin Rule window
    Select "España" record and run "Fix Backdated Transactions"
    In the popup set process date = 01-01-2017 clic on OK and no error is raice now

Test Plan 2
As F&B International Group Admin

  - Go to Product window
    Create new Product for "España" organization. Define Price for "Bebidas Alegres"= 5 and "Tarifa de ventas"= 7
  - Go to Purchase Order window
    Register Purchase Order for "España norte" organization and "Bebidas alegres" business partner.
    Add line for previous product and qty=10. Process it
  - Go to Goods Receipt window
    Register Goods Receipt for "España norte" organization and "Bebidas alegres" business partner.
    Run "create lines from" process, select previous order and process it
  - Go to Process Request window
    Run Costing Background process and verify that cost for this transaction is calculated to 50
  - Go to Goods Shipment
    Register Goods Shipment for "España norte" organization and "Alimentos y Supermercados" business partner.
    Add line for previous product and qty=2. Process shipment
  - Go to Process Request window
    Run Costing Background process and verify that cost is calculated to 10
  - Go to Purchase Invoice window
    Register Purchase Invoice for "España norte" organization and "Bebidas alegres" business partner.
    Run "create lines from" process, select previous receipt.
    Edit invoice line to set price=7 and complete
  - Run "Process Price Difference Adjustment" process for "España norte" organization, today's date and previous product
  - Go to Cost Adjustment window
    Verify that record has been created for "F&B España, S.A" organization
    Verify in Lines tab that record has been created for "F&B España - Región Norte" organizatio

Test Case 1 - Backdated Transaction Adjustment (different organizations)

1. Create new product for * organization. Define price of 20 to Tarifa de Ventas and price of 10 to Tarifa Bebidas Alegres
2. Create purchase order for "España region norte", "Bebidas Alegres", date=13-01-2017. Add line for previous product with price=10 and process
3. Create Goods Receipt for "España region norte", "Bebidas Alegres", date=13-01-2017. Run "create lines from" and select previous order. Process
4. Run "Costing Background Process" and verify that transacion has been properly calculated
5. Create Goods Shipment for "España region norte", "Bebidas Alegres", date=19-01-2017. Add line for same product and process.
6. Run "Costing Background Process" and verify that transacion has been properly calculated
7. Create purchase order for "España region sur", "Bebidas Alegres", date=05-01-2017. Add line for previous product with price=12 and process
8. Create Goods Receipt for "España region sur", "Bebidas Alegres", date=05-01-2017. Run "create lines from" and select previous order. Process
9. Run "Costing Background Process" and verify that transacion has been properly calculated
10. Access "Costing Rule" window, select "España" record and run "Fix Backdated Transactions" process setting date 01-01-2017.
11. Go to Cost Adjustement window and verify that a new record has been created with below information:

Header
Organization = F&B España (legal with accounting).
Source Process = Backdated Transaction

Lines
Organization = Field Organization is not shown anymore.
Line Nº 10 = Source = Yes, Inventory Transaction ) Vendor receipt dated on 05-01-2017 (at a price of 20.00). Adjustement Amount = 0.00 . Unit Cost = Yes, Is Backdated Tr = Yes.

Line Nº 20 Source = No, Inventory Transaction ) Customer Shipment dated on 19-01-2017. Adjustement Amount = 13.34 (33.34-20). Unit Cost = Yes, Is Backdated Tr = No.
Needs Posting = Yes.

Post the adjustment line.

Verify below posting is shown for F&B España Euro GL:
13.34 (999000) Coste de Productos Vendidos DEBIT
13.34 (350000) Productos Terminados CREDIT
same as corresponding one for F&B International Group.

Go To Accounting tab and verify that F&B España - Region Norte is the Organization shown as customer shipment being adjusted belongs to Region Norte Org.

Test Case 2 - Manual Cost Adjustment.
Go to product window and select the product just created.
Go to Transactions tab and select the one related to F&B España - Region Sur, that is second receipt dated on 05-01-2017. Verify that the cost of that transaction is currently 200.00

Click on Manual Cost Adjustement. Enter a Total Cost Amount = 300 with an accounting date = 05-01-2017.

Press Done.

Go to Cost Adjustment window and verify that a new one has been created for F&B España, source "Manual Cost Correction".
Line 10 for an adjust amount = 100.00 (vendor receipt Of F&B España Region Sur).
Line 20 for an adjust amount= 13.32 (Customer shipment of F&B España Region Norte)
Post it.

Go to accounting tab and filter by F&B España Euro General Ledger.
Verify that there are two lines related to Region Sur org for an amount = 100.00
and two more lines related to Region Norte org for an amount = 13.32

Test Case 3 - Process Price Difference Adjustment process (One organization)

As F&B International Group Admin

- Go to Product window
- Create new Product for "España" organization. Define Price for "Bebidas Alegres"= 5 and "Tarifa de ventas"= 7
- Go to Purchase Order window
- Register Purchase Order for "España norte" organization and "Bebidas alegres" business partner.
- Add line for previous product and qty=10. Process it
- Go to Goods Receipt window and register Goods Receipt for "España norte" organization and "Bebidas alegres" business partner.
- Run "create lines from" process, select previous order and process it
- Go to Process Request window
- Run Costing Background process and verify that cost for this transaction is calculated to 50.00
- Go to Goods Shipment and register Goods Shipment for "España norte" organization and "Alimentos y Supermercados" business partner.
- Add line for previous product and qty=2. Process shipment
- Go to Process Request window
- Run Costing Background process and verify that cost is calculated to 10
- Go to Purchase Invoice window and register Purchase Invoice for "España norte" organization and "Bebidas alegres" business partner.
- Run "create lines from" process, select previous receipt.
- Edit invoice line to set price=7 and complete
- Run "Process Price Difference Adjustment" process for "España norte" organization, today's date and previous product
- Go to Cost Adjustment window

- Verify that a cost adjustment has been created for "F&B España, S.A" organization (Header).
- Verify in Lines tab that two records have been created with below information:
* Source one V+ for an adjutsment amount = 20.00 (70-50)
* No Source one C- for an adjustment amount = 4.00 (14-10)
Organization field can not be shown.

Make sure that the product created has the ledger account "Invoice Price Difference" setup for the corresponding General Ledgers in the "Accounting" tab.

- Post cost adjustment lines.
- Verify cost adjustment transaction is post to both F&B España Euro and F&B International Group US general ledger configurations.
- Go to Accounting tab and verify that the Organization shown is "F&B España - Region Norte".

Test Case 4 - Price Correction Background process (one organizations).

As F&B International Group Admin

- Go to Process Request window and create a new record with below setup:
Client = F&B International Group
Organization = *
Timing = Run inmediatly
Process = Price Correction Background.
- Go to Product window
- Create new Product for "*" organization. Define Price for "Bebidas Alegres"= 5 and "Tarifa de ventas"= 7
- Go to Purchase Order window
- Register Purchase Order for "España norte" organization and "Bebidas alegres" business partner, dated on 13-01-2017
- Add line for previous product and qty=10. Process it
- Go to Goods Receipt window and register Goods Receipt for "España norte" organization and "Bebidas alegres" business partner, dated on 13-01-2017
- Run "create lines from" process, select previous order and process it
- Go to Process Request window
- Run Costing Background process and verify that cost for this transaction is calculated to 50.00

- Go to Goods Shipment and register Goods Shipment for "España norte" organization and "Alimentos y Supermercados" business partner, dated on 19-01-2017.
- Add line for previous product and qty=2. Process shipment
- Go to Process Request window
- Run Costing Background process and verify that cost is calculated to 10

- Go to Purchase Invoice window and register Purchase Invoice for "España norte" organization and "Bebidas alegres" business partner, dated on 19-01-2017.

- Run "create lines from" process, select previous receipt.
- Edit invoice line to set price=7 and complete

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

- Go to Cost Adjustment window
- Verify that cost adjustment has been created for "F&B España, S.A" organization
- Verify in Lines tab that two records have been created:
* Source one V+ for an adjutsment amount = 20.00 (70-50)
* No Source one C- for an adjustment amount = 4.00 (14-10)
- Post cost adjustment.
- Verify cost adjustment transaction is post to both F&B España Euro and F&B International Group US general ledger configurations.

Go to Accounting tab and verify that only F&B España Region Norte org is shown.

Test Case 5 - Price Correction Background process (diffferent organizations).

Use same product as the one used in test case 4.

Go to Purchase Order window
- Register Purchase Order for "España Sur" organization and "Bebidas alegres" business partner, dated on 05-01-2017
- Add line for previous product and qty=10. Process it
- Go to Goods Receipt window and register Goods Receipt for "España sur" organization and "Bebidas alegres" business partner, dated on 05-01-2017
- Run "create lines from" process, select previous order and process it
- Go to Process Request window
- Run Costing Background process and verify that cost for this transaction is calculated to 50.00

- Go to Purchase Invoice window and create a new one for F&B España Region Sur dated on 05-01-2017, select previous receipt.
- Edit the line and change the price to 8. Complete and Post the invoice.
- Go to Process Request window and run price correction process.

Go to Cost Adjustment window and verify there are two new adjustments, both of them created for F&B España.
First one is a backdated adjustment related to Goods Receipt dated on 05-01-2017 for Region Sur, as source adjustment, no posting required, amount adj = 0.00; and Customer Shipment for Region Norte dated on 19-01-2017, posting required.

Post it.

Go to Accounting tab and verify that only Region Norte is shown in there.

Go to the second adjustment that is a price difference correction adjustment.
Verify it has two lines:
line 10 - vendor receipt dated on 05-01-2017 (Region Sur) for an amount = 30. Posting required.
Line 20 - customer shipment dated on 19-01-2017 - (Region Norte ) for an amount = 3.00 Posting required.
Post it.

Go to Accounting tab and filter by F&B España Euro GL.
Verify that Region Norte org is shown for the adjustment of 3.00 (Customer Shipment), and Region Sur is shown for the adjustment of 30.00 (Vendor Receipt)