Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS 90 Customer
jasonitspyder
Posts: 108
Registered: 12-15-2010
0
Accepted Solution

Change Item Number - Unposted Data

Hi,

 

I'm trying to change the item number, however MAS 200 is giving me the error:

 

You cannot proceed with unposted data in SO Data Entry and RMA Receipt Entry.

 

 

I have a testing company where I deleted all the batches in SO Data Entry and RMA Receipt Entry. However I'm still getting this error.

 

I also checked to post any of the unposted G/L entries. No go.

 

Any other places that I should check? Thanks in advance!

 

Running MAS 200 4.4 PU4 (yes I know it's a little old, upgrade to 4.5 in the plans)

Moderator
Natasha
Posts: 180
Registered: 07-15-2009
0

Re: Change Item Number - Unposted Data

Did you try updating sales journal and RMA?  There may be "deleted" invoice records on file for example.

 

Natasha Chang
Sr. Software Engineer
Sage 100 ERP
Sage MAS 90 Customer
jasonitspyder
Posts: 108
Registered: 12-15-2010
0

Re: Change Item Number - Unposted Data

Thanks for the reply. I looked in the sales journal, it is empty.

 

I guess some screen shots would be helpful here:

 

 

 

 

 

 

Thank you!

Switcher
BigLouie
Posts: 2,686
Registered: 10-28-2008
0

Re: Change Item Number - Unposted Data

Re-init the data entry files. Happens all the time.

Big Louie No MBA but BMOC
--------------------------------------------------------------------------
You have enemies? Good. That means you've stood up for something in your life.
Sage MAS 90 Customer
jasonitspyder
Posts: 108
Registered: 12-15-2010
0

Re: Change Item Number - Unposted Data

Re-init data files on the Sales Order and RMA modules? And all the files within the module?

 

Also, what does it do and what does it really mean to re-init data files? And what side effects would I encounter if something went wrong in the process?

 

Thanks for the help.

Super Contributor
Heather
Posts: 797
Registered: 10-29-2008
0

Re: Change Item Number - Unposted Data


jasonitspyder wrote:

Re-init data files on the Sales Order and RMA modules? And all the files within the module?



NO!!! 

 

Re-initializing wipes out all of your data.  It basically resets the file to what it would be on a fresh install. 

 

BL suggested re-initializing the SO & RMA data entry files only -- the ones that are already supposed to be empty.  If there's something stuck in there -- like a detail record with no header -- it'll be wiped out.  But all valid records will be wiped out, too.

 

Sage MAS 90 Customer
jasonitspyder
Posts: 108
Registered: 12-15-2010
0

Re: Change Item Number - Unposted Data

Thanks for the quick reply.

 

In my case, I assume the following would be the data entry files, correct?

 

SO_InvoiceHeader

SO_InvoiceDetail

RA_ReceiptsHeader

RA_ReceiptsDetail

Super Contributor
Heather
Posts: 797
Registered: 10-29-2008
0

Re: Change Item Number - Unposted Data

Yes, those are the SO Invoice Data Entry files. 

 

I don't have RMA, but the file names sound like they are probably what you're looking for. 

 

Sage MAS 90 Customer
jasonitspyder
Posts: 108
Registered: 12-15-2010
0

Re: Change Item Number - Unposted Data

That does it. Thanks for all the help guys!