Hi Team, Hope you are doing well. We have a question. We are using a request to retrieve a journal entry from the NetSuite: 2022-12-31T00:00:01.000Z 2022-12-31T00:00:01.000Z false _invoicePendingApproval _invoiceRejected _journalPendingApproval _paymentUnapprovedPayment _journalRejected Originally in NetSuite, we can see for journal MJE-196882 only values equals 2668,98 EUR (Amount, Amount remaining, Foreign amount, and Foreign amount remaining) But in response from the NetSuite, we see the Amount remaining is not 2668,98 but 3,134.54. Could you please tell me the reason for such a situation?

Hello @Andrii Siryi, I noticed that you are using WSDL Version 2020.1, we would have endorsed your concern to our support team, however, they only support versions that are 6 versions behind the current one. With this, I suggest that you update your SOAP Request to the latest WSDL Version and check if you still encounter the same behavior. If so, please let us know so that we can create a case on your behalf. For more information, please see Support for Existing WSDL Versions. Thank you!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Child Item

Ask A Guru

Child Item

SOAP WS: Amount remaining for "Journal entries"

AndriiSiryi

Hi Team,

Hope you are doing well.

We have a question.

We are using a request to retrieve a journal entry from the NetSuite:

 <soapenv:Body>
        <search xmlns="urn:messages_2020_1.platform.webservices.netsuite.com">
            <searchRecord xmlns:ns12="urn:sales_2020_1.transactions.webservices.netsuite.com" xsi:type="ns12:TransactionSearchAdvanced">
                <ns12:criteria xsi:type="ns12:TransactionSearch">
                    <ns12:basic xmlns:ns13="urn:common_2020_1.platform.webservices.netsuite.com" xsi:type="ns13:TransactionSearchBasic">
                        <ns13:account xmlns:ns14="urn:core_2020_1.platform.webservices.netsuite.com" operator="anyOf" xsi:type="ns14:SearchMultiSelectField">
                            <ns14:searchValue externalId="" internalId="7" type="account" xsi:type="ns14:RecordRef">
                                <ns14:name xsi:type="xsd:string"/>
                            </ns14:searchValue>
                        </ns13:account>
                        <ns13:lastModifiedDate xmlns:ns15="urn:core_2020_1.platform.webservices.netsuite.com" operator="within" xsi:type="ns15:SearchDateField">
                            <ns15:searchValue xsi:type="xsd:dateTime">2022-12-31T00:00:01.000Z</ns15:searchValue>
                            <ns15:searchValue2 xsi:type="xsd:dateTime">2022-12-31T00:00:01.000Z</ns15:searchValue2>
                        </ns13:lastModifiedDate>
                        <ns13:memorized xmlns:ns16="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns16:SearchBooleanField">
                            <ns16:searchValue xsi:type="xsd:boolean">false</ns16:searchValue>
                        </ns13:memorized>
                        <ns13:status xmlns:ns17="urn:core_2020_1.platform.webservices.netsuite.com" operator="noneOf" xsi:type="ns17:SearchEnumMultiSelectField">
                            <ns17:searchValue xsi:type="xsd:string">_invoicePendingApproval</ns17:searchValue>
                            <ns17:searchValue xsi:type="xsd:string">_invoiceRejected</ns17:searchValue>
                            <ns17:searchValue xsi:type="xsd:string">_journalPendingApproval</ns17:searchValue>
                            <ns17:searchValue xsi:type="xsd:string">_paymentUnapprovedPayment</ns17:searchValue>
                            <ns17:searchValue xsi:type="xsd:string">_journalRejected</ns17:searchValue>
                        </ns13:status>
                    </ns12:basic>                   
                </ns12:criteria>
                <ns12:columns xsi:type="ns12:TransactionSearchRow">
                    <ns12:basic xmlns:ns20="urn:common_2020_1.platform.webservices.netsuite.com" xsi:type="ns20:TransactionSearchRowBasic">
                        <ns20:account xmlns:ns21="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns21:SearchColumnSelectField"/>
                        <ns20:accountType xmlns:ns22="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns22:SearchColumnEnumSelectField"/>
                        <ns20:amount xmlns:ns23="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns23:SearchColumnDoubleField"/>
                        <ns20:amountPaid xmlns:ns24="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns24:SearchColumnDoubleField"/>
                        <ns20:amountRemaining xmlns:ns25="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns25:SearchColumnDoubleField"/>
                        <ns20:creditAmount xmlns:ns26="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns26:SearchColumnDoubleField"/>
                        <ns20:currency xmlns:ns27="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns27:SearchColumnSelectField"/>
                        <ns20:debitAmount xmlns:ns28="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns28:SearchColumnDoubleField"/>
                        <ns20:entity xmlns:ns29="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns29:SearchColumnSelectField"/>
                        <ns20:exchangeRate xmlns:ns30="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns30:SearchColumnDoubleField"/>
                        <ns20:fxAmount xmlns:ns31="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns31:SearchColumnDoubleField"/>
                        <ns20:internalId xmlns:ns32="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns32:SearchColumnSelectField"/>
                        <ns20:lastModifiedDate xmlns:ns33="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns33:SearchColumnDateField"/>
                        <ns20:line xmlns:ns34="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns34:SearchColumnLongField"/>
                        <ns20:lineUniqueKey xmlns:ns35="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns35:SearchColumnLongField"/>
                        <ns20:recordType xmlns:ns36="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns36:SearchColumnStringField"/>
                        <ns20:refNumber xmlns:ns37="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns37:SearchColumnLongField"/>
                        <ns20:status xmlns:ns38="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns38:SearchColumnEnumSelectField"/>
                        <ns20:subsidiary xmlns:ns39="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns39:SearchColumnSelectField"/>
                        <ns20:total xmlns:ns40="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns40:SearchColumnDoubleField"/>
                        <ns20:tranDate xmlns:ns41="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns41:SearchColumnDateField"/>
                        <ns20:tranId xmlns:ns42="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns42:SearchColumnStringField"/>
                        <ns20:type xmlns:ns43="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="ns43:SearchColumnEnumSelectField"/>
                    </ns12:basic>                    
                </ns12:columns>
            </searchRecord>
        </search>
    </soapenv:Body>
