A question about pricelist templates

[Former Member]

It's a problem about DTW templates.

I want to transfer pricelists into Sap Business One,and I have found a template in this path:

C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oPriceLists\PriceLists.xlt

This is the only template.

Where can I find the pricelists-template about ItemNO.&baseprice.

Waiting for an answer.

Thank you!

E-mail: Daniel.D.H@gmail.com

[former_member186095 · Accepted solution]

Dani,

here is the correct address :

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

let me know if you find difficult to use it

Rgds,

[former_member583013 · Accepted solution]

Jimmy,

Daniel knows where the DTW template folders are? Why are wasting your time desperately?

Suda

[Former Member]

Question's answered

[Former Member]

Thanks,Suda&Jimmy.

[former_member583013]

Did you get what you were looking for?

If your question is answered please mark it as answered.

Suda

[former_member583013]

Item Prices can be imported using Items_Prices template inside DTW folder oItems

[Former Member]

Thanks for reply.

I think we have a mistake.

The data I want to transfer is priceslist.It contains Price List Name,Base Price List,Factor,Rounding Method. And I can find all this fields in this template:

C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oPriceLists\PriceLists.xlt

And the Pricelist also contains fields BasePrice,Price.

The problem is that I can't find a template about BasicPrice.

The template you told is in this path:

C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oItems\Items_Prices.xlt

Are you sure this is the templates I should use?

E-mail:Daniel.D.H@gmail.com

MSN:xFlower007@hotmail.com

Edited by: Daniel Huang on Dec 23, 2007 5:07 AM

Edited by: Daniel Huang on Dec 23, 2007 5:10 AM

[former_member583013]

Are you trying to import Pricelist or a Price?

If you want to import Price for Basic Pricelist, then you the template I mentioned earlier (Items_Prices)

Suda

[former_member186095]

Hello,

I will send you the Items_Prices template along with basic price. you can check it and compare with yours if it is failed to import the basic price.

Rgds,