Inventory Control
- I/C Adjustment
- I/C Assembly
- I/C Bill of Materials
- I/C Contract Pricing
- I/C Customer Pricing
- I/C Internal Usage
- I/C Item
- I/C Kitting Items
- I/C Location Details
- I/C Manufacturer Number
- I/C Pricing
- I/C Receipts
- I/C Serial and Lot Number Reconciliation
- I/C Shipments
- I/C Stockcounts
- I/C Transfer
- I/C Vendor Pricing
I/C Adjustment
Views/Record Types Supported
All
Update
Insert only
Serial & Lot Tracking Support
Yes
Limitations
None
Writeback Fields
| IC0120.ADJENSEQ | Adjustment Sequence Number |
| IC0120.DOCNUM | Adjustment Number |
| IC0120.NEXTDTLNUM | Next Detail Line Number (1 is subtracted from the count to give the actual number of entries in the Adjustment) |
| IC0110.ADJENSEQ | Adjustment Detail Adjustment Sequence Number |
| IC0110.LINENO | Adjustment Detail Line Number |
| IC0110.DETAILNUM | Adjustment Detail Detail Line Number |
I/C Assembly
Views/Record Types Supported
All
Limitations
No Serial Number or Lot Tracking Support
Writeback Fields
| IC0160.ADJENSEQ | Assembly Sequence Number |
| IC0160.DOCNUM | Assembly Number |
I/C Bill of Materials
Views/Record Types Supported
All
Update
Insert only
Limitations
Does not support multi-level bill of material creation. To create multi-level bill of materials first create the child bill of materials then create parent, setting the component bill of material number.
I/C Internal Usage
Views/Record Types Supported
All
Update
Insert only
Serial & Lot Tracking Support
Yes
Limitations
None
Writeback Fields
| IC0288.SEQUENCENO | Internal Issue Sequence Number |
| IC0288.DOCNUM | Internal Issue Number |
| IC0288.NEXTDTLNUM | Next Detail Line Number (1 is subtracted from the count to give the actual number of entries in the Internal Issue) |
| IC0286.SEQUENCENO | Internal Issue Detail Adjustment Sequence Number |
| IC0286.LINENO | Internal Issue Detail Line Number |
I/C Item
Views/Record Types Supported
All
Update
Insert/Update
Limitations
None
Implementation Notes
IC0310.STOCKUNIT (Stocking Unit of Measure)
Set this field to set the default stock unit of measure if the item does not use multiple units of measure (IC0750 – Units of Measure).
I/C Kitting Items
Views/Record Types Supported
All
Update
Insert only; Updates are not supported
Limitations
None
I/C Receipts
Views/Record Types Supported
All
Update
Insert only
Serial & Lot Tracking Support
Yes
Limitations
None
Writeback Fields
| IC0590.SEQUENCENO | Receipt Header Sequence Number |
| IC0590. RECPNUMBER | Receipt Number |
| IC0590.NEXTDTLNUM | Receipt Detail Count |
| IC0580.SEQUENCNO | Receipt Detail Sequence Number |
| IC0580.LINENO | Receipt Detail Line Number |
I/C Serial and Lot Number Reconciliation
Views/Record Types Supported
All
Update
Insert only
Limitations
None
I/C Shipments
Views/Record Types Supported
All
Update
Insert only
Serial & Lot Tracking Support
Yes
Limitations
None
Writeback Fields
| IC0640.SEQUENCENO | Shipment Header Sequence Number |
| IC0640.DOCNUM | Shipment Number |
| IC0640.NEXTDTLNUM | Shipment Detail Count |
| IC0630.SEQUENCNO | Shipment Detail Sequence Number |
| IC0630.LINENO | Shipment Detail Line Number |
I/C Stockcounts
Views/Record Types Supported
All
Update
Insert/Update/Overwrite (see Implementation Notes)
Serial & Lot Tracking Support
Yes
Limitations
None
Writeback Fields
| IC0120.ADJUST_ENTRY_DOCNUM_FLD | I/C Adjustment Entry Number (the adjustment batch created when ‘Use I/C Adjustments for Serial/Lot Number Count’ is used) |
Implementation Notes
Worksheets may be either created during the import or they may be pre-created manually. When worksheets are not created during import i.e. when the existing sheets are updated with quantity, no other field except for Location needs specifying on the Inventory Worksheet view.
IC0770.SWOVERWRTEX (Overwrite Existing Sheet)
Used in conjunction with the Update operation on the Import. If an existing worksheet exists and this field is set to False an error will be generated; when set to True a new worksheet will be generated.
IC0120.LOTSERUSEADJ (Use I/C Adjustments for Serial/Lot Number Count)
When set to true alters the way serial and lot number tracked items are counted. The default behaviour of the stock count function for serial and lot tracked items, whereby the missing serial and lot numbers need to be entered into the Stock Count function. Instead when enabled this allows you to specify the counted lots and serials and missing (or found) serial and lots are entered into a separate adjustment batch; bypassing the count.
I/C Transfer
Views/Record Types Supported
All
Update
Insert/update
Serial & Lot Tracking Support
Yes
Limitations
None
Writeback Fields
| IC0740.TRANFENSEQ | Transfer Header Sequence Number |
| IC0740.DOCNUM | Transfer Number |
| IC0740.NEXTDTLNUM | Transfer Detail Count |
| IC0730.TRANFENSEQ | Transfer Detail Sequence Number |
| IC0730.LINENO | Transfer Detail Line Number |
| IC0730.DETAILNUM | Transfer Detail Number |
Implementation Notes
Transfer Transit
To create a transit transfer set the Document Type (DOCTYPE) to 2.
Transfer Receipt
To create a transit receipt set the Document Type (DOCTYPE) to 3.
To update the specific line on the transfer receipt set either the LINENO or ITEMNO fields.
The ‘Line Match Method’ (MATCHMTD) field controls which field is used to match a particular line.
|
Field ID |
Line Match Method Value |
Notes |
|---|---|---|
| Line Number (LINE) (Default) |
0 |
The value may be obtained at the time the Transit Transfer is created or via a lookup against the Transfer & associated lines. |
| Item Code |
1 |
When matching by item code ensure there are no duplicate items in the transfer. When duplicate items are present only the first item is updated. |
Updating Transfers
Open Transfers can be updated by setting the Transform Number (DOCNUM) field.
To update a line within a transfer the line must be identified or matched to the line being updated. This is achieved by setting the either the LINENUM or ITEM fields.
The ‘Line Match Method’ (MATCHMTD) field controls which field is used to match a particular line. The line matching uses the same logic as the Transfer Receipt described above.