Finance | Project Operations, Human Resources, ...

Want the current date for the customer that has our item

(0) Share

Report

Posted on by Mukesh Bisht

Hello Community Members

Im having an issue with a report , we are trying to generate a report which contains all the customers that have our items for DEMO purpose , in this report we only want the last customers which has our item but instead it is displaying the list of all customers that have had an item , for ex: for item X200 we only want the customer that has the item but in report it is displaying all the customers that have had the item X200 , so what i want to write a MAX query with which we can get the MAX date , the date for transaction for the customer that has item X200. kinldy have a look at the code and let me how am i suppose to write the MAX query or if there is any other way i could fetch the value i want . Thanks for helping

How would i write the MAX query in above written code to fetch the MAX transaction date , by which I mean

All responses (2)

Answers (0)

Suggested answer

Mukesh Bisht 90 on at

Like (0)

Report

RE: Want the current date for the customer that has our item

The on hand inventory shows which and how many items are with the customer , we have several warehouses but for this report we are using BLR OUT

(one of our warehouses) ,and yest it is customized report , Id appreciate if any developer who could help me with this , Thank you .
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Want the current date for the customer that has our item

Hello Mukesh Bisht,

How and where do you record whether or not a specific item is at a customer?

Do you use a separate warehouse for that purpose or do you make use of other fields / functionalities?

Has there possibly been something modified?

Best regards,

Ludwig