Guys getting "500 internal server" in Invoice Json after passing TermId

Devansh Dev
Devansh Dev Member Posts: 16
edited November 2017 in Reckon One
I am passing TermId in Json and i am getting "500 internal error". Json also given below. If i am not passing TermId then its works fine for me. Please let me know where i am wrong.


{"CustomerId":"2f75c46d-7610-4415-a01b-5e8d71999b04","AmountTaxStatus":2,"InvoiceAmount":100.0,"InvoiceDiscountAmount":null,"InvoiceDiscountPercentage":null,"InvoiceTax":0.0,"Notes":null,"PaymentDetails":null,"Reference":"test ref","TemplateId":"0fab77f0-4753-409f-896f-c664a0b30730","InvoiceDate":"2017-07-13T00:00:00+00:00","SendDate":null,"DueDate":"2017-07-14T00:00:00+00:00","ClassificationId":"","Address":null,"TaxSummaryText":null,"LineItems":[{"InvoiceId":"00000000-0000-0000-0000-000000000000","Name":null,"ParentInvoiceLineItemId":null,"BillableId":null,"DiscountAmountExTax":null,"DiscountAmountTax":null,"DiscountAccuracy":null,"DiscountPercent":null,"Amount":100.0,"AmountAccuracy":null,"InvoiceDiscountedAmountExTax":100.0,"InvoiceDiscountedTaxAmount":0.0,"HasDataForPosting":true,"IsSubTotal":false,"IsParent":false,"IsHidden":false,"AccountName":null,"AccountId":"00000000-0000-0000-0000-000000000000","PrintGroupAsSingleLine":false,"ChargeableItemId":"5eac7b74-1546-49a2-b6d9-96f1ed882285","LineNo":1,"Description":"","Quantity":1.0,"ProjectId":"9cc409b1-41b4-49fb-a532-855a11012f12","UnitPriceExTax":100.0,"UnitPriceTax":0.0,"UnitPricePrecision":2.0,"UnitPriceIsTaxInclusive":false,"TaxGroupId":"3372a8f1-0810-44de-913b-fe0e50cb38cc","TaxIsModified":false,"TaxAmount":0.0,"AmountExTax":100.0}],"TermID":"031fcb10-37e3-49f7-b259-a27a7cbe5eb3"}



