Year End closing process (Pre-Close)

So on the AP195 you get unposted transactions exist, it sounds like are you not using the update option to move these to the next period on AP195. It sounds like you have two voided invoices, were these reinstated and canceled as well or just voided.

Hi Ruma

thanks for  your reply. I'll try to do this if this will work for me and let you know.

Dainty

Hi Mark,

These 2 invoices were just  voided, not reinstated.

Dainty

So the invoices were voided on CB80 but the AP190 has not been run to reinstate the invoices?

Brad

I can't go to ma70/75, I never used this. This is what I've noticed now when I printed AP265,only both these 2 open payments are in "Processed" status and all others are in "Issued" status. Maybe this is the problem now, I should make this in issued status. Please tell me how to do this. Remember that I found these 2 Open Payments Report in AP195, so this should be form of payments and not invoices.

tlhanks,
Dainty

Dainty,

If Processed appears in the status column, AP150 and forms/tape/electronic creation (AP155, AP157, AP160, and AP161) have been run for this item.

This would normally mean that AP170 needs to be run, but I am pretty sure you have said it has already been run.

I think you need to look at the status on APINVOICE, APDISTRIB, and APPAYMENT for this invoice. One of the status flags is not set correctly.

Brad

Hi Brad

These 2 Open Payments should be deleted, they've been voided and not showing in CB80.1 anymore but when I run AP265, they are showing up. Since I did my Bank Rec already, I checked my GL290 if I have any reconciling item but these 2 payments are not there.

I'm thiinking of making a reversing entry in GL40 since this period has not been closed yet but I'm not sure if the balances will change. Is it okay to do a reversing entry/

Dainty

To be doubly sure you can run a CB221 and include void payments to check that these payments were voided.
Now if the payments are voided check on ap90 to check the invoices are cancelled.
If they show that the invoices are cancelled then the status on these invoices were not updated behind the scenes.

I took a look back at some notes I took when I helped someone else with the same issue, they had an orphaned CBCHECK record that was causing the problem, sounds like that may be the same issue for you.

I am not sure how doing a reversing entry in GL would help you get passed the AP195 issue your are having.

Brad

Hi Ruma

I did run CB221 and these 2 payments are not showing up. Also, wento AP90 and they were cancelled. I just dont know why its still showing in AP195 if they have been cancelled and voided.  They are referred to as "Unposted payments exist, run AP170" at the end of the report.  Its impossible not to run AP170 at this point or else I cant issue check after Nov 2007. 

I dont know what to do with this anymore.

Dainty

 

HI

The reversing entry would be my last resort, I cant think of anything else to do. I'm trying to read the AP manual, like troubleshooting but I cant find anything here.

Dainty

The reversing entry would not resolve the AP195 issue. I am almost 100% confident that the resolution to the issue is to correct corrupt records in the database. There is no Lawson delivered online program that will do this, someone will need to go "behind the scenes" and fix the orphaned records.

Brad

If the system is asking you to run ap170 ghen please run it. This means that you have run the payment cycles which means you ran ap150 and ap155 but not the ap170 which is the payment closing program - the last step in your payment cycle. If you run this it will now posts all payments to gl which means debit the ap account and credit cash.
If The system stlll shows you unposted transactions after running this then you would have to open a case with Lawson gsc. They will be able to help you where when you send the dumps there may be a flag or status not updated. In this case they will be accurately telling you which flag to update and how which then will resolve your issue.

I did run AP170 but after that nothing happened. I guess it didnt go through when I did it during that time.
Let me ask, what is Lawson gsc?

Dainty

Global Support Center, you would need to be current with maintenance to use this service.