Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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.

    Add comment
    10|10000 characters needed characters exceeded