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

GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report required

Received Response
63
Views
1
Comments

Summary:

GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report required

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!