PO Related NF: EBC Not Being Properly Calculated when there Is a Quantity Discrepancy

(Doc ID 2380446.1)

Last updated on APRIL 05, 2018

Applies to:

Oracle Retail Fiscal Management - Version 14.1.3.2 and later
Information in this document applies to any platform.

Symptoms

For tax codes set with matching indicator to N, such as PIS and COFINS, RFM is calculating the EBC based on the tax values (e.g. TAX_REC_VALUE)
in the FM_FISCAL_DOC_TAX_EXT and dividing by quantity actually received in order to get the corresponding tax unit value.
If the merchandise actually received is less than the NF quantity, due to damaged and/or missing quantity, the corresponding
unit tax value will be greater than it should be. Hence, the EBC will be wrong whenever it falls in that scenario.

To Reproduce:
  Receive PO NF with quantity discrepancy (damaged).

Example:
- Basis PIS = 4538.28;
- PIS tax rate = 1.65%
- PIS recoverable value = 74.88
- NF Qty = 24
- Actually received Qty = 20
If Unit PIS recoverable value based on Actually received Qty = 74.88 / 24 = 3.744.
If Unit PIS recoverable value based on NF Qty = 74.88 / 24 = 3.12.

This results in the EBC being incorrect whenever it falls in the described scenario.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms