on 06-25-2015 12:35 PM
Dear gurus,
we have a customer who does several orders each month, but we only create only one invoice at the end of the month for all orders. This works fine.
For various reasons we would like to have that customer pay us a fixed amount in advance on each 15th of a month, let’s say 50.000$.
Now, we would like to subtract those 50.000$ in our monthly invoice, e.g.:
INVOICE
Item 1, order 1 10.000$
Item 2, order 1 20.000$
Item 1, order 2 15.000$
Item 1, order 3 30.000$
--------------------------------------------
Sum 75.000$
Advance payment -50.000$
--------------------------------------------
Amount to pay 25.000$
Is this possible in SD?
Cheers
Alicia
Dear Alicia,
Follow logic may work for your scenario.
Since customer is making payment of 50000 in advance, do FB75 for this amount. This will be done by Finance Team.
You will get a document no for this transaction.
Enter this Receipt document no along with the transaction month and amount in a Z-Table.
You are creating multiple order which will have a condition type for net price.
You have to write a routine for alt.condition base value, such that if the transaction is VF01 or VF04, then net amount should be calculated as SUM of all NET values of all preceding orders for the document -(minus) the amount against the receipt no / processing month.
The receipt no has to be feeded into the delivery or billing document header (you may have to use a new Z field).
In this way, when the invoice is saved, system idetifies that the event is Billing and then it will check the receipt no entered in the Z field and also the amount received.
The it will check in VBFA for all preceding documents with type O and do the summation of the condition value for net price. From this amount, the receipt amount will be subtracted and this value will flow to the condition type for net value in the invoice for which you can receive the payment.
Thanks & Regards,
Hegal K Charles
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As and when you raise an invoice in SD, there will be some value posted in FI which would be either a debit entry or a credit entry. Having said this, as I said already, you should have discussed with your FI consultants who can meet your requirements. Before going for any enhancement, discuss with your Finance consultants.
G. Lakshmipathi
This requirement is not related to SD but related to FI. Discuss with your FI team who can give you a solution. Provision is there from FI side to address this requirement.
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
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.