so_invoicepayment missing, converting from 4.5 to 2019

SOLVED

I am receiving an error message when attempting to convert 4.5 Sales Order files to 2019.  It is an error #12, file does not exist or already exists.  File: SO_InvoicePayment.

I cannot find the file in my sales order data directory.  Nor do I remember ever seeing such a file.  I tried to recreate it using Reinitialize Data files, and it is not present in my list of Sales Order files.  Any ideas?

  • 0
    SUGGESTED

    Did you install product update 8 for version 4.5 per the upgrade guide?

    If yes, i don't remember if the S/O module is at the framework level in version 4.5 but you might be able to try activating the S/O module for the target company and see if that will create the file on the version 4.5 install. There is a KB article on this but the KB is down for maintenance right now.

    Try the following steps. Replace "xxx" in step 5 with the target company.

    1. On the Sage MAS 90 or 200 the File menu, click Run
    2. Type SYZCON
    3. Click OK
    4. At the prompt, type the following, and then press ENTER: 
      O = NEW("SY_ACTIVATION_BUS",%SYS_SS) 
    5. Type the following, and then press ENTER: 
      PRINT O'ACTIVATE("S/O","xxx")
      "1" is returned if the previous command is successful.
    6. Type bye
    7. Press ENTER.
  • 0 in reply to David Speck

    Thanks for your response.,  Yes I did install  product update 8.  On the new installation, I went into Reinitialize data files to see if I could just create the file, but unfortunately because the data is not converted yet, it doesn't show.  I also tried activating from Company Maintenance, without success.  I will give your method a try.

  • 0 in reply to David Speck

    So that worked after I renamed the sales order data folder.  I then renamed the new folder, and put the original folder in its place.  I copied the 3 missing payment files  (salesorderpayment, invoicepayment, and salesorderhistorypayment) into the sales order data folder (with the 4.5) files.

    But now I am unable to do another conversion, because it thinks that the data files are at 6.1 data level.. Is there anyway I can tell it that they are at data level 4.5 so I can make it do the conversion again?

  • 0 in reply to David Speck

    I see that I did not follow your instructions properly, and that I did this all  on the NEW installation, not on 4.5 ugh.  I will do it over on 4.5 and see if it creates the files there, and then use those copies.. But how can I change the current installation to no longer see sales order, or see it as level 4.5 so I can reconvert the files?

  • +1 in reply to mkaney
    verified answer

    Not absolutely positive about this but SO_Options has a DataVersion field that you could attempt to set using DFDM to the value that is in the 4.5 version. SY_Activation has a DataLevel field that you could also set to the value that is in the 4.5 version. SO_Options is company specific whereas SY_Activation has records for every company and module so you will have to find the right record for the SO module and target company using the CompanyKey field cross referenced with the CompanyKey in SY_Company.

  • 0 in reply to David Speck

    That seems like it did the trick.  It didn't spend a whole lot of time doing the conversion, but it said it checked the data dictionary and then it updated the data version to 6.1 

    I'm going to have to do something similar to this to get the PO files over on the next migration attempt and not lose history.  The module also failed the first time when it went to create the PO history because the history files were missing.  Well of course they were, there were no PO history files in 4.5.  Problem is that it dumped all the history form the main PO files.  No issue, I'll just put those history files in there on the next round.  It seems like 4.5 to 6.1 was too big of a jump, which is too bad because the documentation said it was doable.  

    Thanks for your all your help!