Inventory Control

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 Contract Pricing

Views/Record Types Supported

All

Update

Insert /Update

Limitations

None

I/C Customer Pricing

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None

I/C dayend

Initiates the I/C Dayend Process

Implementation Notes

PROCESS

Set True to process or False to not process Dayend.

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 Location Details

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None

I/C Manufacturer Number

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None

I/C Pricing

Views/Record Types Supported

All

Update

Insert/Update

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.

I/C Vendor Pricing

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None