Sage 100

 View Only
  • 1.  Data File Display won't let me copy/add GL Period Posting Record

    Posted 12-28-2022 10:30
    Data File Display won't let me copy/add a?? GL Period Posting Record.
    It usually works to change a key-field then update (choosing to retain the original record).

    It gives message:



    Is there a data-dictionary setting that prevents DFDM from copy/modify key fields on certain files?


    --

    Friendly Systems, Inc.

    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free.www.avg.com


  • 2.  RE: Data File Display won't let me copy/add GL Period Posting Record

    Posted 12-28-2022 10:32
    The KeySize field for that file in DFDM says:?? "N/A".??


    --

    Friendly Systems, Inc.

    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free.www.avg.com





  • 3.  RE: Data File Display won't let me copy/add GL Period Posting Record

    Posted 12-28-2022 10:40
    When that happens to me on some other file (a Scanco one, I think), I change one of the key fields to something bogus and save it and it asks if I want to delete the old one and I say Yes.  Then I delete this same record again and put it back to what it should be and say Delete to the old one again.

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 4.  RE: Data File Display won't let me copy/add GL Period Posting Record

    Posted 12-28-2022 10:55

    Here is how I do this.

    Change the key field that you are changing, and also change the Sequence Number field. Make sure you change it to a sequence number that does not already exist. Then it will ask you if you want to remove the existing one.

     

     

     

     

     

    Did you miss our 2022 Sage 100 Year-End Training Webinar? Watch the recorded webinar now!

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     






  • 5.  RE: Data File Display won't let me copy/add GL Period Posting Record

    Posted 12-28-2022 13:20
    Solved for GL Period Posting Record by entering a $1 journal entry for the acct/period, and Sage automatically creates a record during update.
    Then reverse the posting.

    --

    Friendly Systems, Inc.

    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free.www.avg.com