2,874
Like
Share
ReportThe most precious thing that you can learn the business from your customer business requirements. As one of the customers need customization for a Vendor Rebate Scenario on Microsoft Dynamics NAV 2018.
First, What is Rebate?
According to Business Dictionary.
Rebate is a Return of a portion of a purchase price by a seller to a buyer, usually on purchase of a specified quantity, or value, of goods within a specified period. Unlike discount (which is deducted in advance of payment), the rebate is given after the payment of full invoice amount.
The standard behavior of this scenario can be as a Refund Transaction on a specific Vendor Ledger Entry with a specific amount, but at the meantime we would not go to this scenario as the Rebate scenario we are talking about now must be with a Percentage % of the total purchases Excluding VAT on a specific Vendor, as this percentage differs from vendor to another one.
Another determination that is the rebate calculation apply on the Total Purchase Invoices Yearly or Monthly basis taking into consideration Purchase Return Orders.
Therefore it should be like (Total Purchase Invoices / Month – Total Purchase Returns) * Rebate Percentage.
Details are as follows to get to the rebate scenario step by step.
| Sc.1 | Date | Action | Amount | VAT Amount | Amount After Tax | Rebate Amount | Notes | ||
| 1 | 1/1/2020 | Create Purchase Invoice for (Supplier 1) | 1000 | 250 | 1250 | ||||
| 2 | 31/1/2020 | Run “Apply Vendor Rebate” | Run Once at the end of the month. | ||||||
| 3 | 31/1/2020 | Open General Journal Entry – Apply Entry | Or you can Apply after Posting (From Vendor Ledger Entires) | ||||||
| 4 | 31/1/2020 | Post General Journal Entry | 20 | ||||||
| 5 | 31/1/2020 | Create Payment Journal on (Supplier 1) | 1230 | ||||||
| 6 | 15/2/2020 | Create a Purchase Return Order (Supplier 1) | -1000 | -250 | -1250 | Total Return of the Purchase Invoice | |||
| 7 | 15/2/2020 | Create Refund Payment Journal | 1230 | ||||||
| 8 | 28/2/2020 | Run “Apply Vendor Rebate” | Ask if you want to pay the rebate amount or not. | ||||||
| 9 | 28/2/2020 | If “Yes” – Post General Journal Entry | |||||||
Hope you enjoy the Process…
*This post is locked for comments