cancel
Showing results for 
Search instead for 
Did you mean: 

wants put stock opening balance through DTW

Former Member
0 Kudos

Hi All,

i am using SAPB12005, wants to import stock of items through DTW,which templete should use for that.

mahesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Loading of the initial quantities for all items is using the Stock Taking object in the DTW.

You can find the template, 'StockTaking.xlt' in the following folder of the Server

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

Former Member
0 Kudos

Dear Sir,

In stock taking there is no price , we want to take that also.how can we do?

mahesh

Former Member
0 Kudos

hi sir,

that is possible through inventory general entry,DTW templete.where you will get price also.

mahesh

Former Member
0 Kudos

'oInventoryGenEntry' is for Goods Receipt. Using this template will affect the 'RG23A Part I No.,

RG23C Part I No.' which are Excise Register Numbers.

use ''StockTaking.xlt" to load the Opening Balances.

After importing this template to SAP B1 through DTW, open the 'Inventory -> Inventory Transactions -> Initial Quantities, Inventory Tracking and Stock Posting -> Stock Posting Tab'

From the 'Price Source for Whse Stock Posting' dropdown choose the option 'by pricelist' now the 'pricelist' dropdown will appear, choose the appropriate pricelist and choose 'OK.

From the 'Stock Posting' window, Set the 'Inventory Offset - Increase Account' and 'Inventory Offset - Decrease Account'.

Hope you have understood.

former_member583013
Active Contributor
0 Kudos

Mahesh,

You could import the inventory counts using the Stock Taking template and the prices can be imported along with the Items using the template Items_Prices (inside folder oItems)

In the Inventory Reconciliation Tab select the pricelist number you have imported the prices (cost) in the above step and RECONCILE

Former Member
0 Kudos

Hi Shridharan,

I agrred with u.....but..

Actualy there is no any excisable item, we are using VAT1% and CST1% means in whole project excise is not comming.that why RG23 regi also not come in picture. In this case if i import as earlier said through inventory gen entry ..is it ok?

Former Member
0 Kudos

The SAP document, 'Data Migration and Opening Balances Implementation Guide.pdf' states the following:

Page No: 14:

Load Inventory Beginning Balances via DTW

In the workbench, the process contains 2 stages:

1. Loading of the initial quantities for all items using the Stock Taking object in the DTW.

2. Perform Stock Posting manually using Inventory u2192 Inventory Transactions u2192 Beginning Quantities and Cycle Counting u2192 Stock Posting. This stage will create the stock transaction and the appropriate Journal Entry to reflect the stock value in the GL.

In the stock posting, the same rules apply for determination of the item cost prices as in manual process.

The quantities you loaded will appear as counted. For the beginning quantities, the difference should be zero.

Make sure the date is set for the day you go live.

o The increasing and decreasing accounts are defaulted from the G/L account determination. For the beginning balances only, you should overwrite these accounts with the opening balance account.

o If you donu2019t use the Continuous Stock System, only quantity transactions will be created, no journal entries.

Since the stock accounts are affected, you must consider these amounts when creating the G/L opening balances.

If a variance remains after reconciliation between SAP Business One and the legacy system, for example, due to different prices, you have to correct this difference manually.

It is recommended practice to follow documents of SAP.

Finally it is upto you to decide which is the best way to do.

Former Member
0 Kudos

Sridharan T,

Hi I read this thread about loading stock to SAP for the first time, we want to load the stock in a drugstore implementation, since these items(meds) have batches and the DTW can only load batches and serials through a stock transactions, can I expected the same result by loading the stock from a goods receipt with the batches?

What procedure can you recommend me to follow in this case?.

Answers (0)