Address ID's missing after GL close

(0) Share

Report

Posted on by Community Member

I was able successfully close our GL last night. However after the close it appears that all our Address ID's (Purchasing, Sales, HR & Payroll) are missing. Has anyone had this happen before and if so how do I restore these Address ID's?

*This post is locked for comments

All responses (4)

Answers (0)

Sort by

Richard Wheeler 75,854 Moderator on at

Like (0)

Report
Copy link

Link copied!

That makes absolutely no sense. Do you have third-party products or custom triggers that would have caused this? Is it too late to restore from backup? If it is, you can restore to another database and then restore those IDs using SQL.
Community Member on at

Like (0)

Report
Copy link

Link copied!

I completely agree this makes no sense at all. Nothing out of the ordinary aside from Mekorma, Regal Pay, Greenshades. I'm working on a restore to our DEV environment now. What table are the Address ID's stored in. I checked SY06000 but that looks like all addresses for all customers and vendors.
Suggested answer

L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I'm with Richard, it doesn't make any sense for the close to have caused this. If you can't restore everything, you could just restore the addresses. The are in the following tables in the company database:

Vendors: PM00300

Customers: RM00102

Payroll: UPR00102

Company Locations: SY00600

Which other addresses do you need?

Kind regards,

Leslie
Community Member on at

Like (0)

Report
Copy link

Link copied!

Understood. I guess I was just hoping there was Master table that housed all of these ID's. I will get to work on restoring these in each module. Thank you all for your help.