E1: 76B: Add Tax Lines To Order - Brazil (R76B803) Doesn't Update Item Ledger (F4111) or Weighted Average Cost (P4105) (Doc ID 2980813.1)

Last updated on MARCH 06, 2024

Applies to:

Symptoms

"Add Tax Lines To Order - Brazil" (R76B803) does not add recoverable tax lines to the Return Purchase Order (F4211) or to the Item Ledger (F4111) and does not update the Weighted Average Cost (02) record in the Item Cost Ledger (F4105) for the Item.

STEPS TO REPRODUCE:

1. In UDC 40/AV set the following values:
   1. Sales Update” (R42800) value in the 'Description 02' column = 'Y' .
   2. “Add Tax Lines To Sales Order Detail – Brazil” (R76B803) value in the 'Description 02' column = 'Y'.
   3. Both programs are able to update Weighted Average Cost.
2. In Line Type Constants (P40205):
   1. BX Line Type has Inventory Interface = “Y” and Taxable Y/N = “Y”.
   2. BR Line Type has Inventory Interface = “Y” and Taxable Y/N = “Y”.
3. In UDC 76/PU Find Purchase Use Code PFB
   1. Special Handling Code 110111 indicates IPI, ICMS, PIS and COFINS are recoverable
4. Prior to receiving a Purchase Order, Weighted Average Cost (P4105 – 02) is 53.0345 per unit for Item 761 in Branch SP-VENDA. After the purchased item is received and then returned, Weighted Average Cost should be returned to this value.
5. Prior to receiving a Purchase Order, Item Availability (P41202) shows Item 761 in Branch RS-VENDA has 57 EA On-Hand. After the purchased item is received and then returned, Quantity On-Hand should be returned to this value.
6. Create a Brazil Localization Purchase Order (P4310) for 10.00 EA of the Item 761 with a Unit Cost of 45.00 and Extended Cost of 450.00 in Branch RS-VENDA.
   1. Enter Brazil Localization Header and Detail information (P4310BR).
   2. Use a Purchase Use Code PFB (IPI, ICMS, PIS and COFINS taxes are recoverable).
7. Receive the PO (P4312):
   1. Create the Nota Fiscal.
   2. Notice ICMS Taxes were added to the Nota Fiscal.
   3. IPI Taxes were not calculated.
   4. Close Nota.
8. Check Item Ledger (P4111):
   1. Inventory Cost was increased by +450.00 for 10 items received.
   2. Inventory Cost was reduced by -115.13 after three Taxes are subtracted (ICMS, PIS and COFINS).
   3. Weighted Average Cost was reduced from 53.0345 to 50.1169.
9. It is decided the item needs to be returned. A sales order needs to be created to sell the item back to the supplier.
   1. Setup Sales Order (P4210) Version ZJDE7006.
   2. Order Type is VS.
   3. Line Type is BS same as the Purchase Order used.
10. A version of Sales / Purchase Returns - BRA (P76B805) which has the same Version Number as the Sales Order (P4210) version is required.
    1. Display Tab Option #1 (Nota Fiscals) = 1 (Purchasing Nota Fiscals).
    2. Process Tab Option #1 (Reverse Sign) = 1 (Reverse Sign).
    3. Defaults Tab Option #2 (Return Branch) = RS-VENDA.
    4. Defaults Tab Option #3 (Document Type) = VL.
    5. Defaults Tab Option #4 (Nota Fiscal Type) = BRNFI-CL.
11. From the Menu G76B4211, select Purchase Return (P4210 Version ZJDE7006) and click Add (+).
    1. From Enter Purchase Return take the Form Exit to Credit Memo.
    2. From Create Sales Ledger Details, take the Form Exit to NF Selection.
    3. On Create Sales Ledger Details > Nota Fiscal Selection, Find and Select the Nota Fiscal for the Purchase Receipt (997).
    4. The Related Purchase Order Data is pulled into Create Sales Ledger Details screen.
    5. A Sales Ledger record is created with a Sales Order Number for the return sales order. Click OK.
    6. Manually enter Order Number (672) and Order Type (VL) from the previous screen and click Find.
    7. Row Exit to Credit Order > Select Line and click the Close Button.
12. Return Order (88 VS) is created. Click OK to save.
    1. Click OK twice to accept Brazil SO Header and Detail (P4210BR).
13. Ship Confirm (P4205) the order.
    1. Order Status is advanced to 560/595.
    2. Actual Ship Date populated (10/13/2023).
14. Now Run Generate Nota Fiscal (R76558B Version XJDE0004 Generate Nota Fiscal PO Returns).
    1. Order Status Updated to 595/597.
15. Run Print Nota Fiscal (R76560B) :
    1. Order Status Updated to 597/598.
    2. Manually Update Purchase Return Order Status to 598/617.
    3. Check Note Fiscal Status (P7610B) it is already Next Status 617.
16. Setup “Add Tax Lines to Sales Order Detail – Brazil” (R76B803 Version XJDE0004) :
    1. Default Tab Option #1 (Tax Line Type) = BX
    2. Select Tab Option #2 and #3 (From and Thru Next Status = “617”
    3. Purchase Return Tab Option #1 (Line Type for Recoverable Taxes) = “BR”
17. Line Type BR Recoverable Taxes has Inventory Interface = “Y” in Line Type Constants (P40205).
18. Run “Add Tax Lines to Sales Order Detail – Brazil” (R76B803 Version XJDE0004)
    1. Enter the Sales Order Number in the Data Selection.
19. Check Sales Order Entry (P4210):
    1. One line was added for BX line type with no amount.
20. Check Item Ledger (P4111):
    1. No Tax Lines were Added.
21. Check Debug Logs:
    1. There was one INSERT INTO F4211 for the “BX” Line Type.
    2. No insert for the “BR” line type.
    3. Search on “.F4111”.
    4. There was no SQL against the Item Ledger (F4111) table.
    5. Business Function UpdateAverageCostsBrazil (B7602030) never appears in the logs

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.