Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
diegopolido opened this issue Oct 7, 2021 · 3 comments
Closed

Comments

@diegopolido
Copy link

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).

@diegopolido
Copy link
Author

I solved my problem by adding this PR to my fork and then add this new action to the Record Types I needed this PR and this PR

@iloveitaly
Copy link
Member

@diegopolido could you submit a PR to the main repo with those changes? Would love to have them in the master repo.

@diegopolido
Copy link
Author

@iloveitaly let's merge #169 PR and then I can open a new PR to add the actions on the records.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants