Skip to main content
Solved

Sales Order creation via Rest APIs with Manual Sale Tax override

  • December 4, 2022
  • 4 replies
  • 629 views

SBalmer1
Freshman I

We can easily import sales order with Acumatica REST APIs but we cant get TaxOverrides to work during the api call.  We did create a Manual Tax zone and Tax ID  and both comes in but when the order gets created but the tax amount comes in at zero and not the values we send in.

For example this below JSON  crates the order but tax amount comes to zero instead of $2

{

  "OrderType": {  "value": "SO"  },

  "CustomerID": {  "value": "AMAZONG"  },

  "Details": [ {"InventoryID": {  "value": "SKU1"   }, 

       "OrderQty": { "value": 1 }, 

       "UOM": { "value": "EA" },

      "UnitPrice": { "value": 10.0 } } ],

  "FinancialSettings": { "OverrideTaxZone" : { "value": true },"CustomerTaxZone" : { "value": "MANUAL" } },

  "TaxDetails": [ { "TaxID": { "value": "MANUAL" }, 

       "TaxableAmount": { "value": 10.0 }, 

       "TaxAmount": { "value": 2.0 }  } ],

  "TaxTotal": { "value": 2.0 }

}

 

Once the order is created, users can go through the UI and open the order and in the taxes TAB, update the Tax amount. So it just seems like the system is not picking up the Tax Amount we are sending but its picking up the overrides tax zone and tax ID fine.

Any guidance on what we are doing wrong would be helpful ?

 

Best answer by jinin

Hi @SBalmer1 


We can create orders with Tax details. But need to set the “ IsTaxValid “as true.

Please refer to the below sample code.

{
    "OrderNbr": {
        "value": "<NEW>"
    },
    "OrderType": {
        "value": "SO"
    },
    "CustomerID": {
        "value": "327177"
    },
    "note": "",
    "CustomerOrder": {
        "value": "STG21002"
    },

    "IsTaxValid": {
        "value": true
    },
    "Details": [        
        {
            "note": "",
            "InventoryID": {
                "value": "020053"
            },
            "OrderQty": {
                "value": "1.0000"
            },
            "MasterQty": {
                "value": "1.0000"
            },
            "ManualPrice": {
                "value": true
            },
            "UnitPrice": {
                "value": 79.99
            },
            "ManualDIscount": {
                "value": true
            },
            "DiscountAmount": {
                "value": 0
            },
            "TaxCategory": {
                "value": "DEFAULT"
            }          
        }

    ]



    "FinancialSettings": {
        "OverrideTaxZone": {
            "value": true
        },
        "CustomerTaxZone": {
            "value": "MANUAL"
        },       
    },
    "TaxDetails": [
        {
            "TaxID": {
                "value": "MANUALID"
            },
            "TaxAmount": {
                "value": "5.8400"
            }
        }
    ],

    "Date": {
        "value": "12/01/2022"
    },
    "RequestedOn": {
        "value": "12/01/2022"
    }   
}

 

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

4 replies

praveenpo
Semi-Pro II
Forum|alt.badge.img+3
  • Semi-Pro II
  • 99 replies
  • December 5, 2022

Hi @SBalmer1 ,

We have this issue in Acumatica in few versions, we have to use the update call to update taxamount passing the unique ‘id’ recieved on the initial sales order create response call.


jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 702 replies
  • Answer
  • December 5, 2022

Hi @SBalmer1 


We can create orders with Tax details. But need to set the “ IsTaxValid “as true.

Please refer to the below sample code.

{
    "OrderNbr": {
        "value": "<NEW>"
    },
    "OrderType": {
        "value": "SO"
    },
    "CustomerID": {
        "value": "327177"
    },
    "note": "",
    "CustomerOrder": {
        "value": "STG21002"
    },

    "IsTaxValid": {
        "value": true
    },
    "Details": [        
        {
            "note": "",
            "InventoryID": {
                "value": "020053"
            },
            "OrderQty": {
                "value": "1.0000"
            },
            "MasterQty": {
                "value": "1.0000"
            },
            "ManualPrice": {
                "value": true
            },
            "UnitPrice": {
                "value": 79.99
            },
            "ManualDIscount": {
                "value": true
            },
            "DiscountAmount": {
                "value": 0
            },
            "TaxCategory": {
                "value": "DEFAULT"
            }          
        }

    ]



    "FinancialSettings": {
        "OverrideTaxZone": {
            "value": true
        },
        "CustomerTaxZone": {
            "value": "MANUAL"
        },       
    },
    "TaxDetails": [
        {
            "TaxID": {
                "value": "MANUALID"
            },
            "TaxAmount": {
                "value": "5.8400"
            }
        }
    ],

    "Date": {
        "value": "12/01/2022"
    },
    "RequestedOn": {
        "value": "12/01/2022"
    }   
}

 


SBalmer1
Freshman I
  • Author
  • Freshman I
  • 8 replies
  • December 7, 2022
praveenpo wrote:

Hi @SBalmer1 ,

We have this issue in Acumatica in few versions, we have to use the update call to update taxamount passing the unique ‘id’ recieved on the initial sales order create response call.

Thanks, but looks like update call is not needed :)  As @jinin mentioned, all that was needed was the additional IsTaxValid value to be set to true.  I don't know how he knew this but he did :)  Was this documented somewhere that I missed?


jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 702 replies
  • December 7, 2022
SBalmer1 wrote:
praveenpo wrote:

Hi @SBalmer1 ,

We have this issue in Acumatica in few versions, we have to use the update call to update taxamount passing the unique ‘id’ recieved on the initial sales order create response call.

Thanks, but looks like update call is not needed :)  As @jinin mentioned, all that was needed was the additional IsTaxValid value to be set to true.  I don't know how he knew this but he did :)  Was this documented somewhere that I missed?

Hi @SBalmer1,  Not sure if any document is available with this. But when we worked on this same scenario, identified the field used to validate the tax. :)


Reply


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