Calculation for multiple prepayments is wrong?

julkifli33

hi all,
i have case which 1 sales order have 3 prepayment
sales order amount is $100
let say :
prepayment 1 : 10%
prepayment 2 : 40%
prepayment 3 : 80%

the calculation is
prepayment 1 : 10% * $100 = $10
prepayment 2 : 40% * $100 = $40
prepayment 3 : 80% * $100 = $80
after we post these 3 prepayments, it will produced 3 invoices that have amount : $10,$40,$80 (10+40+80 = 130 --> it already exceed the sales order amount itself which is 100)

how if we dont want to use YTD Amount?
so the calculation should be like this
prepayment 1 : 10% * $100 = $10
prepayment 2 : 40% * $100 = $30 ($40 - $10)
prepayment 3 : 80% * $100 = $30 ($80 - $40 -$10)
total prepayment = $10 + $30 + $30 = $70

any hotfix for this matter?

FDickschat

The calculation is not wrong, it is simply doing what it is designed to do.
Also there is no hotfix necessary, simply post prepayment invoices with 10%, 30% and 30%

julkifli33

FDickschat wrote:

The calculation is not wrong, it is simply doing what it is designed to do.
Also there is no hotfix necessary, simply post prepayment invoices with 10%, 30% and 30%

how come is not wrong?
my sales order $100
and these 3 prepayments already $10 + $40 + $80 = $130
this amount exceed sales order amount itself

chengalasettyvsrao

what about your NAV Version and Localization ?

julkifli33

chengalasettyvsrao wrote:

what about your NAV Version and Localization ?

my NAV version --> SG Dynamics NAV 6.0 R2
application build 32012

FDickschat

julkifli33 wrote:

FDickschat wrote:

The calculation is not wrong, it is simply doing what it is designed to do.
Also there is no hotfix necessary, simply post prepayment invoices with 10%, 30% and 30%

how come is not wrong?
my sales order $100
and these 3 prepayments already $10 + $40 + $80 = $130
this amount exceed sales order amount itself

As I wrote, do not post prepayments with 10%, 40% and 80% but with the differences between the steps:
Step 1: 10%
Step 2: 40% - Step 1 (10%) = 30%
Step 3: 80% - Step 1 (10%) - Step 2 (40%) = 30%

This is not a bug, it is a feature

chengalasettyvsrao

what Frank says true . System will not allow to post the prepayment invoices more than the sales order amount.

julkifli33

FDickschat wrote:

julkifli33 wrote:

FDickschat wrote:

The calculation is not wrong, it is simply doing what it is designed to do.
Also there is no hotfix necessary, simply post prepayment invoices with 10%, 30% and 30%

how come is not wrong?
my sales order $100
and these 3 prepayments already $10 + $40 + $80 = $130
this amount exceed sales order amount itself

As I wrote, do not post prepayments with 10%, 40% and 80% but with the differences between the steps:
Step 1: 10%
Step 2: 40% - Step 1 (10%) = 30%
Step 3: 80% - Step 1 (10%) - Step 2 (40%) = 30%

This is not a bug, it is a feature

PREPAYMENT 10% - 40 % - 80% is okay
try 20% - 60% - 70%
i think it should be like NAV 5 SP 1
the calculation is correct

julkifli33

chengalasettyvsrao wrote:

what Frank says true . System will not allow to post the prepayment invoices more than the sales order amount.

that's what i wanted....
but NAV 2009 R2 allow prepayment exceed sales order amount

julkifli33

if we do like FDickschat said,
it should create prepayment 1 < prepayment 2 < prepayment 3
we cant do prepayment = 50%, prepayment 2 = 40%
am i correct?

chengalasettyvsrao

I replicated the Prepayment Scenerio in NAV IN 6.0 R2 32012. Tried sales prepayment invoices with different combinations , when i try to enter the Prepayment % more than 100 % system throws the following error

---

Microsoft Dynamics NAV Classic

---

The maximum permitted value is 100.

---

OK

---

The transactions which you are replicating is it Standard Database or Customized Data base ?

julkifli33

chengalasettyvsrao wrote:

I replicated the Prepayment Scenerio in NAV IN 6.0 R2 32012. Tried sales prepayment invoices with different combinations , when i try to enter the Prepayment % more than 100 % system throws the following error

---

Microsoft Dynamics NAV Classic

---

The maximum permitted value is 100.

---

OK

---

The transactions which you are replicating is it Standard Database or Customized Data base ?

i'm using the standard nav database
your database is VAT or GST?

ssingla

IN database is VAT (not global VAT but Indian customized VAT).
Further I recreated the scenario in default IN 2009 R2 database and have found that it complies with your original requirement i.e.
1st Prepayment : 50 %
2nd Prepayment : 70% (70-50 = 20%)
3rd Prepayment : 80% (80-70= 10%).

It neither allowed me to exceed 100% on sales header (Prepayment Tab) nor on Statistics Form (Prepayment Tab).

Either there is some customization or there is bug in the database. In the case of latter you better raise a MS support issue and wait for their reply.

julkifli33

i think this is because localization problem
i use nav 2009, W1 version
the calculation for prepayments is okay

i send to microsoft but they do not reply until now

julkifli33

NOW i compare NAV 2009 R2 W1 and NAV 2009 R2 SG
even NAV 2009 R2 W1 has correct multiple prepayment
what happened with NAV 2009 R2 SG ???

chengalasettyvsrao

julkifli33 wrote:

what happened with NAV 2009 R2 SG ???

It's a :bug:

julkifli33

chengalasettyvsrao wrote:

julkifli33 wrote:

what happened with NAV 2009 R2 SG ???

It's a :bug:

yes it is...
it's because GST prepayment addition on general ledger setup
:thumbsdown: :thumbsdown: :thumbsdown:

szh

hi all,

I also encountered same issue as you in version 2009R2 SG version. Could you please advice how to resolve this issue?

Thanks a lot.

Best Regards
SZH