Skip to content

Workaround on records with more than 1k lines (with asyncUpsertList) #491

@diegopolido

Description

@diegopolido

Hey guys, how is it going? Now I'm facing a problem when I have a record with more than 1k lines. I got this error:

      <writeResponse>
        <platformCore:status xmlns:platformCore="urn:core_2021_1.platform.webservices.netsuite.com" isSuccess="false">
          <platformCore:statusDetail type="ERROR">
            <platformCore:code>JE_MAX_ONE_LINE</platformCore:code>
            <platformCore:message>Journal Entries can have a maximum of 1000 lines.</platformCore:message>
          </platformCore:statusDetail>
        </platformCore:status>
        <baseRef xmlns:platformCore="urn:core_2021_1.platform.webservices.netsuite.com" externalId="IFJE2021-08-25" type="journalEntry" xsi:type="platformCore:RecordRef"/>
      </writeResponse>

The support company guys said that is possible to send records up to 10k lines if it's been sent by asyncUpsertList:

Hi Diego,
The team brainstormed and found that you can create Journals with up to 10000 lines using  "asyncUpsertList" operation instead of "upsertList", in Upsert operation you receive response right after request but in Async operation NetSuite issues job id, using it you have to query again and check the job status in NetSuite.

However, I saw that we don't have an async_upsert_list on Journal Entry and Inventory Adjustment types (neither on the project).

How do you guys suggest to sole this problem? I can't split the lines (it's too complex to split those lines).

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions