Skip to Content
0

How to download inventory with serial number using DTW (inventory posting template - OIQR)

Nov 09, 2017 at 06:57 AM

52

avatar image
Former Member

Dear

I have to down the quantity of all inventory item to zero.

So i have used DTW with Inventory posting template to down the stock.

This template is working on Item which is not having "Item manage by serial number" property.

But It is not work on item which has "Item manage by serial number" property.

It require serial number detail.

Please tell me how to use this Inventory posting Template

I am using this template as

1) OIQR - InventoryPosting

DocumentEntry DocumentNumber Series PostingDate CountDate CountTime Remarks JournalRemark

646 646 1735 20171102 20171102 12:00 STOCK (SrNo) DOWN FOR MGMT ACCOUNTING STKUP/DN 2017-18/34

2)IQR1 - InventoryPostingLines

ParentKey LineNum LineNumber ItemCode WarehouseCode InWarehouseQuantity CountedQuantity Price Total InventoryOffsetIncreaseAccount InventoryOffsetDecreaseAccount BaseType BaseEntry BaseLine BaseReference DocumentEntry LineNum LineNumber ItemCode WarehouseCode InWarehouseQuantity CountedQuantity Price Total InventoryOffsetIncreaseAccount InventoryOffsetDecreaseAccount

646 0 1 106658010 FGMF 1 0 ######## 29028 _SYS00000007644 _SYS00000007644

3)IQR3 - InventoryPostingSerialNumbers

DocumentEntry BaseLineNumber ManufacturerSerialNumber InternalSerialNumber SystemSerialNumber Quantity

646 1 Z01688B12 A05283F12 1 1

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Nov 12, 2017 at 04:20 AM
0

While posting the serial number stock and set counted quantity to zero,

we get the following error

1Created Failed DocumentEntryCannot add row without complete selection of batch/serial numbers65171

Please give details, Which data required in stock posting template to down the stock.

Share
10 |10000 characters needed characters left characters exceeded