To create a report for last sold item with the posting date

Answers

• Options

  neilgf Member Posts: 148

  2018-02-27

  Hi. You are getting all items as you are not telling Nav what to do if no sale for an item found. Neil

  0
• Options

  bharathnan Member Posts: 92

  2018-02-27

  Thanks for your reply.
  I want to print the report for the last sold item with posting date for each customer.
  Please help
  Warm regards,
  bharath K
  

  0
• Options

  nick_robbo Member Posts: 49

  2018-02-27

  I think you need to rethink how you are structuring this report, it should probably be from the Customer perspective, and from there you should find the last Sales Order for that Customer. From there you can find which Item or Items it related to, and the Posting Date.

  0
• Options

  bharathnan Member Posts: 92

  2018-02-28

  
  
  Thanks for your reply, I tried your steps,
  I am able to set the entry type in the request filter page of the report but I am unable to get the last posting date on that page.
  Please advice
  Thanks in advance
  bharath k
  

  0
• Options

  bharathnan Member Posts: 92

  2018-02-28

  Now I am able to print a report for customers with entry type sales but it's showing the values for all posting dates.But what I want to do is to print details for a customer for the last sold item related to the last posting date.
  Please advice
  Thanks
  Bharath.K

  0