EGL9.2: Spreadsheet Journal import(JRNL1_WS) Getting "Errored: Document type is required for Business Unit" Error Even If Document Sequencing Is Disabled In Installation Options (Doc ID 2431824.1)

Last updated on JULY 13, 2023

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------
Getting the error “Document Type is required for Business Unit XXXXX.” when tried to import the journal through spreadsheet.

Steps to Replicate:
---------------------
1. Navigate to: Set up Financials > Install > Installation Options > Overall > Disable Document Sequencing
2. Navigate to: Set Up Financials/Supply Chain > Business Unit Related > General Ledger > General Ledger Definition. Search for any Business Unit.
Verify the Checkbox “Enable Document Sequencing” is grayed.
3. Open the new spreadsheet import template (JRNL1_WS.xlsm). Click on the Setups & Defaults button.
4. Create a new journal sheet.
5. Enter the journal header details.
6. Enter the journal Line details.
7. Import the journal using the online import button

Please follow the replication screenshots for more details.

Error:
------

Errored: Document type is required for Business Unit xxxxx.