on 08-26-2008 10:08 AM
Hi All,
i am using SAPB12005, wants to import stock of items through DTW,which templete should use for that.
mahesh
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
'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.
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
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.
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?.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.