credit price lower than sales price

robinho81

Hello,

We've got items with a lower credit price than the original sales price.

When we make a new sales order, the sales price of the item is 10 euro.

When we make a credit memo, the credit price has to be 8 euro, but as it uses the same price table it comes up with 10 euro....

So we depend on the user to enter the correct item price. Is it possible to put this intelligence in Navision?

tnx!

chengalasettyvsrao

Why user want to enter the Lower sales price at the time of Posting Credit Memo ?

I can suggest Create the Credit Memo from Posted sales Invoice Using copy document or In the Sales Credit Memo form call Get Return Receipt Lines , then system will take exact sales price against that documents .

robinho81

Hello,

Because its value devaluates when we get the item back. The items are packaging material. The customer pays 10 euro, but when he returns the item he will get 8 euro as a refund.

FDickschat

You will have to customize this. There is no price or discount setup for sales document types existing.

Deep

If this is just a matter of less refund, you can consider using item charges, say "Restocking Charges" in negative.

FDickschat

Deep wrote:

If this is just a matter of less refund, you can consider using item charges, say "Restocking Charges" in negative.

:shock:
What about just a simple discount of 20%? This would be a rather small modification where under a simple condition a (preconfigured) discount is used.

Deep

FDickschat wrote:

Deep wrote:

If this is just a matter of less refund, you can consider using item charges, say "Restocking Charges" in negative.

:shock:
What about just a simple discount of 20%? This would be a rather small modification where under a simple condition a (preconfigured) discount is used.

There is absolutely no harm in using your technique.
This is just my personal view of using a workaround with any available standard feature rather than modification.

robinho81

Thanks for the answers, but there is not (yet) a possibility that the whole situation is dummy proof... that anyone making an credit memo is always using the correct decreased prices? Without having to know to look at a specific paper for example?

Savatage

As above...is it always 20%?

Idea..new fields to Sales Setup table..
"Credit Memo Auto Discount" - Type - Boolean
"Credit Memo Set Discount" - type - decimal

Sales Line Table - OnValidate of Quantity field (add to the end)

SalesSetup.GET;
If "Credit Memo Auto Discount" then
Validate("Line Discount %",SalesSetup."Credit Memo Set Discount");

Placing the fields on the setup table makes the discount % adjustable for the future and give you the ability to turn it off.

we release all cm's before posting so we usually put our checks there.

Or perhaps setting the Invoice Discount % on CM's automatically?

Idiot proofing is always a challange.

remember something like this will put a discount for all cm's - if you don't want that then do do this.
You probably have to make it "type" sensitive too. Probably better to run thru the lines on "release" or some other function to see if each line has a discount. so many ways to approach this..

You know your biz best and we can only speculate what you need.

Alex_Chow

robinho81 wrote:

Thanks for the answers, but there is not (yet) a possibility that the whole situation is dummy proof... that anyone making an credit memo is always using the correct decreased prices? Without having to know to look at a specific paper for example?

Doing modification on this area will be dummy proof. I would work with your partner to find the best solution on how to go about it..

Most of the responses on this thread are giving you suggestions on how to achieve this without modification.