Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
HELP writing a search which tells me how much I have made from an order before paying
OBJECTIVE: Compare the amount of cash generated from items bought between the dates of receipt and the date the bill falls due....
Grouped by Vendor: Main vendors only
Bill: only those due within the next 60 days from today
Results:-
Due date: for payment
Item: which is included on that bill
Amount: Bill £ amount for that item item
Quantity sold: Number of item purcahsed which have been sold
Margin: £ / Or total revenue for items sold AND purchase price from bill (Amount field rather than Rate field)
0