If the recurring Payment is applied to an Invoice that is future dated, then the recurring Payment will appear on the Aged Payables Report as a negative value. This is because the recurring Payment is applied to an Invoice that doesn't yet exist. If a recurring Payment is a standalone transaction, meaning that it's not applied to an Invoice, future or otherwise, an instead just applied to a G/L Account (not a Prepayment), then the recurring Payment would not show on the Aged Payables Report at all.

Tammi M. Ermerins ([email protected])

Certified Sage 50/Peachtree Accounting & Crystal Reports Consultant & Trainer

800-780-0700 / 954-961-0600, Visit Us on the Web at https://pcosupport.com

Thank you for your response! I can see that the payment is being applied but the invoice is not, however the invoice (that should be recurring) is not future dated. For example, I open the payments window for payment that was made on 1/11/24. When I click on the invoice associated with the payment, the date is 11/12/23. November is the last month that invoices show up on the GL and Vendor Ledger. The invoice does say that there are 0 additional entries and when I click the copy drop down, "create recurring" is greyed out. So, I guess my question now is how do I apply the already recurring payments to the recurring invoice(that isn't recurring)? Is there a way to extend the recurring invoice?

In the sample company, Bellwether Garden Supply, I created a Purchase/Receive Inventory Invoice dated 11/12/2023 in the amount of $1000. Then, I entered a Recurring Payment against that Invoice in the amount of $100, with the Recurring Payments to happen Monthly, starting with 1/11/2024. When I run the Aged Payables Report as of 3/15/2024 (default date for sample company), I only see the unpaid balance of Invoice; I do not see the Recurring Payments as negative values displayed. It's possible that there is something entered incorrectly on your end and without remotely reviewing your system with you, I can't tell you what that would be. I attempted to call you in follow up to your email but received your voicemail. Please connect back with me via email and I'll log in with you and take a look at what's going on, and then report our findings here for anyone else who may benefit from this situation.

Tammi M. Ermerins ([email protected])

Certified Sage 50/Peachtree Accounting & Crystal Reports Consultant & Trainer

800-780-0700 / 954-961-0600, Visit Us on the Web at https://pcosupport.com