Sage 100

 View Only

  • 1.  Transaction JE VI import - select records to import by Company Code?

    Posted 06-05-2024 18:59

    We have a client with multiple companies.  The vendor that handles their billings (they're a Property Management company). produces a daily file that includes data for all companies (i.e., they have a column in their export file for the company code).  Is there a way to build an import job that can use the same file in each company, but only import records for the current company?



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------


  • 2.  RE: Transaction JE VI import - select records to import by Company Code?

    Posted 06-06-2024 08:10

    I don't think my client has confirmed this works yet, but this is what @David Speck II told me to do (apologies, David, if I screwed it up) - in this case, the first 3 characters are the company code



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



  • 3.  RE: Transaction JE VI import - select records to import by Company Code?

    Posted 06-06-2024 09:21

    Don't know how to do it but wonder if you could set a conditional field for the company code to equal MAS_SCR_CMP : company code system variable.  Perhaps a runtime prompt for the company code?  We have many experts in the group.  



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 4.  RE: Transaction JE VI import - select records to import by Company Code?

    Posted 06-06-2024 09:35

    Guess I should refresh my page after being open all night as a reminder to respond with idea.  Looks like I was close.....



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------

    Original Message


  • 5.  RE: Transaction JE VI import - select records to import by Company Code?

    Posted 06-06-2024 16:38

    Thanks to @Beth Bowers and @David Speck II, works like a charm.  Good thing, they have over 50 companies!



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


Related Content