hi,
I'd like to create a report for incentives for sales staff.it need to be by supplier & specific products with product ID,Description,Cost & sell for each salesperson.
Any assistance will be appreciated
Answer
create report
Best answer by lauraj46
Hi
A good starting point would be the standard report Sales Profitability by Salesperson and Customer. To see product details, add the InventoryID and other details from ARTran table in the Detail section of the report.
For specific suppliers, add the POVendorInventory DAC to the report schema (join with ARTran by InventoryID) and filter on the VendorID.
Hope this helps!
Laura
+8Hi
A good starting point would be the standard report Sales Profitability by Salesperson and Customer. To see product details, add the InventoryID and other details from ARTran table in the Detail section of the report.
For specific suppliers, add the POVendorInventory DAC to the report schema (join with ARTran by InventoryID) and filter on the VendorID.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.