Updating PCH4 table by UDF-FMS-DTW

[Former Member]

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.

[zal_parchem2]

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.

[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.

[Former Member]

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

[Former Member]

Gordon,

Any idea for Proper settings.

[former_member206437]

Hi

In Opurchase Invocie Template - Document Line if u include the Taxcode as per SAP system Taxcode , system will calculate the tax as per that for that document .. This is common practice , while uplaoding the Pucchase invoice have Tax..

First check in Test DB with Tax code...

Giri

[senthil_m]

Why your customer wants to update tax amount?

Please give us the brief info of your requirement.

Regards,

Senthil Maruthappan.