Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Report to show GRN has more than one invoice with sum Qty and Sum Amount — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report to show GRN has more than one invoice with sum Qty and Sum Amount

Question
1
Views
0
Comments

Summary:

Report to show GRN has more than one invoice with sum Qty and Sum Amount

Content (required):

Business wants seeded report/query to show GRN has more than invoice with Qty and amount columns. They just want to verify few scenarios as below:

Scenario 1: GRN Qty 100 and Invoice 1: Qty 120 (invoice created more than GRN Qty).

Scenario 2: GRN Qty 100 and Invoice 1: Qty 30 Invoice 2: Qty 20 and Invoice 3: 40 (Invoices created more than GRN Qty and multiple Invoices).

Business wants to verify Invoices are billed more than GRN qty in the system. I don't see any report matching my criteria.

Please suggest any seeded report or Report SQL Query.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!