Don't get lost: IMan Guides » Sage 200 User Guide » supported-import-types » Stock Control & PriceBook

Stock Control & PriceBook

Price Book

Update

Insert & Update

Limitations

None

Writeback Fields

None

Implementation Notes

Allows you to create an update the Price Book.

Stock Adjustments

Update

Insert Only

Limitations

None

Writeback Fields

None

Implementation Note

Quantity

When set to a positive value an ‘Add Stock’ type adjustment is performed. When negative a ‘Write Off Stock’ type adjustment is performed.

Bin

When set will specify the Bin to use. When not set, will use the ‘Unspecified’ bin.

AutoGenerate Serials

When set to true will auto-select serial numbers.

AutoGenerate SerialStart

When AutoGenerateSerials is set to true this field specifies the starting number for the serial number selection.

Stock Items

Update

Insert & Update

Limitations

None

Writeback Fields

None

Implementation Notes

Supports the ability to import Warehouse, Supplier, Units of Measure and Alternative Items. Since each of these are children to the master stock record, to update these the IMan dataset must be in a similar Master Item/Child structure.

Stock Transfer

Update

Insert Only

Limitations

None

Writeback Fields

None

Implementation Notes

Quantity

When set to a positive value an ‘Add Stock’ type adjustment is performed. When negative a ‘Write Off Stock’ type adjustment is performed.

FromBin

When set will specify the From Bin to use. When not set, will use the ‘Unspecified’ bin.

ToBin

When set will specify the To Bin to use. When not set, will use the ‘Unspecified’ bin.

AutoGenerate Serials

When set to true will auto-generate or auto-select serial numbers depending on whether an adjustment is inwards or outwards.

AutoGenerate SerialStart

When AutoGenerateSerials is set to true and the adjustment type is inward this field specifies the starting number for the serial number generation.