SALES INVOICE PLD

[Former Member]

SAP Gurus,

In my Scenario at One of Our Warehouse there are two types of Invoices

1) TAX Invoice

2) Retail Invoice

We have hard coded 'TAX Invoice' and 'RETAIL Invoice' on two seprate PLD Layouts.

I have assigned PLD's  by default to BP as per requirement

But There are Several Customers who are taking Retail as well as as Tax Invoice.

can this problem been sorted out. I don't Want to create duplicate Customers for This.

Thanks,

Anirudh

[Former Member · Accepted solution]

Hi Anirudh,

This i have done through workaround.

Follow the steps accordingly & let me know.

1) Create One UDF in Marketing Documents Title

in Field Data Type Title Sal_Type

2) In Description Type Sales Invoice Type

3) Check on Valid Value for Field On Left Side Click New type Value as 1 and Description as TAX INVOICE

     Again Click on New & Type Value as 2 and description as RETAIL INVOICE

Update the UDF and Add it.

4)Now Open Your PLD which is hard coded Click on SAVE AS Print Layout Designer and save it with some other name. e.g. Invoice

5) Now open newly saved Invoice go to field which is hard coded.

6) Change the Source Type of Field in Content Tab to DATABASE

7) In Table Select OINV from drop down list.

😎 In The Column Selct Your UDF Which is Sales Invoice Type

9) Save this PLD and set as by default to one of Your BP

10) Now open invoice for particular BP and in UDF Side Select the Invoice Type as required from drop down and update the invoice.

Now Check the PLD Format it will pick the values from UDF.

But your users have to select Invoice type in UDF.

Hope This Help.

Thanks,

Regards,

Sudhir Sharma

[Former Member · Accepted solution]

Hello Sudhir,

Thank You Very Much it resolves the issue.

Just a little issue i want i selecting this UDF for all users are mandatory

can you provide me the code for this?

Thanks,

Anirudh.

[Former Member]

Hi Anirudh,

Please provide me the name of Your UDF.

Thanks,

Regards,

Sudhir

[Former Member]

Hi,

It is U_Sal_Type

Thanks,

Anirudh

[Former Member]

Hello Anirudh,

Do You also want to restrict user to update previous Invoices.

Please let me know.

Thanks,

Regards,

Sudhir Sharma

[Former Member]

Yes Sir It will be very helpful

[Former Member]

Hi Anirudh,

Use this SP

-------SALES TYPE MANDATORY IN SALES INVOICE

if @object_type='13' and (@transaction_type='A' or @transaction_type='U')

begin

if exists(select docentry from OINV where (U_Sal_Type is null or U_Sal_Type='') and docentry=@list_of_cols_val_tab_del)

begin

select @error=1, @error_message='Please select Sales Type'

end

end

Please change the Error Message typed in Red Font As per your convinience.

Hope this Help!

Thanks,

Regards,

Sudhir Sharma

[Former Member]

Sir,

This code is not working.

Anirudh

[Former Member]

Hi,

It's Working for me just check and let me know or give me your Teamviewer Id.

I can check it for you.

Regards,

Sudhir

[Former Member]

Hello Sir,

Its Working now i am doing mistake in copying the code.

Thanks For Your Valuable efforts.

Anirudh

[Former Member]

Hi Anirudh,

Not Possible to do two PLD Default to one Customer.

You need to Print Manually for the Second PLD. Make Default One PLD to Customer and for Second PLD you need to Print Manually.

Or Else create another Customer.

1. One for Tax Invoice Customer

2. Second one for Retail Invoice Customer

Then you can do PLD Default according to Customer Name but for one Customer you can do only one PLD Default.

Hope this help

--

--

Regards::::

Atul Chakraborty

[Former Member]

Hi, Atul,

Please try the Work around.

Thanks,

Regards,

Sudhir

[Former Member]

Hi

My suggestion is to assign this BP to one of the PLD layouts

add UDF to invoice as invoice type retail or tax

when you create invoice you need to select the type of invoice and the header will be according to this field

hope it help you

shachar