E1: 74L: R74L3001 SAFT Validation Error when VR01 is Populated on Sales Order (Doc ID 2202533.1)

Last updated on AUGUST 29, 2017

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

R74L3001 (SAFT Extractor) is run to generate the SAFT XML file.
This file ends in validation error on the Portugal Tax Portal regarding the Invoice Number.

ERROR:
"Value 'Credit 1158 MW Vat Wrong' is not facet-valid with respect to pattern '[^ ]+ [^/^ ]+/[0-9]+' for type '#AnonType_InvoiceNo'."

Steps:

  1. Enter a sales order. Manually populate the Customer PO (VR01) field on the sales order header.
  2. Process the order until Sales Update and post the batch. Notice the VR01 is updated in F03B11 (Customer Ledger table)
  3. Run the R74L3001 and generate the XML SAFT file.
  4. Try to send it to the Portugal Tax Portal and notice it is not accepted due to error on the pattern of InvoiceNumber not being correct.

InvoiceNumber gets wrongly populated with the Reference value (SDVR01) instead of a combination of 'Legal Doc number' + 'Issue place'/'Document Number'.

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