Our vendors generally allow a settlement (payment) discount for the invoice amount net of freight and tax, if paid within the discount terms. Our current solution is to enter an invoice in two parts, one payable invoice for the materials (which can be discounted), and another payable invoice for the amount of freight and tax (which cannot be discounted). This duplicate entry is inefficient. Since the freight can vary from shipment to shipment, we cannot precalculate a discount percentage that, when applied to the whole invoice, would result in the correct discount for just the materials. If there was a way to override the terms discount amount at AP entry, this would prevent us from having to enter every invoice twice.
Any suggestions would be appreciated.
*This post is locked for comments