Negative Unit Price

rj5570

I would like to set up products as a discount.

for example i would like to be able to charge customer for the full amount, but have a seperate invoice line item (using something like products) that is a discount type and has a negative invoice amount.

but negative amounts are not allowed as a unit price, how can i work around this.

this is what i would like the invoice to look like

asset A blablablabla $500.00
prod-disco bla bla bla bla $-75.00

total $425.00

rj5570

nevermind, i read its code unit 11 that checks for the negative amount, i do not have permissions to change code units grrrrrrrrrrr!

is there another work around? i would like to be able to SHOW the customers they are getting a discounted amount and show them what the actual price is.

also to be able to report and track discounts given

ayhan06

you can use G/L accounts.. if i am not wrong, this discount must already be posted certain G/L account. in sales order, add a line whose type is G/L account that you would post to discount.. sales lines whose type is G/L account have negative quantity or negatve unit price..in this way, you may not report discounts item by item..

the other way is to use item Charges with negative unit price.. if you item chrages, you will have two different value entry for one item ledger entry.. one of value entry shows actual price and second vallue entry shows the discount, also the second value entry will have the item charge code.. you can this item charge code to report different types of discounts

rj5570

thanks!
the G/L option wont help, cause i wont be able to track it

i will look at the item ideal and see if that works, and post my results

rj

David_Singleton

rj5570 wrote:

I would like to set up products as a discount.

for example i would like to be able to charge customer for the full amount, but have a seperate invoice line item (using something like products) that is a discount type and has a negative invoice amount.

but negative amounts are not allowed as a unit price, how can i work around this.

this is what i would like the invoice to look like

asset A blablablabla $500.00
prod-disco bla bla bla bla $-75.00

total $425.00

Just use Navision discounts, this is a seperate field on the sales line.

When printing the invoice, modify the report with a new section that prints the discount line as a separate invoice item Navision will handle all the accounting and posting details.

Don't make drastic code modifications if not necessary. remember the first rule of Navision. KISS !