cancel
Showing results for 
Search instead for 
Did you mean: 

Advance payment without reference to a sales order

former_member504446
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member209761
Active Contributor
0 Kudos

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

former_member504446
Participant
0 Kudos

Dear Hegal,

thank you a lot for your input. So I guess there is no way to do this without programming? Oh well...

Cheers

Alicia

former_member209761
Active Contributor
0 Kudos

Dear Alicia,

Let us wait for some expert opinion on this.

If no one is able to suggest a standard process, you can go forward with the customization, which will work for sure.

Thanks & Regards,

Hegal K Charles

Lakshmipathi
Active Contributor
0 Kudos

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

former_member504446
Participant
0 Kudos

Dear G. Lakshmipathi,


thank you for your answer but it is not our problem to post the advance apyment in FI. The question was how to substract that payment from my SD invoice.


Cheers

Alicia

Answers (1)

Answers (1)

Lakshmipathi
Active Contributor
0 Kudos

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