The problem is always did the 100 units get sold to the specific customers under rebate support, or did the 100 units that got received into stock get sold to a mix of eligible and non-eligible end customers.
Our old system was modified to handle rebate contracts.
The basic structure was Purchase Unit A 120.00
Less Normal Purchase Discount 15% 18.00
Average Cost Into Inventory 102.00
The rebated purchase discount was linked
to a Special Pricing Contract under
a Customer Code and either involved discrete items
or was linked to a series of items associated
/ tagged to a Product Class
Expiration dates and qty caps were tracked by the record
Say the rebate support was an additional 20% off
the already discounted net price -20.40
The Sales Transaction involved DR CR
Rebate Support Rec 20.40
Cost of Goods Sold 81.60
Trade Accts Receivable 130.00
The item ledger record showed
Net Purchase Cost 102.00
Less rebate support -20.40
Net Cost Basis 81.60
If it was a rebated purchase discount purely available after payment to the manufacturer (not linked to specific sales activity) the rebate support was linked to the purchase order line and a rebate receivable record was posted to the Commission Receivable records
Automatically by the payables posting.
The Po net cost into inventory was
Purchase Price ( 120.00 less 15%) 102.00
Pending Rebate Support -20.40
Average Cost in Inventory 81.60
Inventory Receipt DR CR
Voucher Payable 81.60
The above was written by the voucher receipt
Linked within the voucher receipt was the Pending
Rebate Contract support
Payables Entry Dr Cr
Accounts Payable 102.00
Comm Receivable 20.40
Vouchers payable 81.60
This was in our request for proposal with our VAR , management determined the Ship and Debit activity was at a lower volume than in the past, so it was tabled.
NAV does not have an out of the box method to handle this.
Micro Soft should make it a base feature of Domestic Wholesale distribution in the United States.
If you've found this thread useful, dive deeper into User Group community content by role