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 onlyupdate– Add Requisition Ordersdownload– 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
| Field | Description |
|---|---|
RequisitionNumber | If blank, the next number will be assigned (max 10 characters). |
Date | required |
StatusCode | required |
Description | required |
RequestedBy | |
Buyer | Optional, but must be a valid user ID. |
LineItems
| Field | Description |
|---|---|
Warehouse | required |
PartNumber | required |
Quantity | number (99999.99) |
SupplierCode | optional |
AllocationType | G | J | W | E (required) • G – G/L • J – Job • W – W/O • E – E/Q |
Allocation1 | AllocationType = G | J | W | E (required)• G – GLAccount • J – JobNumber • W – WorkOrderNumber • E – EquipmentNumber |
Allocation2 | AllocationType = G | J | E (required)• G – GLDepartmentCode • J – CostItem • E – ComponentCode |
Allocation3 | AllocationType = G | J | W | E (required)• G – SubAccount (if applicable) • J | W | E – CostType |
DateRequired | required |
Description | Part description for detail |
Comment | optional |
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
}