Comments

  • gazza73
    gazza73 Accredited Partner Posts: 802 Accredited Partner Accredited Partner
    edited August 2017
    Devanash

    Is that upper/lower case spelling of TermID  meant to be TermId   perhaps?


    For API development assistance,  refer to http://demo.buildmgr.com.au/api
    (note much of this is generic help and still relates to API v1.  v2.2 under developemnt at our end still)




    Gary Pope
    m: 0408994799
    e:  gaz@alchester.com.au
    An Accredited Partner- Consultant (VIC. Aust)
    http://www.alchester.com.au/reckon-ac
    “Working with Accountants/Bookkeepers PPs/APs, as an
         independent IT Professional and retired FCPA Accountant”

  • Simon Hutchinson_8164484
    Simon Hutchinson_8164484 Alumni Posts: 135
    edited August 2017
    Hi Devanash

    Can you please try it with the TermID being set before the Array

    Thank you
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    Thanks Gary for reply, but it doesn't work. Yes yesterday i tried with "PaymentTermId" and i didn't get "500 Internal Error" but payment term which we are sending from Json is not getting selected in drop down in Invoice (Reckon Panel).
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    Thanks Simon for reply, but it doesn't work. Yes yesterday i tried with "PaymentTermId" and i didn't get "500 Internal Error" but payment term which we are sending from Json is not getting selected in drop down in Invoice (Reckon Panel).
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    image
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    image
  • Simon Hutchinson_8164484
    Simon Hutchinson_8164484 Alumni Posts: 135
    edited July 2017
    Hi Devansh

    Thank you, we have identified a problem with the terms element on the invoices endpoint that we will need to resolve.

    For the moment you will not be able to post a invoice with terms attached, I will provide an update once this is resolved.

    Cheers
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    Thanks Simon .. How soon we can get the update ? Actually we are in between to make the reckon integration on live.
  • Simon Hutchinson_8164484
    Simon Hutchinson_8164484 Alumni Posts: 135
    edited July 2017
    Hi Devansh

    We have resolved this now and will be looking to deploy the update this afternoon. I will keep you posted.
  • Simon Hutchinson_8164484
    Simon Hutchinson_8164484 Alumni Posts: 135
    edited July 2017
    Hi Devansh 

    This is now resolved

    Thanks

    Simon

  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    Thanks Simon :-)
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    Hi Simon, Another two queries here ...

    1. I can't able to delete particular project record. Showing me popup "An unexpected error occurred". I want to delete my dummy data.

    2. Do we have option to delete paid invoice? Same dummy data want to delete.



  • Simon Hutchinson_8164484
    Simon Hutchinson_8164484 Alumni Posts: 135
    edited July 2017
    hi Devansh, to delete a paid invoice you first need to delete the linked payment. If you do a GET by ID on the specific invoice it should return to you the linked transaction id that you need to delete first
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    imageimageimage
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    I didn't see any Transaction Id. Please look at the attachments and let me know.
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    Also you didn't gave me the reply of this question.

    1. I can't able to delete particular project record. Showing me popup "An unexpected error occurred". I want to delete my dummy data.

  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    One more issue Simon, I am creating bills from portal. Json is given below:

    {
      "AccountsPayableAccountingCategoryId": "f36c7731-9a70-45e7-9a62-95ae2c2d9368",
      "Address": null,
      "AmountTaxStatus": 3,
      "BillAmount": 4.4,
      "BillDate": "2017-07-19T00:00:00",
      "BillDiscount": null,
      "BillDiscountAmount": null,
      "BillDiscountPercentage": null,
      "BillSourceId": "00000000-0000-0000-0000-000000000000",
      "BillTax": 0.4,
      "DueDate": "2017-07-30T00:00:00",
      "LineItems": [
        {
          "AccountId": null,
          "AccountingCategoryId": "3aa1339b-2282-46ce-9572-faa271ff1090",
          "Amount": 4.0,
          "AmountExTax": 4.0,
          "ChargeableItemId": "5eac7b74-1546-49a2-b6d9-96f1ed882285",
          "Description": null,
          "DiscountAmountExTax": null,
          "DiscountAmountTax": null,
          "DiscountPercent": null,
          "HasDataForPosting": true,
          "InvoiceDiscountedAmountExTax": 4.0,
          "InvoiceDiscountedTaxAmount": 0.4,
          "IsHidden": false,
          "IsParent": false,
          "IsSubTotal": false,
          "LineNo": 1,
          "PrintGroupAsSingleLine": false,
          "ProjectId": "e1d644fd-9280-4be7-88ed-8b99cbcd64a6",
          "Quantity": 2.0,
          "TaxAmount": 0.4,
          "TaxGroupId": "44407d2f-e0cc-41c6-a0be-6fb6063dc9f0",
          "TaxIsModified": false,
          "UnitPriceExTax": 2.0,
          "UnitPricePrecision": 8.0,
          "UnitPriceTax": 0.0
        }
      ],
      "Notes": null,
      "Reference": null,
      "SendDate": null,
      "Status": 2,
      "SupplierId": "2f75c46d-7610-4415-a01b-5e8d71999b04",
      "TemplateId": "8bc94f1e-dc70-4eea-afee-8b5a99929ec8"
    }


    Json returns the error "Error creating a new bill for this cashbook."

    But if i go to my panel after login, i can see the bill is created. Please let me know if i am wrong.
  • Devansh Dev
    Devansh Dev Member Posts: 16
    edited July 2017
    I need your help Simon. I have pending only these three above points.