GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report required
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.
0