Sales Invoice

Business Central/NAV User Forum
1

hi experts,

does any has idea on sales invoice can be billed in equal installments?

can anyone has the solutions for this?

for eg. sales invoice has raised to xxxx customer for amount1200 can we able to split this amount into 12 months installment like 1st month 100…2nd month 100… without any manual adjustments…

thanks in advance

2

Hi,

What version are you using?

If Version 5 - have you looked at producing a proforma invoice and using the pre-payment function. If you post the full invoice then there is tax issues.

3

hi dave,

we are currently using 4.0 sp3 & this is going to be a post payment by month over month not a prepayment.

thanks

4

Hi,

Have you considered setting up a recurring journal for this with one line a payment for the customer and the second line a payment to the bank ?

5

hi

i dont have any idea on how to do this entry. if you have any idea please let me know to do…

Thanks & Regards

6

Go to periodic in general ledger and receiveables. In there is a recurring journal. You set the first line to type customer and define the customer, set the second line to bank and the bank account the payment goes into.

7

… As Adam says and use recurring method fixed, recurring frequency 1M and set the expiration date as not to post after the invoice is paid.

8

thanks dave & Adam

but if we do this how the customer aging report will come? & how the revenue is going to record in g/l for every month or sold month?

once the sales invoice is raised to customer if you invoice it then the revenue will automatically records as per posting setup & customer ledger entry also will get update so in this case if you do the same in recurring journal you are going to duplicating the entries. & what about the intrest calculation for customers whoever agreed to pay in installmets ? how these accounts needs to be set?

regards

9

There is no duplication as the journal represents teh payment and the invoice the sale.

Interest can be another recurring journal.

I suggest you start trying to configure this in NAV and seeing where it does not work, otherwise this will carry on and on with you adding questions without the first part being defined as working for you.

Are you an end user? I would suggest you talk to your partner and discuss the requirement in detail.

10

hi Adam

thanks for your suggestion, i do agree with you that we can able to do in recurring journal but is there any automation, since if we do manual intrest calculation it may take longer time.

i’m consultant

regards

11

No there is no automation of easy way to do this which is why Dave and I have suggested potential avenues to investigate prior to you developing a solution