For auditing purposes, the client has requested a tracking of purchase bills that were initially booked during December 2022 and subsequently settled in the following year, 2023. This entails identifying bills that were open in the 2022 calendar year and paid in 2023.
Solution
- Go to List > search> saved search > Transaction
- Enter name of the search
- Criteria: add Mainline – True
- Date -is within last fiscal year
- Type-Purchase Order
- Paying transaction: Date-is within this Fiscal Year
- Subsidiary-add the subsidiary.
- Under the result tab: Date,
- Internal id,
- Document Number,
- Status,
- Amount Paid= Total Amount,
- Paying transaction: amount=Amount Billed (Absolute Value),
- Paying transaction: Date=Date Billed
- Subsidiary
- Save the record