Sage 100

 View Only

  • 1.  Created an import routine for A/P Invoice data ent

    Posted 11-25-2013 11:24
    Created an import routine for A/P Invoice data entry to import their old system's (still using until 1/1/14) daily information. I created a UDF in GL_Account and imported the mapping to the new Sage 100 account...added the UDF to the AP_InvoiceDetail file and was trying to figure out how to pull in the Sage 100 G/L Account number using the UDF in the GL_Account table. Any help would be GREATLY appreciated. (It's been YEARS since I've done this and know it can be done, just forgot how...must be my ""experience"" creeping up on me :(


  • 2.  RE: Created an import routine for A/P Invoice data ent

    Posted 11-25-2013 11:36
    Wouldn't this be a file assign record??


  • 3.  RE: Created an import routine for A/P Invoice data ent

    Posted 11-25-2013 11:44
    Tried it, came back unassigned :-(


  • 4.  RE: Created an import routine for A/P Invoice data ent

    Posted 11-25-2013 12:08
    I think there is some Perform Logic in your future..


  • 5.  RE: Created an import routine for A/P Invoice data ent

    Posted 11-25-2013 12:19
    Thanks Beth, wish I knew it :(


  • 6.  RE: Created an import routine for A/P Invoice data ent

    Posted 11-25-2013 12:23
    I wish I did, too! I've done a couple of little ones, but most of my Perform Logic was in non-framework modules and I haven't really looked at the changes required yet.


Related Content