Posting wrong amount after prepayment

Amaraa

Hello,

In Nav 5.0 it seems there is a bug.
In "Sales & Marketing" -> "Orders" I create an order and prepay partially or fully. Then I pay it in the journal and after that I post the order separately like "Ship" and then "Invoice". And when I go to the customer and check the amounts of the posted order it doesn't concern about any prepayment it invoices fully.

If it is fully prepaid the posted order invoices fully again and I can see the document "Open".

My project manager found a hotfix for this and it seems it doesn't work for this.
https://mbs.microsoft.com/knowledgebase ... #appliesto

Please, if there is any solution for this let me know [-o< .

Kind regards,
Amaraa

jannestig

Did you apply the fix then think it will resolve what is already wrong or did you apply the fix and recreate the same issue ?

Bug fix is usually preventive not corrective

Amaraa

jannestig wrote:

Did you apply the fix then think it will resolve what is already wrong or did you apply the fix and recreate the same issue ?

Bug fix is usually preventive not corrective

I applied the fix and again tried same case and having same result.

jannestig

Have you applied the payment with the prepayment ?

Also is “Check. Prepmt. When posting” checked on Sales & Receivable setup ?

This should stop you from posting a sales order if the system considers it unpaid

Amaraa

jannestig wrote:

Have you applied the payment with the prepayment ?

Also is “Check. Prepmt. When posting” checked on Sales & Receivable setup ?

This should stop you from posting a sales order if the system considers it unpaid

This is my other post in Dynamicsuser.net
I think it will describe what is really going wrong.

http://dynamicsuser.net/forums/p/31987/ ... spx#167786

or see this pic to know what is going on.

blue box - when I fully prepay and post with "Ship and Invoice".
red box - when I fully prepay and post with "Ship" and then "Invoice".

jannestig

What is your process for creating the invoice ?

Are you creating it seperately then using copy document functionality or doing it straight from the order after shipment

Look at step 6 i think that is your issue, try creating the invoice seperately. The manual is from "whats new in version 5"

Manual states doing the following

1. Create a sales order with a prepayment requirement.
2. Send a prepayment invoice for the prepayment amount to the
customer.
3. The customer pays the prepayment amount.
4. Apply the prepayment amount to the sales order.
5. Ship the order to the customer.
6. Create a sales invoice for the total amount of the sales order minus
the prepayment amount.
7. Receive payment from the customer and post the payment to the
sales order.

Amaraa

jannestig wrote:

What is your process for creating the invoice ?

Are you creating it seperately then using copy document functionality or doing it straight from the order after shipment

Look at step 6 i think that is your issue, try creating the invoice seperately. The manual is from "whats new in version 5"

Manual states doing the following

1. Create a sales order with a prepayment requirement.
2. Send a prepayment invoice for the prepayment amount to the
customer.
3. The customer pays the prepayment amount.
4. Apply the prepayment amount to the sales order.
5. Ship the order to the customer.
6. Create a sales invoice for the total amount of the sales order minus
the prepayment amount.
7. Receive payment from the customer and post the payment to the
sales order.

So, this means I cannot create any invoice directly from order right?
Now what I do is I don't create any invoice separately. So, there is what is going on.

And one more question is what if I fully prepaid???? :?: :?:

Thanks!
Amaraa

chengalasettyvsrao

Amaraa wrote:

So, this means I cannot create any invoice directly from order right?

No , You can create the Invoice directly from sales order also.

If you want to create the invoice form Multiple shipments , then you can use the sales invoice , otherwise directly you can directly create sales invoice .

Amaraa

sorry guys it actually didn't solve my problem.

is there anybody who has faced this issue?

jannestig

Which Version are you using 5.00 but with which localsation is it ? W1 or another type?

Prepayments existed in some other countries before v5 so which country is it as i don't think there is a mongolian release ?

The only other thing i could think of you doing is looking at the 5.1 objects are seeing where they are modified and copy them over to backup of your database and see if tha resolves the issue assuming your system hasn't been modified in some way ?