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

Visit Redwood Community
Interface fails for NULL records in Amount column — 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

Interface fails for NULL records in Amount column

Received Response
11
Views
3
Comments

We are receiving Actuals numbers from source in CSV file and it contains NULL values for certain months.

We have prepared Multi column Import format with Periods in Columns (Jan - Dec)

When we try to load the numbers, it fails with warning for months where there is NULL.

It logs entry in log file with the note that "No records to process " for months where we try to load NULL

"2021-10-27 12:56:56,211 WARN [AIF]: Warning: No records exist for Period 'Jan-21'"

Is there any way we can load NULL entries in planning?

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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