GoodsReceivedNotes PATCH REST API  Topic is solved

Discussions relating to the REST API of Jiwa 7.

GoodsReceivedNotes PATCH REST API

Postby minhhieu106 » Wed May 30, 2018 2:09 pm

Hi Mike,

I tried to use http://localhost/JIWAAPI/GoodsReceivedN ... 3944d59b9b PATH to update GRN status to "Activated". It seems does not working. Below is the JSON:

Code: Select all
{"Status":"Activated","SlipNo":"IPO100","SlipDate":"2018-05-30T09:56:58","Reference":10000000000000005,"Lines":[]}


This is response message:
Code: Select all

   "GRNID":"2c65c55e5a3944d59b9b",
   "CreditorID":"000000001G000000023M",
   "CreditorAccountNo":"5999",
   "CreditorName":"Imperial Importers",
   "LastSavedDateTime":"\/Date(1527649318417-0000)\/",
   "SlipNo":"0000000015",
   "SlipDate":"\/Date(1527649018000-0000)\/",
   "Status":"UnActivated",
   "Freight":0.000000,
   "Duty":0.000000,
   "Invoiced":false,
   "PI_MainID":"",
   "Insurance":0.000000,
   "LogicalWarehouseID":"00000000IB0000000003",
   "LogicalWarehouseDescription":"Bulk",
   "PhysicalWarehouseID":"00000000IB0000000002",
   "PhysicalWarehouseDescription":"Victoria",
   "TaxTotal":0.000000,
   "FreightTaxID":"GST01000000000000000",
   "FreightTaxRate":10.000000,
   "FreightTaxAmount":0,
   "DutyTaxID":"GST01000000000000000",
   "DutyTaxRate":10.000000,
   "DutyTaxAmount":0,
   "InsuranceTaxID":"GST01000000000000000",
   "InsuranceTaxRate":10.000000,
   "InsuranceTaxAmount":0,
   "Reference":"10000000000000005",
   "TotalGross":755.010000,
   "TotalNet":755.010000,
   "TotalFx":393.360000,
   "FreightInc":0.000000,
   "DutyInc":0.000000,
   "InsuranceInc":0.000000,
   "InventoryTotalQuantity":1.000000,
   "InventoryTotalQuantityDecimalPlaces":0,
   "Lines":[ 
      { 
         "LineID":"55b4f51e1e774320afbe",
         "QuantityOrdered":1.000000,
         "QuantityDelivered":0.000000,
         "OrderID":"707670751b854d90859f",
         "OrderNo":"100573",
         "OrderLineID":"876a5e7a-8be3-4411-b808-749216e762fc",
         "Quantity":1.000000,
         "InventoryID":"000000000E00000000NP",
         "PartNo":"01140008",
         "Aux2":" 111111111111",
         "Description":"BlackBerry Playbook Tablet PC WiFi 64GB",
         "SupplierPartNo":"01140008",
         "GRNLineType":"Inventory",
         "QuantityDecimalPlaces":0,
         "LastSavedDateTime":"\/Date(1527649047087-0000)\/",
         "ClassificationID":"00000000NX00000000GR",
         "ClassificationDescription":"Computer Hardware",
         "TaxAmount":0.000000,
         "TaxID":"",
         "TaxRate":0.000000,
         "Cost":755.010000,
         "CurrencyRateUsed":0.521000,
         "PostedToWIP":false,
         "JobCharge":0.000000,
         "UseSerialNo":false,
         "FXCost":393.360000,
         "PhysicalItem":true,
         "InventoryExpectedLiability_LedgerAccountID":"00000000O000000000C4",
         "InventoryExpectedLiability_LedgerAccountNo":"7220-000-00",
         "InventoryExpectedLiability_LedgerAccountDescription":"",
         "InventoryExpectedAsset_LedgerAccountID":"00000000O0000000009R",
         "InventoryExpectedAsset_LedgerAccountNo":"6220-000-00",
         "InventoryExpectedAsset_LedgerAccountDescription":"",
         "InventoryDeliveredAsset_LedgerAccountID":"00000000O0000000009H",
         "InventoryDeliveredAsset_LedgerAccountNo":"6200-000-00",
         "InventoryDeliveredAsset_LedgerAccountDescription":"",
         "InventoryValue_LedgerAccountID":"00000000O0000000009H",
         "InventoryValue_LedgerAccountNo":"6200-000-00",
         "InventoryValue_LedgerAccountDescription":"",
         "InventoryDeliveredLiability_LedgerAccountID":"00000000O000000000BZ",
         "InventoryDeliveredLiability_LedgerAccountNo":"7210-000-00",
         "InventoryDeliveredLiability_LedgerAccountDescription":"",
         "InventoryWIP_LedgerAccountID":"000000000A000000009T",
         "InventoryWIP_LedgerAccountNo":"6205-000-00",
         "InventoryWIP_LedgerAccountDescription":"",
         "POLineLastSavedDateTime":"\/Date(1527649009783-0000)\/",
         "OrderUnits":1.000000,
         "ItemNo":1,
         "IN_Creditor_RecID":"4017acd59177bcd3e5f6                ",
         "IN_SupplierWarehouse_RecID":"4e559e3b27b773f26d1b                ",
         "JobCostingStageID":"",
         "JobCostingStageNo":"",
         "JobCostingStageName":"",
         "JobCostingCostCentreID":"",
         "JobCostingCostCentreNo":"",
         "JobCostingCostCentreName":"",
         "JobCostingJobID":"",
         "JobCostingJobNo":"",
         "UnitIncTax":755.010000,
         "LineTotalIncTax":755.010000,
         "FXLineTotalExTax":393.360000,
         "FXDecimalPlaces":2,
         "HomeDecimalPlaces":2,
         "UseExpiryDate":false,
         "LineDetails":[ 
            { 
               "LineDetailID":"384f9cc81c054285abc0                ",
               "LinkID":"                    ",
               "Quantity":1.000000,
               "LastSavedDateTime":"\/Date(1527649047473-0000)\/",
               "SerialNo":"",
               "BinLocationID":"",
               "BinLocationDescription":"S1",
               "ExpiryDate":"\/Date(1527649046673-0000)\/"
            }
         ],
         "CustomFieldValues":[ 

         ]
      }
   ],
   "PurchaseOrders":[ 
      { 
         "PurchaseOrderReceivedID":"dc0869ef08db4c01a563",
         "OrderID":"707670751b854d90859f",
         "OrderNo":"100573",
         "OrderType":"DefaultOrderType",
         "OrderedDate":"\/Date(1527648930000-0000)\/",
         "Freight":0.000000,
         "FreightTaxAmount":0.000000,
         "Duty":0.000000,
         "DutyTaxAmount":0.000000,
         "Insurance":0.000000,
         "InsuranceTaxAmount":0.000000
      }
   ],
   "CustomFieldValues":[ 

   ]
}


Pleases advise how to update GRN Status and SlipNo via REST API.

Thanks,
Hieu
minhhieu106
Occasional Contributor
Occasional Contributor
 
Posts: 49
Joined: Thu Mar 29, 2018 3:29 pm
Topics Solved: 0

Re: GoodsReceivedNotes PATCH REST API  Topic is solved

Postby Scott.Pearce » Thu May 31, 2018 10:05 am

Don't update (PATCH) the status, use the activate route:

http://localhost/JIWAAPI/GoodsReceivedN ... 3944d59b9b
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 743
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: GoodsReceivedNotes PATCH REST API

Postby minhhieu106 » Fri Jun 01, 2018 12:45 am

Thank you Scott!
minhhieu106
Occasional Contributor
Occasional Contributor
 
Posts: 49
Joined: Thu Mar 29, 2018 3:29 pm
Topics Solved: 0


Return to REST API

Who is online

Users browsing this forum: No registered users and 4 guests

cron