on 07-09-2014 1:01 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anirudh,
Please provide me the name of Your UDF.
Thanks,
Regards,
Sudhir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.