Notes: We are in the process of beginning a new type of business with some of our existing customers, and I wanted to get some more information about the Credit Note function in NAV. Currently, the credit note is issued only when physical product is returned in NAV or when we use the credit note to directly debit an account via journal entry.
We would like to be able to invoice a customer for the full amount of a product and then issue them a credit note for the discounted price that they will actually pay. We need to be able to invoice them for the full amount of the product instead of the net amount (full price minus discount) because the shipping documents (invoice and packing slip) are considered public documents in many of the foreign countries where we sell. We do not want our customers to be able to see the private pricing of each individual customer in their country.
So, we would like to know if the credit note function can be adjusted to do (or if it already does) the following things:
Credit Note Requirements
Allow line item discounts without requiring physical product to be shipped/received (i.e. allow a discount amount/credit per type of product on an invoice, not a generic resource G/L entry to sales)
Allow the discount applied to each line to be tied to the original line item and invoice inside of Navision and Tableau
Allow Tableau to see that the invoice and credit note are tied together and report the net amount per line item for gross profit reporting (we want one line with the net price; we do not two lines with full price and a return of partial price as that isn’t showing the correct sales price per item sold in total)
This is an example of how we would like to see it.
Original Invoice Individual Total
MATERIAL 1 3 cases @ $110.00 $330.00
MATERIAL 2 2 cases @ $125.00 $250.00
Credit/ Discount on Original Invoice
MATERIAL 1 3 cases @ $(15.00) $(45.00)
MATERIAL 2 2 cases @ $(25.00) $(50.00)
Tableau Report of Sales per Customer
MATERIAL 1 3 cases @ $95.00 $285.00
MATERIAL 2 2 cases @ $100.00 $200.00
Do you know if Navision can already process credit notes in this way? I could not figure out how to process a discount to an item without physically returning the item.