Hi all,
When I try to get the Sales invoice data using rest API means, the sales invoice item table is missing in that JSON object.
Here is a screenshot, kindly do the needful.
{
“data”: [
{
“gst_vehicle_type”: “Regular”,
“cash_bank_account”: null,
“flipkart_series”: “”,
“lr_date”: “2019-12-21”,
“flipkart_start_range”: 0,
“customers_invoice_no”: null,
“base_write_off_amount”: 0,
“modified_by”: “nithya@pss.com”,
“title”: “URBAN WEAR”,
“selling_price_list”: “Standard Selling”,
“return_against”: null,
“tc_name”: null,
“source”: null,
“shipping_bill_number”: null,
“tax_id”: null,
“base_in_words”: “INR Seventy Thousand, Seven Hundred And Thirty Three only.”,
“due_date”: “2020-05-01”,
“ignore_pricing_rule”: 0,
“write_off_cost_center”: null,
“invoice_type”: “Regular”,
“_assign”: null,
“base_discount_amount”: 0,
“invoice_copy”: “Original for Recipient”,
“_seen”: “["aravind_g@pss.com", "nithya@pss.com"]”,
“base_total_taxes_and_charges”: 3368.2,
“purchase_by”: “/”,
“shipping_address_name”: “”,
“pos_profile”: null,
“ecommerce_gstin”: null,
“discount_amount”: 0,
“reason_for_return”: null,
“name”: “PDGB/19/1270”,
“is_return”: 0,
“write_off_outstanding_amount_automatically”: 0,
“redeem_loyalty_points”: 0,
“select_print_heading”: null,
“base_rounding_adjustment”: 0,
“is_pos”: 0,
“port_code”: null,
“parentfield”: null,
“against_income_account”: “Sales - Digital - Printing Job Work - PSS”,
“write_off_amount”: 0,
“update_billed_amount_in_sales_order”: 0,
“creation”: “2020-02-01 17:59:27.441834”,
“party_account_currency”: “INR”,
“product_received_in_good_condition”: “”,
“owner”: “nithya@pss.com”,
“group_same_items”: 0,
“is_discounted”: 0,
“total_qty”: 1472,
“cost_center”: null,
“po_date”: null,
“scan_barcode”: “”,
“default_warehouse”: null,
“price_list_currency”: “INR”,
“driver_name”: null,
“customers_mobileno”: null,
“total_taxes_and_charges”: 3368.2,
“contact_display”: null,
“loyalty_points”: 0,
“set_warehouse”: null,
“pos_total_qty”: 0,
“customers_state”: “”,
“loyalty_redemption_account”: null,
“write_off_account”: null,
“terms”: “”,
“vehicle_no”: null,
“parent”: null,
“submitted_by”: “nithya@pss.com”,
“place_of_supply”: “29-Karnataka”,
“shopify_order_id”: null,
“is_opening”: “No”,
“allocate_advances_automatically”: 0,
“customer_address”: “URBAN WEAR-Billing”,
“sales_type”: “Counter”,
“total_commission”: 0,
“contact_mobile”: null,
“mode_of_transport”: “Road”,
“security_passed”: “Yes”,
“_user_tags”: null,
“c_form_applicable”: “No”,
“base_net_total”: 67364.8,
“language”: “en”,
“gst_transporter_id”: null,
“rounded_total”: 0,
“customer_group”: “PT/Other States”,
“apply_discount_on”: “Grand Total”,
“offline_pos_name”: null,
“po_no”: null,
“stock_entry”: null,
“auto_repeat”: null,
“contact_person”: null,
“in_words”: “INR Seventy Thousand, Seven Hundred And Thirty Three only.”,
“additional_discount_percentage”: 0,
“campaign”: null,
“export_type”: “Without Payment of Tax”,
“md_approval_status”: “”,
“base_paid_amount”: 0,
“submitted_on”: “2020-02-04”,
“conversion_rate”: 1,
“to_date”: null,
“set_posting_time”: 0,
“total_advance”: 0,
“posting_time”: “9:40:13.528375”,
“total”: 67364.8,
“customer_name”: “URBAN WEAR”,
“ifsc_code”: null,
“purchaser_mobile_no”: “/”,
“payment_terms_template”: “Default Payment Term - EO2M”,
“commission_rate”: 0,
“update_stock”: 1,
“_comments”: null,
“base_total”: 67364.8,
“total_pcs_qty”: “0”,
“from_date”: null,
“name_of_commodity”: “”,
“account_for_change_amount”: null,
“territory”: “Bangalore”,
“sales_partner”: null,
“other_charges_calculation”: “<div class="tax-break-up" style="overflow-x: auto;">\n\t<table class="table table-bordered table-hover">\n\t\t\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t<th class="text-left">HSN/SAC\n\t\t\t\t\t\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t<th class="text-right">Taxable Amount\n\t\t\t\t\t\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t<th class="text-right">Sales Tirupur IGST @ 5% - PSS\n\t\t\t\t\t\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t<th class="text-right">Round Off - PSS\n\t\t\t\t\t\n\t\t\t\t\n\t\t\t\n\t\t\n\t\t\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t998821\n\t\t\t\t\t<td class="text-right">\n\t\t\t\t\t\t₹ 67,364.80\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t<td class="text-right">\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t(5.0%)\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t₹ 3,368.24\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t<td class="text-right">\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t₹ -0.04\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\n\t\t\t\n\t\t\n\t\n”,
“bank_name”: null,
“customers_name”: null,
“company”: “Pranera Services and Solutions Pvt. Ltd.,”,
“barcode_name”: null,
“contact_email”: null,
“tax_category”: “”,
“customer”: “URBAN WEAR”,
“distance”: 0,
“grand_total”: 70733,
“idx”: 1,
“reverse_charge”: “N”,
“customer_gstin”: null,
“modified”: “2020-02-04 09:40:12.840265”,
“no_of_boxes_or_rolls”: “6”,
“project”: “PRANERA DIGITAL”,
“rounding_adjustment”: 0,
“shipping_address”: null,
“posting_date”: “2020-02-04”,
“debit_to”: “Debtors - PSS”,
“address_display”: “No.295,Ground Floor,6th Main Road,5th cross,Chamundeshwari Nagar
Devarachikkanahalli Main Road
Banglore-560068
\nKarnataka,\nState Code: 29
India
\nPhone: 8892640666
Email: urbanwearllp@gmail.com
GSTIN: 29AAEFU9368H1ZH
”,
“naming_series”: “PDGB/19/.#”,
“company_gstin”: “33AAECP8397C1ZA”,
“lr_number”: null,
“proforma_invoice”: null,
“currency”: “INR”,
“letter_head”: “CUSTOM__PSS_DIGITAL_LOGO”,
“gst_no”: “Registered Dealer”,
“shipping_rule”: null,
“payment_terms”: null,
“company_address_display”: “1-A, Sastri Nagar, S.A.K. Lay Out,
Angeripalayam Road
Tirupur - 641603
\nTamil Nadu,\nState Code: 33
India
\nPhone: 0421-2487996
Email: info@praneraservices.com
GSTIN: 33AAECP8397C1ZA
”,
“shipping_bill_date”: null,
“total_quantity”: 1472,
“paid_amount”: 0,
“pay”: “To Pay”,
“base_change_amount”: 0,
“loyalty_redemption_cost_center”: null,
“amended_from”: null,
“base_grand_total”: 70733,
“customers_address”: null,
“docstatus”: 0,
“status”: “Draft”,
“total_billing_amount”: 0,
“_liked_by”: null,
“gst_category”: “Registered Regular”,
“lr_no”: null,
“taxes_and_charges”: “Inter State TN GST On Sales @ 5%”,
“driver”: null,
“outstanding_amount”: 70733,
“change_amount”: 0,
“ewaybill”: null,
“transporter_name”: null,
“total_net_weight”: 0,
“loyalty_amount”: 0,
“flipkart_end_range”: 0,
“remarks”: “No Remarks”,
“transporter”: null,
“inter_company_invoice_reference”: null,
“c_form_no”: null,
“loyalty_program”: null,
“billing_address_gstin”: “29AAEFU9368H1ZH”,
“plc_conversion_rate”: 1,
“parenttype”: null,
“net_total”: 67364.8,
“account_number”: null,
“company_address”: “Pranera Tirupur”,
“reason_for_issuing_document”: “”,
“base_rounded_total”: 0
}
]
}