Skip to main content
Solved

Import Tax Details fields values for Bill via PUT request

  • Feb 17, 2022 3:12 PM UTC
  • 6 replies
  • 207 views
  • Translate All

Forum|alt.badge.img+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?

 

Best answer by jinin

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.


 

View original

6 replies

praveenpo
Semi-Pro III
Forum|alt.badge.img+3
  • Semi-Pro III
  • Feb 17, 2022 3:30 PM UTC

hi @Ivan ,

Can you share request json?

Translate

jinin
Pro I
Forum|alt.badge.img+12
  • Pro I
  • Answer
  • Feb 17, 2022 6:05 PM UTC

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.


 

Translate

Forum|alt.badge.img+2
  • Author
  • Varsity I
  • Feb 17, 2022 6:35 PM UTC

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"

      }}]

}

Translate

Forum|alt.badge.img+2
  • Author
  • Varsity I
  • Feb 17, 2022 6:51 PM UTC

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"

  }

}

Translate

Forum|alt.badge.img+2
  • Author
  • Varsity I
  • Feb 17, 2022 7:04 PM UTC

Hi @jinin 

Please, ignore my last comment

Everything is good 

Translate

jinin
Pro I
Forum|alt.badge.img+12
  • Pro I
  • Feb 18, 2022 5:27 AM UTC

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

Translate