Create a Bill with Tax Parameters Overridden

If you are using the contract-based REST API to integrate MYOB Acumatica with an external system, this external system can create bills with the tax parameters overridden.

Testing of the Request

Before you test the code below, do the following to configure your client application and the MYOB Acumatica instance to be used:

  1. Deploy a new MYOB Acumatica instance with the SalesDemo dataset. For details on deploying an instance, see To Deploy an MYOB Acumatica Instance.
  2. On the Enable/Disable Features (CS100000) form, make sure the Inventory and Order Management feature is enabled.
  3. If you use Postman as the client application for testing, in the IntegrationDevelopmentGuide.postman_collection.json collection (which is located in the IntegrationDevelopment\Help folder of the Help-and-Training-Examples repository on GitHub), make sure the collection variables have the proper values.
  4. To sign in to the instance in the client application, use the tenant name (which you specified when you created the instance) and the PRODWHOLE branch.

To further prepare the system, you need to create a tax and a tax category that uses this tax, and modify the existing tax zone so that it will use the new tax. You perform these tasks as follows:

Tip: If you use the IntegrationDevelopmentGuide.postman_collection.json Postman collection for testing, you do not need to perform the following configuration steps because they are performed in the pre-request script.
  1. On the Taxes (TX205000) form, create a tax with the tax schedule as follows:
    1. Create a tax with the following parameters:
      • Tax ID: PST
      • Description: Tax ID for testing
      • Tax Type: VAT
      • Include in VAT Taxable Total: Selected
      • Exclude from Tax on Tax Calculation: Selected
      • Tax Agency: CANADABC
    2. On the Tax Schedule tab of the form, add two rows with the following data.
      Column First Row Second Row
      Start Data 1/1/1900 1/1/1900
      Tax Rate 5 5
      Min. Taxable Amount 0 0
      Max. Taxable Amount 0 0
      Reporting Group Input Tax (purchases) Output Tax (sales)
      Group Type Input Output
    3. Click Save.
  2. On the Tax Categories (TX205500) form, create the TEST tax category with the Tax category for test description and add the CAGST and PST taxes to the tax category.
  3. On the Applicable Taxes tab of the Tax Zones (TX206000) form, add the PST tax to the CANADABC tax zone.

Request

You can use the following example of an HTTP request to create an AP bill with the tax parameters that are different from those registered in the system.

Tip: In the request example below, <MYOB Acumatica instance URL> is the URL of the MYOB Acumatica instance (such as https://my.acumatica.com/MyInstance). You can omit the instance name in the URL (that is, you can use https://my.acumatica.com) if the instance is installed in the root of the website.
PUT ?$expand=Details,TaxDetails HTTP/1.1
Host: [<MYOB Acumatica instance URL>]/entity/Default/23.200.001/Bill
Accept: application/json
Content-Type: application/json

{
    "Amount": {
        "value": 1120.0
    },
    "CashDiscountDate": {
        "value": "11/18/2021"
    },
    "CurrencyID": {
        "value": "USD"
    },
    "Date": {
        "value": "10/18/2021"
    },
    "DueDate": {
        "value": "11/18/2021"
    },
    "Hold": {
        "value": false
    },
    "LocationID": {
        "value": "MAIN"
    },
    "PostPeriod": {
        "value": "102021"
    },
    "Status": {
        "value": "Balanced"
    },
    "TaxAmount": {
        "value": 120.0
    },
    "Terms": {
        "value": "30D"
    },
    "Type": {
        "value": "Bill"
    },
    "Vendor": {
        "value": "AAVENDOR"
    },
    "VendorRef": {
        "value": "test-API22"
    },
    "Description": {
        "value": "test-API"
    },
    "IsTaxValid": {
        "value": true
    },
    "Details": [
        {
            "Account": {
                "value": "50000"
            },
            "Branch": {
                "value": "PRODWHOLE"
            },
            "CostCode": {
                "value": null
            },
            "ExtendedCost": {
                "value": 1000.0
            },
            "Project": {
                "value": "X"
            },
            "Subaccount": {
                "value": "000000"
            },
            "TaxCategory": {
                "value": "TEST"
            }
        }
    ],
    "TaxDetails": [
        {
            "TaxID": {
                "value": "CAGST"
            },
            "TaxableAmount": {
                "value": 1000.0
            },
            "TaxAmount": {
                "value": 150.0
            },
            "ExpenseAmount": {
                "value": 0.0
            }
        },
        {
            "TaxID": {
                "value": "PST"
            },
            "TaxableAmount": {
                "value": 1000.0
            },
            "TaxAmount": {
                "value": 150.0
            },
            "custom": {
                "Taxes": {
                    "CuryExpenseAmt": {
                        "type": "CustomDecimalField",
                        "value": 70
                    }
                }
            }
        }
    ],
    "custom": {
        "CurrentDocument": {
            "TaxZoneID": {
                "type": "CustomStringField",
                "value": "CANADABC"
            }
        }
    }
}
In the request above, you have set the IsTaxValid value to true to use in the bill the tax parameters specified in the TaxDetails field. If you do not specify this value, the tax parameters that are registered in the system will be used instead. In particular, the tax amounts equal to 50 will be set both for the CAGST and PST taxes in the created bill.

Usage Notes

If the IsTaxValid field is specified in the request body, its value is set to true, and an external tax zone is specified, then the tax details from the request body are used without modification, and no other taxes are applied.

If the IsTaxValid field is specified in the request body, its value is set to true, and an internal tax zone is specified, then the tax details from the request body are compared to those calculated by the system. If the taxes specified in the request body are present among those calculated by the system, then the tax details from the request body are used without modification and no other taxes are applied.

If the IsTaxValid field is not specified in the request body or its value is not set to true, tax calculation is performed by the system.