Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
'SEGMENT' values blank after Spreadsheet journal import in GL_INTERFACE — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

'SEGMENT' values blank after Spreadsheet journal import in GL_INTERFACE

Received Response
22
Views
1
Comments
edited May 18, 2020 11:35AM in General Ledger & Intercompany 1 comment

Summary

'SEGMENT' values blank after Spreadsheet import in GL_INTERFACE

Content

Hi,

When using the spreadsheet import for journals (multiple journals worksheet), we fill out the entire SEGMENT values by double clicking one cell and entering the Code Combination.

When importing to interface tables, we query the GL_INTERFACE table and see that the seperate SEGMENT values are not populated. The CCID clumn is filled with a proper ID though. It's possible to import the journal without an issue.

Since we have reporting requirements on the GL_INTERFACE step: why are the SEGMENT values not showing? They are showing when we are using REST API to load Journals, for example.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!