on 08-27-2014 10:07 AM
Hi,
My requirement is this:
I have created a variant in VF04 to run the billing due list. I have created a background job that runs everyday and creates the invoices. The output condition record (RD00) has been set to date and time = 4(print immediately). The result is that invoices are printed automatically after they are created. I want the invoices to be printed in the alphabetical order of the name of the sold to party/payer (meaning if there are 20 invoices to be printed, forst print 5 invoices of customer A, then 5 of customer B, then 5 of customer C and 5 of customer D). Currently they are printed as VF04 selects them in a random manner.
I have tried the following 2 solutions:
1. Through VF31
a) In the condition records for RD00, set date and time to 3 (set to application own transaction).
b) In the definition of RD00, in the tab sort order, select field Sold to Party
c) Create a variant for VF31 with sort order as 04 (sort fields 1-3) to select the invoices created by VF04
d) Create a background job to run immediately after the job to create invoices has finished.
The above method creates invoices in the ascending order of the sold to party number, not name.
How can you add the field Name of sold to party to the field catalog?
2. Create a display variant for VF04
a) I ran VF04 and sorted the name of the sold to party. I couldn't save it as a display variant.
b) I went to transaction VOF1, but I saw that this is to add/remove fields to the standard display variant. I cannot add a sort to the name of the sold to party
So, again, is there a way to create a display variant for VF04 with the field "Name of sold to party" sorted in ascending order?
I have created a variant in VF04 to run the billing due list. I have created a background job that runs everyday and creates the invoices
Can you reconfirm your above statement is correct? For information, you cannot execute VF04 in background.
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Based on your initial post, I thought, you were executing the transaction code VF04 instead of executing via program. Nevertheless, coming to your comment on
I couldn't save it as a display variant
you can't save any variant in VF04. However, do the following:-
Go to SU3, select "Parameters" tab where you set Parameter ID as
G. Lakshmipathi
I have sorted the VF04 results by the name of the sold to party and have saved it as a display variant. I have set it as the default display variant. However, when creating invoices and printing them, it is not doing it in the order in which VF04 is displayed.
I am able to save selection screen variants by default i.e the standard behavior of SAP allows the user to save a selection screen variant
I think option 1 of using VF31 is the right approach. I have to find a way to include the name of the sold to party in the field catalog for sort order and assign it to RD00.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
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.