</soapenv:Envelope>

Originally in NetSuite, we can see for journal MJE-196882 only values equals 2668,98 EUR (Amount, Amount remaining, Foreign amount, and Foreign amount remaining)

Remaining and remaing foregin currency.png

But in response from the NetSuite, we see the Amount remaining is not 2668,98 but 3,134.54. Could you please tell me the reason for such a situation?

Find more posts tagged with

journal entry

SOAP WS

Component react.asset.answerThread had an error.

You are not allowed to view comments.

Child Item

Upcoming Events

SuiteWorld | October 25–28, 2026 | Las Vegas
Big ideas. No travel required. SuiteWorld On Air brings the best of SuiteWorld directly to you. Stream keynotes live, access exclusive virtual content, and connect with the NetSuite community from wherever you are. Explore what's next for NetSuite, see AI innovation in action, and discover practical insights designed to…
Learning Lab | DC
Drive better outcomes with AI built into NetSuite Next Capital Hilton,1001 16th St NW, Washington, DC 20036 Join NetSuite experts for a free half-day event where you'll get a tour of NetSuite Next, explore AI-powered capabilities built into the platform, and learn practical ways to optimize NetSuite for your business. At…
Inside the Suite | DC
Take NetSuite Next for a hands-on test drive Capital Hilton, 1001 16th St NW, Washington, DC 20036 What to expect: Inside the Suite is designed for companies exploring modern ERP solutions. This event gives you the opportunity to experience NetSuite Next - the next evolution of NetSuite that brings AI directly into how…
What's Next for Product Companies with NetSuite
WEBINAR What's Next for Product Companies with NetSuite See how NetSuite Next uses AI to improve accuracy and protect margins Ask. Understand. Act. Use Ask Oracle to search, navigate, analyze business data, surface insights, get guidance, and take action using natural language—all through a single conversational…

More events