Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQL Query report for Active & Inactive BP based on GRPO

Former Member

‎2018 Nov 29 3:16 AM

0 Likes
696
  • SAP Managed Tags
  • SQL

Hi folks,

I'm new in B1 and SQL so i need some help with this issue. A client asked for a query report for active and inactive BP based on GRPO transaction. The inactive BP report does not fit my client's requirement. There are two requirement;

  • BP with transaction within a year
  • BP with no transaction more than a year

What i'm struggling with is the second requirement which i could not understand how to achieve that. It would be great help if you can help me understand this.

Below are the query for what i;ve done so far (active bp within 1 year), i don't know if this even correct.

SELECT distinct getdate() as 'Current Date',T0.[DocDate], T1.[CardCode], T1.[CardName] 
FROM OPDN T0  INNER JOIN OCRD T1 ON T0.[CardCode] = T1.[CardCode] 
WHERE  (datediff(dd,T0.[DocDate],getdate())) < 365

Additional info, i'm using B1 9.2 PL11.

Hi folks,

I'm new in B1 and SQL so i need some help with this issue. A client asked for a query report for active and inactive BP based on GRPO transaction. The inactive BP report does not fit my client's requirement. There are two requirement;

  • BP with transaction within a year
  • BP with no transaction more than a year

What i'm struggling with is the second requirement which i could not understand how to achieve that. It would be great help if you can help me understand this.

Below are the query for what i;ve done so far (active bp within 1 year), i don't know if this even correct.

SELECT distinct getdate() as 'Current Date',T0.[DocDate], T1.[CardCode], T1.[CardName] 
FROM OPDN T0  INNER JOIN OCRD T1 ON T0.[CardCode] = T1.[CardCode] 
WHERE  (datediff(dd,T0.[DocDate],getdate())) < 365

Additional info, i'm using B1 9.2 PL11.

Reply
0 REPLIES 0