Old AP Payment Back in Current Aging

This 2021 AP payment from before my time popped up again in our AP List as due.

https://geminiplasticsinc.cetecerp.com/appayment/4308/edit

I assume it was because I cleared old $0 AP payments as we discussed here. I think the prior person was trying to account for a downpayment for this 2021 purchase. Can you please assist me with the best way to clear this so that it doesn’t affect accounting? Thank you!!

I see the following vouchers that are in our AP Aging but need to be cleared from prior years, as well:

https://geminiplasticsinc.cetecerp.com/voucher/1655/edit_voucher
https://geminiplasticsinc.cetecerp.com/voucher/1652/edit_voucher
https://geminiplasticsinc.cetecerp.com/voucher/11308/edit_voucher
https://geminiplasticsinc.cetecerp.com/voucher/11307/edit_voucher

But I am most concerned about the one that is above because the dollar amount is substantial.

By the way, the past person did a P&L and Balance spreadsheet outside of Cetec - so I do not need past fiscal years to be the same - however, I would like the GL to stay the same for the first one - since it recorded the purchase of a piece of equipment.

Checking back…

Hi @sbeausoleil

I will escalate this issue to accounting for you.

  • Cetec ERP Support

@sbeausoleil

This has been escalated and is in our accounting team’s queue.

  • Cetec ERP Support

I came across them because they are listed in the A/P Aging Summary here:

https://geminiplasticsinc.cetecerp.com/ap/summary?reloaded=1&vendor=&as_of=2024-05-20&use_date=invoiced_on&subsidiary_location=all

But, if you go to the vendor, click on A/P Statement - this debit memo from 2021 is now showing it has not been applied. It was not like that before.

https://geminiplasticsinc.cetecerp.com/vendor/1102/statement

The below two are slightly different. They show up when you go to the Vendor pages, in the upper right corner it shows a total in the “A/P Balance”.

From here, if you go to the A/P Statement, it is empty, no vouchers.

But if you click the Paid/Closed button in Cetec, in the list they will show up as unpaid. So it says nothing is unpaid in one stop, but then if you click Paid - it will show up in the list as unpaid:

https://geminiplasticsinc.cetecerp.com/vendor/151/statement?from_date=&to_date=&include_closed=1

Invoices from Dec 2022

https://geminiplasticsinc.cetecerp.com/vendor/922/statement?from_date=&to_date=&include_closed=1

Thank you Sherri…following up on the additional information and will get back to you as quickly as possible!

CETEC ERP Customer Support

Sherri,

Those 4 Vouchers in your list are open on your AP aging because the AP Pmts that paid them were zeroed out and closed, so they are again open for payment. Is there a cash/checking payment in one of the checking accounts apart from the now closed AP Pmts? Do you consider the Vouchers already paid in that regard and so want the Vouchers zeroed out and closed?

Best,

CETEC ERP Customer Support

Sherri,

Assuming that you intended for both the AP Pmts you say “were cleared out” and the related Vouchers 1652, 1655, 11307 and 11308 to be cleared as well, in testing I was able to check the ‘Drop’ box and click Submit button, seen here:

Then zero out the Value in the upper right corner and click Submit again (in upper box of window), seen here:

This example is from test for Voucher 11307, but those steps worked for all four listed above in testing, and those Vouchers/Amounts no longer appear in AP Details report in the test environment.

AP Pmt 4308 w/ DR Memo 45 still checked as included is different in that I don’t have enough information as to what the original value of the Voucher was (for the Fixed Asset purchase) which AP Pmt 4308 was used to pay the Voucher less the $48,200 DR Memo. I share your concern about zeroing out the value of DR Memo 45, even though this does remove it from the AP Details report in the test environment. My suggestion would be to zero out DR Memo 45 & click Update button (screenshot below), but DO NOT click ‘Closed’. Then coordinate with CPA to compare the Asset section on the 2021 YE Balance Sheet with the Fixed Asset schedule for 2021 to see if the total balances agree. If not, this can be addressed with a manual ledger entry, dated 2021-12-31, to adjust the GL balance for Fixed Assets in CETEC to the fixed asset schedule balance per the tax return. I would reference AP Pmt 4308, the Voucher #9(?) and DR Memo 45 in the manual ledger entry description for documentation purposes.

Let me know if we can be of further assistance on these changes in production or other unplanned issues that may arise when making these changes.

Best,

Susan

CETEC ERP Customer Support Accounting Team

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.