Sales Invoice Report

brijeshvaidya

In the sales invoice report, i have to show the two amount data,

1)amount due now and

2)amount due on 20-august-2010(or on specific date),

Scenario 1:

Final amount =$150

Payment:$50
Balance due:$100

to show amount due now or today(when report prints) (e.g. =balance due * 0.3)

and amount due on 20-august-2010(or no. of days that assigned in the terms condition,e.g.=balance due * 0.7).

There are some different payment schedules, Partial payment, full payment, balance is due on 60days, etc.

Process:Sales order->post->posted sales invoice->report ->206-Sales - Invoice
From where i have to fetch this information in navision for the 206# report?

Thx in advance..

ssingla

Standard NAV does not provide multiple payment terms as required by you. You need to customize and then fetch the information as required.

Belias

ssingla wrote:

Standard NAV does not provide multiple payment terms as required by you. You need to customize and then fetch the information as required.

italian localization does it :thumbsup:

brijeshvaidya

Thank you for your reply,

Pls see this scenario

Sales Order:

-In The payment terms table, Due Date Calculation and Discount Date Calculation formula available,
i applied the 3D and 2D respectively,
and if the Posting date is 7th august then

Due date = 7-aug-2010+3D = 10-aug-2010
Pmt. Discount date = 7-aug-2010+2D = 9-aug-2010

Payment Discount % = 3

Q-1 Payment Terms Code = 10D-3/30 [Net 30 days, 10 days - 3%] (Pls explain this)

After posting this sales order,
it will come under the posted sales invoice,

now as per the above terms, i also show the payment made against the invoice amount..


here with i attached the image of the sales invoice report with payment made against it..

now my requirement is that...

Q-2 if this report print on x date, i want to calculate the amount due on x date or "amount due now" based on the balance due which is shown in the figure..

Q-3 and secondly, i also want to show the amount due on specific date(or the due date if it is printed before the due date of the
sales order, how to calculate amount due for the specific date).

Q-4 If due date is gone and pmt. discount date both are passed away then what happen?


total 4 questions.

Pls help...

kriki

Belias wrote:

ssingla wrote:

Standard NAV does not provide multiple payment terms as required by you. You need to customize and then fetch the information as required.

italian localization does it :thumbsup:

And also the Spanish and French ones I heard.

kitik

Kriki, you are right. Spanish localization allows it. It's on the module called "Cartera".

Salut!
Laura Nicolàs

ssingla

Unfortunately IN version doesn't have the functionality and the author of the post is from India so I replied in negative.

kitik

But know he has an idea on where to look if he needs to do something similar.

Kitting, for example, is not in the Spanish localization. When I needed to do something similar I downloaded a localization that had it and looked the code to see if something was useful to my needs.

Salut!

Andwian

kitik wrote:

But know he has an idea on where to look if he needs to do something similar.

Kitting, for example, is not in the Spanish localization. When I needed to do something similar I downloaded a localization that had it and looked the code to see if something was useful to my needs.

Great idea! :thumbsup:

ssingla

Andwian wrote:

kitik wrote:

But know he has an idea on where to look if he needs to do something similar.

Kitting, for example, is not in the Spanish localization. When I needed to do something similar I downloaded a localization that had it and looked the code to see if something was useful to my needs.

Great idea! :thumbsup:

Not exactly what Microsoft think about this. Coping other localization features is not allowed.

kitik

ssingla wrote:

Not exactly what Microsoft think about this. Coping other localization features is not allowed.

I didn't know that. Do you know where does it says that? I'll take a look...

Salut!

kitik

I found this:

http://www.microsoft.com/dynamics/en/us/products/nav-availability.aspx
Notice and disclaimer
[...] Microsoft does not make any representation, warranty (express, implied, or otherwise), or assurance about the performance or suitability of any localized and/or translated version of Microsoft Dynamics NAV used outside the country in which Microsoft makes that software generally available [...]

I underestand from the text that you can use other localizated versions (or functionalities I guess), but at your own risk. I does not say that you are not allowed to...

Salut!

Andwian

kitik wrote:

I underestand from the text that you can use other localizated versions (or functionalities I guess), but at your own risk. I does not say that you are not allowed to...

I agree.

ssingla

Microsoft has specially released Cross version Licensing Policy which authorize the use of foreign localization granules in the local license but client need to acquire the foreign license in 1:1 ratio which will normally kill any advantage of importing foreign localization in this particular case.