Adjustments

Driver Name - Dear Inventory Stock Adjustment

This works by only changing the On Hand quantity using availabilities. This does not support reason codes (as they are not used in the logic).

Uses the ULDLogEntryXML payload.

This will hit the StockAdjustment with a simple payload:

Cin7 field	Inventory delta field
EffectiveDate	DateTime
Status	Hardcoded to COMPLETED
UpdateOnHand	Hardcoded to TRUE
Lines/ProductID	ProductID from lookup of ItemCode
Lines/Quantity	Current On Hand plus Delta
Lines/UnitCost	UnitCost from lookup of ItemCode
Lines/Location	WarehouseCode

There are no settings for this connection.

Driver Name - Dear Inventory Advanced Stock Adjustment

This works by entering a proper ledger to register the adjustment and reason codes can be mapped to specific accounts in DEAR. This type of adjustment is more suitable for larger organisations, as it has proper mapping for reason codes and adjustment accounts.

Uses the ULDLogEntryXML payload.

This will hit the StockAdjustment with a simple payload:

Cin7 field	Inventory delta field
EffectiveDate	DateTime
Status	Hardcoded to COMPLETED
Account	Mapped using Dear.Adjustments.ReasonCodeToAccount
Reference	Comment (all after the ; on AdditionalInfo)
UpdateOnHand	Hardcoded to TRUE
Lines/SKU	ItemCode
Lines/Quantity	Current On Hand plus Delta
Lines/UnitCost	UnitCost from lookup of ItemCode
Lines/Location	WarehouseCode