If we can get this topic back on track - there is nothing in the original post about Sale Orders, so all that discussion is a distraction. So is all the repeated lecturing about how Manager currently functions.
The original post’s “requested suggestion” was “help us to generate a report” where the Inventory Items quantities between the Invoice (Purchases or Sales) can be reconciled to the Inventory Item quantities of the associated Goods Receipt or Delivery Note.
It is understood that the Invoices are demands for payment, so that is not under question. However, if we focus on Purchases Invoices, how do you verify the status that a particular Purchase Invoice can be paid without first validating that the actual Inventory Items quantities have been received.
@sharpdrivetek advised that "in the Inventory Items tab you can drill-down the related invoice by clicking on the non-zero quantity displayed under Qty to deliver or Qty to receive columns. But they also quite correctly noted the shortcoming of this with “this will not solve your requirement completely because for invoices having more than one inventory item you will have to drill-down on each inventory item separately.”
Or to explain this lack of ability to reconcile the actual Inventory Item quantities another way.
You have accounts dept. staff who only have permissions for the Customers / Sales Invoices and the Suppliers / Purchase Invoices tabs only, but no permissions for the Inventory Items, Goods Received or Delivery Note tabs.
Therefore how can they:
Pay a Purchase Invoice without knowing if the actual Inventory Items have been received.
Demand that a Sales Invoice be paid without knowing if the actual Inventory Items have been delivered.
The requested suggested report would provide the Invoice status by reconciling the actual Inventory Item quantities between the related forms. My only suggestion would be this, that it be an exception report, that is, it only lists Invoices where there is a mismatch of Inventory Item quantities so not to be overly cluttered. Any Invoice not listed ='s Inventory Item quantities are matched.
This data matching report requires no change to Manager processes. Any Invoice listed on the report can be investigated as to cause. In effect, a audit tool.
Yes, some organisations may have supervisory authorisation oversight, however smaller and/or more modern management organisations have eliminated this overhead, the advantage of computers.
@rully_p - if you confer with the above, then it can be added to Ideas