Skip to Content
avatar image
Former Member

DTW PO Import Item price incorrectly set

Hi,

I am facing two issues in PO imports.

1. Lets say Item price is set to $10 in the Supplier Price List.

I want to import PO with the Price set to $5.

I set Unit Price = 5, Quantity =10 and The Purchase Order created is with Price $10 picked up from Price List i.e. Line Total = $100 instead of $50

Then I supply more information:

I additionally supply Line total to be $50

This time Unit Price =10, Price after discount = 5, Linetotal = 50. Now the line total is correct but Discount is 50% which is not correct.

2. If I can sort out above issue with your help, How can I modify PO Lines with DTW. I tried but it does not allow.

Any response would bee much appreciated.

Regards

Devinder

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 10, 2008 at 03:53 AM

    Hi Devinder,

    When your price list has $10 price but actual PO is $5, you either need to change price list or accept 50% as discount. It is not a DTW issue but how to interpret what you are trying to achieve.

    In your post, you said 50% discount is not correct, what is the reason behind it? Do you usually override PO price manually in daily process?

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Gordon,

      It actually set nothing if the price exist in price list . Neither "Price" nor "Price after discount". I had to supply "linetotal" to get the PO value right.

      Regards

  • avatar image
    Former Member
    Oct 10, 2008 at 02:43 AM

    Entering the LineTotal is not the correct way to handle this.

    Please paste the columns which have values filled from both the Header and Lines template. This will help to understand the possible causes better

    Lets say Item price is set to $10 in the Supplier Price List. Is this pricelist attached to the Business Partner (vendor)

    Please tell me if the setting In the Document Setting > General Tab ..Calculate the row total using Use Unit Price is checked

    Suda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Suda,

      Thanks for your response.

      Header fields:

      RecordKey CardCode DocCurrency DocDate DocDueDate DocNum HandWritten

      Line Fields

      RecordKey LineNum ItemCode Price Quantity WarehouseCode TaxCode

      I am using SAP 2007A Pl35 AU localization and the said field in general setting has been taken off by SAP in 2007A (to the best of my knowledge)

      Regards

  • avatar image
    Former Member
    Oct 21, 2008 at 12:56 AM

    Try using UnitPrice instead of Price.

    Add comment
    10|10000 characters needed characters exceeded