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

Updating PCH4 table by UDF-FMS-DTW

Hi Experts,

Iam using SAP 2007B PL-15 ,one of the client requirement is to update Tax Amount(LC) in A/P invoice by DTW.as i observed there is no any tax amount (LC) column in OPurchase invoice template.so m doing it by crating a UDF and assign UDF in Opurchase invoice template but i want to update UDF in A/P invoice and also update PCH4 table i.e Tax Amount(LC) in A/p.any one have idea m trying for it.

Sudhir Pawar.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2009 at 04:50 PM

    Hi Sudhir Pawar,

    I don't think you could update tax info directly for system fields. You may achieve your goal through proper settings and let system to calculate tax total.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 31, 2009 at 04:04 PM

    hello Sudhir...a few points of clarification for you...

    1. there is a field of OPCH.VatSum where the taxes are stored after the SAP B1 system has calculated the tax.

    2. the proper settings are found on the Business Partner Master Data window. Path of Business Partners > Business Partner Master Data > Accounting tab > Tax tab > setting of "Liable". Of course you have to have the tax codes and rates already set up under Administration.

    3. when you say a requirement to update taxes - do you mean on past documents or documents that are going to be created in the future??? I think that is a little bit unclear, so please clarify...

    Take care and hope this helps

    Zal Parchem

    PS - in case you would like to research further on your own, try vendor V23000 with product number B10000 in your OEC demo database - the Purchase Order (OPOR table) creates the tax correctly for that vendor.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Thanks for reply, iam aware of the taxes are stored in OPCH.vatsum in SAP B1, system has calculated the tax but our client want to change the tax amount after system calculate tax and its possible in system to change tax amount but in case of 1000 documents i turn to DTW by using one UDF at header level and try to use FMS by updating tax amount(LC) column by UDF value.

      Client require such updations coz Vendor not giving proper tax invoice e.g VAT 12.5 Vendor give them 13.so client has to adjust in tax amount column by 13 for setoff purpose for client and also Tax amount cloumn not in DTW template of Opurchase order.This requirement is for future documents.

      Regards

      Sudhir Pawar.

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.