Query When I run my A/P aging report, all of the Intercompany vendor records are present with aging over 90 days. It appears the offset to each of those records is the “no vendor” record. Can someone help me understand why this could be happening? Ideally, these would not show up. Solution When you run… Continue reading Intercompany “Vendors” on A/P Aging report
Tag: A/P Aging
Fully Applied Vendor Bill/ Bill Credit is showing in A/P Aging Detail report
The As Of date in the A/P Aging Detail is before the Applied To Transaction (Bill, Journal, or Bill Credit) Date. The balance of the Vendor Payment / Bill Credit is considered as Unapplied until the As Of date covers the applied to the transaction date Example: Vendor Payment / Bill Credit is dated 8/21/2023… Continue reading Fully Applied Vendor Bill/ Bill Credit is showing in A/P Aging Detail report
Customize the A/P Aging summary for displaying the purchased quantity.
A/P aging report can be customized to display the quantity purchased. The quantity received is displayed by adding the ‘Item: Current quantity available’ field into the report. The quantity which is yet to be received is displayed by adding the ‘Item: Current quantity on order’ into the report as shown below. For getting the quantity… Continue reading Customize the A/P Aging summary for displaying the purchased quantity.
A/P Aging Report by Posting Period – Alternative Solution
Scenario Customer Request a A/P aging report by posting period. Solution Navigate to Home > Set Preferences > Analytics tab Report by Period > All Reports Hit Save Navigate back to Reports > customer/Receivables > A/P Aging Set the Period under the As of field. Please Notes: 1. The set preference is only applicable to the user login.2. Here we will get the result of the unpaid receivables by periods… Continue reading A/P Aging Report by Posting Period – Alternative Solution