Skip to main content
Solved

GET custom field generates an error

rcreasy
Varsity I
Forum|alt.badge.img

I am attempting to get the Tax Rate from a SalesInvoice.
I have created a custom field - in SalesInvoice->TaxDetails I added TaxRate with the Mapped Object Taxes and the mapped field Tax Rate.

I am calling this field, and others with a GET request to the following:

/entity/[My Custom Endpoint]/22.200.001/SalesInvoice?%24filter=CustomerOrder%20eq%20'nnnnnnnnnnn'&%24expand=Details,TaxDetails&%24select=CustomerID,CustomerOrder,ReferenceNbr,Description,Amount,Status,Details%2FOrderNbr,TaxDetails%2FTaxRate


Without my custom field in the URI the result is as expected.
With my custom field I get:

 "Optimization cannot be performed.The following fields cause the error:\r\nTaxDetails.TaxID: View Taxes has BQL delegate\r\n",


How can I get the data from my custom field? Or, do I need to set the custom field up differently?

Best answer by rcreasy

I was able to solve this issue by making a separate call to the individual invoice to pull just the TaxRate.

In case it helps someone in the future, here is what I did.

With the first call I get the info I need other than the TaxRate:


/entity/[My Custom Endpoint]/22.200.001/SalesInvoice?%24filter=CustomerOrder%20eq%20'nnnnnnnnnnn'&%24expand=Details&%24select=CustomerID,CustomerOrder,ReferenceNbr,Description,Amount,Status,Details%2FOrderNbr

 

Then, using the ReferenceNbr from the above, I make the call:

 

entity/[My Custome Endpoint]/22.200.001/SalesInvoice/Invoice/[ReferenceNbr from the call above]?%24expand=TaxDetails&%24select=TaxDetails%2FTaxRate

 

@Django from your explanation above, I am assuming the first call actually looks at all SalesInvoices, but filters them based on the filter. And, that is the reason it fails. My second call above looks at just one specific SalesOrder, and avoids the issue. 

HTH someone

View original
    Did this topic help you find an answer to your question?

    4 replies

    D
    Captain II
    Forum|alt.badge.img+6
    • Django
    • Captain II
    • 554 replies
    • August 1, 2023

    The challenge is that the Taxes view has a view delegate and thus the API doesn’t want to return all of the records because each record in the Taxes view is likely performing some sort of database lookup and separate processing.

    Given that taxes are likely to be a low number of records for a given order you could look at adding another view to the graph that is used to expose the TaxTran records related to the invoice. This will require that you add a tab to the screen but you can hide that as required so you don’t throw off the users.

    Chris Hackett
    rcreasy
    2 people like this
    • Chris Hackett
      Chris Hackett
    • rcreasy
      rcreasy
    rcreasy
    Varsity I
    Forum|alt.badge.img
    • rcreasy
    • Author
    • Varsity I
    • 73 replies
    • Answer
    • August 1, 2023

    I was able to solve this issue by making a separate call to the individual invoice to pull just the TaxRate.

    In case it helps someone in the future, here is what I did.

    With the first call I get the info I need other than the TaxRate:


    /entity/[My Custom Endpoint]/22.200.001/SalesInvoice?%24filter=CustomerOrder%20eq%20'nnnnnnnnnnn'&%24expand=Details&%24select=CustomerID,CustomerOrder,ReferenceNbr,Description,Amount,Status,Details%2FOrderNbr

     

    Then, using the ReferenceNbr from the above, I make the call:

     

    entity/[My Custome Endpoint]/22.200.001/SalesInvoice/Invoice/[ReferenceNbr from the call above]?%24expand=TaxDetails&%24select=TaxDetails%2FTaxRate

     

    @Django from your explanation above, I am assuming the first call actually looks at all SalesInvoices, but filters them based on the filter. And, that is the reason it fails. My second call above looks at just one specific SalesOrder, and avoids the issue. 

    HTH someone

    D
    Chris Hackett
    RohitRattan88
    3 people like this
    • D
      Django
    • Chris Hackett
      Chris Hackett
    • RohitRattan88
      RohitRattan88
    D
    Captain II
    Forum|alt.badge.img+6
    • Django
    • Captain II
    • 554 replies
    • August 1, 2023

    Oh good!  Yes, I’m so used to querying multiple records that I forgot about this. I knew there had to be a way!

    Chris Hackett
    rcreasy
    2 people like this
    • Chris Hackett
      Chris Hackett
    • rcreasy
      rcreasy
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • 2754 replies
    • August 1, 2023

    Thank you for sharing your solution with the community @rcreasy!

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    rcreasy
    1 person likes this
    • rcreasy
      rcreasy

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved