Inventory Upload

This API adds/update Parts in the Inventory system.

WebMethod

GJZJ7J – required

Option

scan – error scan only
update – Upload Inventory/Parts
Template – Get upload template

CompanyCode

required

SubledgerCode

required

CreateCategoryCode

Create a PartsCategory code for you if needed.

default = false

errorsFound

returned result (read-only)

recordsProcessed

returned result (read-only)

pdfReport

default = false

pdfReportOut (applicable if pdfReport=true)

base64 encoded pdf (read-only)

Inventory

Field	Description
`PartNumber`	required 15 char. max
`Description`	35 char. max
`CategoryCode`	required 10 char. max
`StockingItem`	Y \| N \| A \| O \| I • Y – Yes • N – No (default) • A – Assembly • O – Obsolete • I – Inactive
`MinStock`	99999 max
`MaxStock`	99999 max
`QtyOnHand`	99999 max
`SellingPrice`	99999 max
`CostPrice`	99999 max
`BinNo`	10 char. max
`SuppliedBy`	10 char. max
`PerUnitCode`	E\|C\|M\|D\|T\|B\|Y\|F\|G\|S\|R\|L\|Q\|O\|P\|A\|K\|Z • E - Each • C - 100 • M - 1000 • D - 12 • T - Case 24 • B - Bag • Y - Yard • F - Feet • G - Gallon • S - Sq ft • R - Roll • L - Litre • Q - Quart • O • P - Pint • A - Pound • K - Kilo • Z - Meter
`DateLastOrdered`	default=today
`DateLastSold`	default=today
`Soldto`
`TypeofPart`	F\|R\|L\|Y\|N • F – Finished Good • R – Rough-in Part • L – Lab Item • Y – Returnable • N – Non-Returnable
`CostingMethod`	S\|A • S - Standard • A - Average
`Comment`	27 char. max
`AltPartNumber`	25 char. max
`SupercededPart`	25 char. max
`UPC`	999999999999 max
`UOMCode`	3 char. max
`AverageCost`	99999.999 max
`DefaultJobCostItem`	10 char. max
`DefaultJobCostType`	10 char. max
`DefaultWOCostType`	10 char. max
`PriceUpdateCode`	16 char. max
`Print1LabelPer`	999999 max
`DefaultCostTakeoff`	1\|2\|3\|4 • 1 – Std • 2 – Avg • 3 – Selling • 4 – Supl Cost
`SubCategoryCode`	10 char. max
`UsePartsCostingInTakeoff`	Use Parts Master Costing in Takeoff Charge Parts Boolean (default = false)
`PreferredSupplier`	1\|2\|3\|4\|5

SupplierCost[]

Field	Description
`Idx`	1\|2\|3\|4\|5
`SupplierCode`	10 char. max
`CostPrice`	99999.999 max
`PartNo`	30 char. max
`DiscountPercentage`	99.99

QuantityOnHand[]

Field	Description
`WarehouseCode`	5 char. max • must be a valid warehouse code
`Count`	99999.99 max

{
        "WebMethod": "GJZJ7J",
        "Option": "template",
        "CompanyCode": "01",
        "SubledgerCode": "",
        "CreateCategoryCode": false,
        "pdfReport": false,
        "Parts": [{
               "PartNumber": "",
               "Description": "",
               "CategoryCode": "",
               "StockingItem": "",
               "MinStock": 0,
               "MaxStock": 0,
               "QtyOnHand": 0,
               "SellingPrice": 0,
               "CostPrice": 99999.999,
               "BinNo": "",
               "SuppliedBy": "",
               "PerUnitCode": "",
               "DateLastOrdered": "1970-01-01T00:00:00Z",
               "DateLastSold": "1970-01-01T00:00:00Z",
               "Soldto": "",
               "TypeofPart": "",
               "CostingMethod": "",
               "Comment": "",
               "AltPartNumber": "",
               "SupercededPart": "",
               "UPC": "",
               "UOMCode": "",
               "AverageCost": -9999999.99,
               "PreferredSupplier": "",
               "DefaultJobCostItem": "",
               "DefaultJobCostType": "",
               "DefaultWOCostType": "",
               "SubCategoryCode": "",
               "PriceUpdateCode": "",
               "Print1LabelPer": 999999,
               "DefaultCostTakeoff": 4,
               "UsePartsCostingInTakeoff":false,
               "SupplierCost": [{
                      "Idx": 5,
                      "SupplierCode": "",
                      "CostPrice": 99999.99,
                      "PartNo":"",
                      "DiscountPercentage": 99.99
               }],
               "QuantityOnHand": [{
                      "WarehouseCode": "",
                      "Count": -9999999.99
               }]
        }]
}

example

{
           "WebMethod": "GJZJ7J",
           "Option": "scan",
           "CompanyCode": "01",
           "SubledgerCode": "AR",
           "Parts": [{
                  "PartNumber": "003",
                  "Description": "Dual Pressure Control",
                  "CategoryCode": "ELEC",
                  "StockingItem": "Y",
                  "MinStock": 1,
                  "MaxStock": 5,
                  "QtyOnHand": 25,
                  "SellingPrice": 120,
                  "CostPrice": 25,
                  "BinNo": "BIN9999999",
                  "SuppliedBy": "ABC03",
                  "PerUnitCode": "O",
                  "SupplierCost": [{
                          "Idx": 3,
                          "SupplierCode": "XYZ",
                          "CostPrice": 5999.999,
                          "PartNo":"XYZ-005",
                          "DiscountPercentage": 55.55
                  },
                  {
                          "Idx": 5,
                          "SupplierCode": "QWERTY",
                          "CostPrice": 3999.999,
                          "PartNo":"Q-003",
                          "DiscountPercentage": 33.33
                  }],
                  "QuantityOnHand": [{
                          "WarehouseCode": "MAIN",
                          "Count": 100
                  },
                  {
                          "WarehouseCode": "TRUCK",
                          "Count": 75
                  }]
           }]
}

result with error

{
        "errorsFound": 1,
        "WebMethod": "GJZJ7J",
        "Option": "scan",
        "pdfReport": false,
        "CompanyCode": "01",
        "SubledgerCode": "AR",
        "CreateCategoryCode": false,
        "errors": ["Category ELEC is missing"],
        "recordsProcessed": 1
}

successful result

{
        "errorsFound": 0,
        "WebMethod": "GJZJ7J",
        "Option": "scan",
        "CompanyCode": "01",
        "SubledgerCode": "AR",
        "pdfReport": false,
        "Parts": [{
               "PartNumber": "003",
               "Description": "Dual Pressure Control",
               "CategoryCode": "ELEC",
               "StockingItem": "Y",
               "MinStock": 1,
               "MaxStock": 5,
               "QtyOnHand": 25,
               "SellingPrice": 120,
               "CostPrice": 25,
               "BinNo": "BIN9999999",
               "SuppliedBy": "ABC03",
               "PerUnitCode": "O",
               "SupplierCost": [{
                      "Idx": 3,
                      "SupplierCode": "XYZ",
                      "CostPrice": 5999.999,
                      "PartNo":"XYZ-005",
                      "DiscountPercentage": 55.55
               },
               {
                      "Idx": 5,
                      "SupplierCode": "QWERTY",
                      "CostPrice": 3999.999,
                      "PartNo":"Q-003",
                      "DiscountPercentage": 33.33
               }],
               "QuantityOnHand": [{
                      "WarehouseCode": "MAIN",
                      "Count": 100
               },
               {
                      "WarehouseCode": "TRUCK",
                      "Count": 75
               }]
        }],
        "recordsProcessed": 1
}