Solved

Import Tax Details fields values for Bill via PUT request

  • 17 February 2022
  • 6 replies
  • 103 views

Userlevel 4
Badge +2

Hello,

I have an issue to export TaxDetails table to Acumatica together with bill data.

I prepared columns : TaxID, TaxRate, TaxableAmount, TaxAmount. for request

Request is received status OK, new bill Item is appeared at acumatica

, but tax details is empty

Is there any special conditions, with the help of which I can send TaxDetails table data to Acumatica?

 

icon

Best answer by jinin 17 February 2022, 19:05

View original

6 replies

Userlevel 6
Badge +3

hi @Ivan ,

Can you share request json?

Userlevel 7
Badge +11

Hi @Ivan 

The tax details insert the records based on the Tax configuration. 

  1. Need to configure the Tax zone at the Customer level or need to send the value in the API request call

Customer Level

Through API 


2. No need to send the tax details on the API call. Based on the provided tax rate or the Tax provider, the bill will calculate the tax by default.


 

Userlevel 4
Badge +2

hi @Ivan ,

Can you share request json?

Hi @praveenpo 

Sure

{

  "DueDate": {

    "value": "02/17/2019"

  },

  "LocationID": {

    "value": "MAIN"

  },

  "VendorRef": {

    "value": "I4GHK"

  },

  "Vendor": {

    "value": "MMF"

  },

  "Amount": {

    "value": "12.00"

  },

  "Date": {

    "value": "02/17/2019"

  },

  "PostPeriod": {

    "value": "01-2019"

  },

  "Balance": {

    "value": "12.00"

  },

   "TaxDetails": [

    {

      "TaxID": {

        "value": "CABCPST"

      },

      "TaxableAmount": {

        "value": "54.00"

      },

      "TaxRate": {

        "value": "54.00"

      },

      "TaxAmount": {

        "value": "354.00"

      }}]

}

Userlevel 4
Badge +2

Hi @Ivan 

The tax details insert the records based on the Tax configuration. 

  1. Need to configure the Tax zone at the Customer level or need to send the value in the API request call

Customer Level

Through API 


2. No need to send the tax details on the API call. Based on the provided tax rate or the Tax provider, the bill will calculate the tax by default.


 

Hi @jinin 

Thanks for detailed description

I do not have Financial entity available in endpoint for Vendor Tax Zone, but I have Financial Details available for adding , what I have already done

I have added tax zone

but I receive this error 

Here is my request

{

  "DueDate": {

    "value": "02/17/2019"

  },

  "LocationID": {

    "value": "MAIN"

  },

  "VendorRef": {

    "value": "I4GHK"

  },

  "Vendor": {

    "value": "MMF"

  },

  "Amount": {

    "value": "12.00"

  },

  "Date": {

    "value": "02/17/2019"

  },

  "PostPeriod": {

    "value": "01-2019"

  },

  "Balance": {

    "value": "12.00"

  },

    "VendorTaxZone": {

    "value": "ALAVARA"

  }

}

Userlevel 4
Badge +2

Hi @jinin 

Please, ignore my last comment

Everything is good 

Userlevel 7
Badge +11

Great @Ivan. Glad to help you to resolve the issue :slight_smile:

Reply


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