Item Prices in the oInventroyGenEntry DTW

[Former Member]

Hello,

I am trying to make an Entry with the DTW, In the DocumentLines template there is a field named "Price" , but this price is ignored when i import the document.

Is it possible to set the prices via DTW?

Thanks

Jacobo

[Former Member · Accepted solution]

Hi Jacobo

In DTW after you have browsed for your template files, on the next step you can map. Click on the detail file on the left, then go down to the price field and in the second column "Target Fields (B1)" remap to UnitPrice and not Price.

Kind regards

Peter Juby

[Former Member]

Dear Jacobo,

In order to enter initial stock quantities via DTW, the stock taking template must

be used to specify the total amount of items counted in the Warehouse.

After this information has been entered, the process must be completed

manually via the Business One client using the Stock posting option

under 'Initial quantities, Stock taking and Stock posting' window.

Note : This process is not valid if the items are managed by Serial/Batch.

In order to do that please follow note 841270.

Regards,

Rakesh Pati

SAP Business One Forum Team

[Former Member]

Some previous threads discussed this topic already. You may have to DTW twice. One for quantity, one for price.

Thanks,

Gordon

[Former Member]

Hello Gordon

How i can do the DTW twice?

Thanks

Jacobo

[Former Member]

One is by oInventroyGenEntry, another is by oMaterialRevaluation.

[Former Member]

Hello Gordon

if i do it like that i dont get update the last purchase price, is there any chance to updated?

Thanks

Jacobo

[former_member583013]

Jacobo,

Thats why I suggested you to use oStockTaking DTW template to import the quantities first.

After that Import the Cost of these items using the Items_Prices template found inside the oItems DTW folder.

Once the costs are in, you will use to Initial quantites, ..... and go to Stock Posting tab

Select By Price list in the Price Source for Whse Stock Posting

Select your pricelist where you imported the cost

Refer this thread

[Former Member]

To set price by DTW, you need another template. Try using oMaterialRevaluation object of DTW

Thanks,

Gordon

[Former Member]

Thanks Gordon

I want to upload for the first time my inventory opening balances with prices, do you have any other ideas?

Thanks

Jacobo

[former_member583013]

Are these Items Serial / Batch managed? If not you can use either the stock taking template found inside DTW folder oStockTaking and import the cost into a Pricelist and reconcile using the pricelist

OR

Import these as a Goods Receipt

Let me know

Suda

[Former Member]

The items are not serial or batch managed.

I prefer to use the DTW, because i have 12,000 items and 56 warehouses.

Is the opening balance for the inventory.

Thank you very much

Jacobo