Requisition Upload

This API adds Requisition Orders to the system.

Fields are optional unless specified; optional field nodes can be omitted from the JSON.

User security

(one of the following)

  • Purchase Order > Procurement System > Requistion Upload
  • Purchase Order > Procurement System > Requisition Processing

WebMethod

  • GJZJ25J – required

Option

  • scan – error scan only
  • update – Add Requisition Orders
  • download – Get Requisition Orders (data only, does not get attachments)
  • Template – Get upload template

CompanyCode

  • required

APSubledgerCode

  • required

ARSubledgerCode

  • required

errorsFound

  • returned result

pdfReport

  • Boolean (default = false)

pdfReportOut

  • base64 encoded PDF (read-only)

Requisitions

FieldDescription
RequisitionNumberIf blank, the next number will be assigned (max 10 characters).
Daterequired
StatusCoderequired
Descriptionrequired
RequestedBy
BuyerOptional, but must be a valid user ID.

LineItems

FieldDescription
Warehouserequired
PartNumberrequired
Quantitynumber (99999.99)
SupplierCodeoptional
AllocationTypeG | J | W | E (required)
• G – G/L
• J – Job
• W – W/O
• E – E/Q
Allocation1AllocationType = G | J | W | E (required)
• G – GLAccount
• J – JobNumber
• W – WorkOrderNumber
• E – EquipmentNumber
Allocation2AllocationType = G | J | E (required)
• G – GLDepartmentCode
• J – CostItem
• E – ComponentCode
Allocation3AllocationType = G | J | W | E (required)
• G – SubAccount (if applicable)
• J | W | E – CostType
DateRequiredrequired
DescriptionPart description for detail
Commentoptional

Template

{
  "WebMethod": "GJZJ25J",
  "Option": "scan",
  "CompanyCode": "",
  "APSubledgerCode": "",
  "ARSubledgerCode": "",
  "Requisitions": [{
    "RequisitionNumber": "",
    "Date": "1970-01-01T00:00:00Z",
    "StatusCode": "",
    "Description": "",
    "RequestedBy": "",
    "Buyer": "",
    "LineItems": [{
      "Warehouse": "",
      "PartNumber": "",
      "Quantity": 0,
      "SupplierCode": "",
      "AllocationType": "",
      "Allocation1": "",
      "Allocation2": "",
      "Allocation3": "",
      "DateRequired": "1970-01-01T00:00:00Z",
      "Description": "",
      "Comment": ""
    }]
  }]
}

Example

{
  "WebMethod": "GJZJ25J",
  "Option": "scan",
  "CompanyCode": "01",
  "APSubledgerCode": "AP",
  "ARSubledgerCode": "AR",
  "Requisitions": [{
    "RequisitionNumber": "123456",
    "Date": "1970-01-01T00:00:00Z",
    "StatusCode": "BID",
    "Description": "Test Upload",
    "LineItems": [{
      "Warehouse": "MAIN",
      "PartNumber": "123AnyPart",
      "Quantity": 25,
      "SupplierCode": "ABCSUP",
      "AllocationType": "W",
      "Allocation1": "123456",
      "Allocation2": "",
      "Allocation3": "MAT",
      "DateRequired": "1970-01-01T00:00:00Z",
      "Description": "in Line Iten",
      "Comment": "test this"
    }]
  }]
}

Result with error

{
  "WebMethod": "GJZJ25J",
  "Option": "scan",
  "CompanyCode": "01",
  "APSubledgerCode": "AP",
  "ARSubledgerCode": "AR",
  "errorsFound": 1,
  "errors": ["Allocation3"]
}

Successful result

{
  "WebMethod": "GJZJ25J",
  "Option": "update",
  "CompanyCode": "01",
  "APSubledgerCode": "AP",
  "ARSubledgerCode": "AR",
  "Requisitions": [{
    "RequisitionNumber": "000001",
    "pdfDocument": "JVBERi0xLjQNCjEgMCBvYmoNC...(base64 encoded pdf)"
  }],
  "errorsFound": 0
}