Question: we purchase inventory from vendors and t...
# accountingn
Nick Lorenson
06/25/2019, 6:08 PMQuestion: we purchase inventory from vendors and they give us discounts based on payment terms. The invoices/vendor bills have line items for the product and for freight. How do we prevent the discount from applying to the freight lines?
o
Olivier Gagnon (DXC)
06/25/2019, 6:16 PM@Nick Lorenson several options:
Olivier Gagnon (DXC)
06/25/2019, 6:17 PM1. Ideally your lines are "sorted" so all produucts then all freight. If so, add a subtiotal item under the products then add a Discount item
Olivier Gagnon (DXC)
06/25/2019, 6:18 PM2. If they aren't cleanly sorted, add subtotals under clusters of products and under freight. Only add discount items under product subtotals
Olivier Gagnon (DXC)
06/25/2019, 6:18 PM3. Manually calculate the value of the discount and add a fixed value Discount Item worth that
Olivier Gagnon (DXC)
06/25/2019, 6:19 PM4. You can (and probably should) use Payment Discounts which you would apply at moment of payment, though again NS will try to apply a discount percentage to the full value, so to avoid that you'll need to manually calculate the value and key in that specific amount
n
Nick Lorenson
06/25/2019, 6:30 PMThank you Olivier. I realize I formulated my question incorrectly. The amounts on the invoices are listed under the Expenses tab, not broken out line by line for each item on the Items tab
Nick Lorenson
06/25/2019, 6:33 PMand would a Discount Item be a regular item with a negative amount?
a
Alex K
06/25/2019, 9:14 PMThis question came up once before and people had responses - short answer is a script.
https://netsuiteprofessionals.slack.com/archives/C29HKGM6J/p1558618820287900