Sage 300 2019 Menu has Accounts Payable item and sub items on there twice, how do we get rid of one of them?

Posted By LeShel Rich over 4 years ago

We upgraded to 2019 recently and found that one of our companies had some corrupt data. We found the following article that explained what we could try.

https://www.sagecity.com/support_communities/sage300_erp/f/sage-300-general-discussion/51864/ap-payment-posting

We went ahead and did a data activation on that company, for the second time. Now, all of our companies have a second Accounts Payable drop down with all of it's sub items. We are running load balancing on multiple servers with replication. I am wondering if something was duplicated when we ran the data activation.

Does anyone know what files I can look at in the sage directory that drive the menu? We have already checked the DATADICT and the CSAPP tables and they seem fine.

Thank you for your help!

0 Jay Converse Acumen over 4 years ago

Restore from back and start over.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeShel Rich over 4 years ago in reply to Jay Converse Acumen

Do you happen to know what drives the menu?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 4 years ago in reply to LeShel Rich

CSAPP. Look at the System database's CSAPP, you might find AP in there, which is wrong.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeShel Rich over 4 years ago in reply to Jay Converse Acumen

In the System Database there is only an AS record. The company database has all modules in it, but it looks right. I feel like there is a file somewhere that is duplicated or something.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeShel Rich over 4 years ago in reply to LeShel Rich

The other thing is that it is duplicated in all of our company menus. We have more than 80 companies, so it is some file they all have in common.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 4 years ago in reply to LeShel Rich

Delete *_C.ISM for a given user and company, see if that fixes it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeShel Rich over 4 years ago in reply to Jay Converse Acumen

That didn't get rid of it. What are the _P and the .wsp files?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 4 years ago in reply to LeShel Rich

_P is printer and finder settings. I don't know what the WSP files are, in 20 years nobody has asked me about it, so ignore them.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeShel Rich over 4 years ago in reply to LeShel Rich

Another development - the Accounts Receivable menu item is gone. It seem that the AP menu item replaced the AR menu item. It has to be a file somewhere.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 4 years ago in reply to LeShel Rich

Restore from backup and start over.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeShel Rich over 4 years ago in reply to Jay Converse Acumen

We ended up copying our Sage directory back over from the mornings backup. It worked, thank you for the advice. I should have listened the first time!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Sage 300 2019 Menu has Accounts Payable item and sub items on there twice, how do we get rid of one of them?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING