cancel
Showing results for 
Search instead for 
Did you mean: 

Initial Stock Taking template for Items with Batch Management

Former Member
0 Kudos

I need to upload the Items for the initial Stock Taking but every item uses Batch Management. and i dont see another template. What template is the best for the initial Stock?

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

Hector,

You will use the templates in oInventoryGenEntry folder.

The templates you will need are

Documents.xlt

Document_Lines.xlt

BatchNumbers.xlt

Documents template sample

RecordKey...DocDate......... DocDueDate

1.................20080106...... 20080106

Document Lines template sample

RecordKey....LineNum.. AccountCode....... ItemCode..... Price...... Quantity......WarehouseCode

1.................. 0........ _SYS00000000xxx...... A1......... 100.00....... 20................. 01

1.................. 1........ _SYS00000000xxx...... B2.......... 180.00...... 30................. 01

Batch Numbers template sample

RecordKey.... BaseLineNumber..... BatchNumber.... Quantity

1.................... 0...................... 100..................10

1.................... 0...................... 101..................10

1.................... 1...................... 400..................15

1.................... 1...................... 401..................10

1.................... 1...................... 402...................5

The link is between the BaseLineNumber from the Batch template and LineNum from the Document Lines template. Please try this and it shoud work.

Best wishes

Suda

Answers (1)

Answers (1)

former_member186095
Active Contributor
0 Kudos

If you want to upload opening balance for inventory, you can use good receipt template. it's available in this folder:

C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oInventoryGenEntry

you could also find the method how to upload it in the SAP note file # 814215 and 864113

Rgds,