I need a Saved Search that includes the following details:
- Sales Order Document Number
- Related Item Fulfillment
- COGS Amount
- Invoice Amount
The total COGS Amount and Invoice Amount should match the Trial Balance report. However, when I tried creating the Saved Search, the totals are not matching with the Trial Balance values.
If anyone knows the correct approach or has faced a similar issue, please help.