Hi all, is anyone aware of a way to prevent invoic...
# general
e
Hi all, is anyone aware of a way to prevent invoices from being created for a specific customer and specific item if invoices in any single month exceed a total dollar amount for that specific item and customer combination? E.g. customer A has 10 invoices in the month of September. These invoices contain a mix of different items. 3 of those invoices contain “Item ABC” (one with a qty of 2 and the two others with a qty of 1 each) Each unit of “Item ABC” has a cost of $25”. We want to flag or prevent invoices from being created if “Test Item” invoice charges combined exceed $100 across all September invoices. In this case, if a user tried to create a new invoice on September 29th for a qty of 1 of “Item ABC”, we want NetSuite to flag and prevent that invoice from being created. If that same user goes back into NetSuite and tries to create that same invoice on October 1st, the system allows it as normal, because there are no other invoices in October for that specific customer/item combination.