Skip to Content
author's profile photo Former Member
Former Member

Price lists

Good morning.

I have a question: I buy my items in US dollars. My currency is Euro. I created a sale price list based on last purchase price. Can I have my sale price list in euro?

Which documents update last purchase price? When?

Thanks for your answers!

Alberto Malacarne

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 07, 2009 at 10:06 AM

    Hi!

    You can have the Price List in EURO,

    Open the PriceList and Item, Type EUR followed by your price.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 07, 2009 at 02:52 PM

    You may check this wiki page for how last purchase price is updated:

    https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=36438427

    If you base your price list on last purchase price directly, the currency would be a big problem unless you only use one currency for all your AP Invoices (I don't think that is normal).

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 10, 2009 at 02:53 PM

    Alberto,

    Your local currency is probably in Euro and you buy in USD. So when buying, you have to enter the exchange rate for the dollar for the day.

    The price list shows USD and so is the unit price on the sales documemnt, but the document line total and document total are in euro, and so is the ageing for the customer if he is euro based, also the document printout. So I don't catch why you need the sales price list in euro? Can you explain it to me please?

    Kind regards,

    Frederic

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2009 at 03:34 AM

    Hi,

    Besides using DTW, you can also using utility tools embed in SAP application program.

    a)Go -> Administration -> Data import/Export -> date import -> import from excel

    b)Select data type to import to 'item'

    c)You must have excel column for item no, price list code,price according to price list, price list price currency.

    d) All the above column can select from the list

    e) The item no is compulsory; price list code = 1(if u wanted update price list 1 in standard b1), price according to price list=

    price amount based on currency, price list price currency = currency code(example :EURO)

    f) Check the bottom option checkbox 'update existing records'

    system will update the record and price accordingly based on specific item number

    Regards,

    Eric

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.