I am looking to make a report or inquiry that will work as follows:
Select the customer
Results should pull a list of all the parts that customer has order in s certain time frame. Time frame defined by input field.
Is there something like this that already exists ? Any advice or help would be greatly appreciated.
Best answer by Naveen BogaView original
@stacy16 It seems report (i.e. Sales Order Details by Customer) is already available in default Acumatica. Please find the screenshot for reference.
I am actually looking to make this pivot table that i made from an inquiry that i also made into more of a report or more general inquiry.. I would like to be able to have our users select an account or their sales person number and have it show the results of their customers, locations and monthly usage of part numbers.. but in a report if possible?
@stacy16 It seems Standard Acumatica report is NOT available, what you are looking for and it requires customization.