Sage 100

 View Only
  • 1.  BI Explorer not exporting all lines - not even close

    Posted 02-11-2025 08:38

    Have a client with an AP Invoice History BI that ends up with about 30K lines.  If I run the same thing on their system (they are SWK Cloud, so I would be running in the same way that they do), all lines export to Excel for me.  When they do it, about 100 lines export.

    Has anyone else seen something like this?  Again, it's not the BI view that is missing lines - it's just when it exports to Excel.



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


  • 2.  RE: BI Explorer not exporting all lines - not even close

    Posted 02-12-2025 08:51

    @Beth Bowers I'm not a network person, but I do believe Microsoft has the ability to "limit large exports" by network user in Network Policies.  Your login may be set to a "administrator" account without a limit.  I wonder, if they share with you their User ID and Password (they can change Password later); if you log in as them if you experience the same "limit" in export size?  I googled:  how to limit large exports by network user Microsoft  and it returned some additional details. 



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 3.  RE: BI Explorer not exporting all lines - not even close

    Posted 02-12-2025 08:53

    @Madeline Stefanou - interesting. I'm going to run that by SWK.  THANK YOU!



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



  • 4.  RE: BI Explorer not exporting all lines - not even close

    Posted 02-12-2025 12:38

    Here's another thought. Are you exporting the same BIE view setting (public or private) as them or just exporting the standard one? Let's say they had saved their own setting but also added a filter to it (e.g. Div = 02 or Invoice Amount >= 10,000). This would limit the rows but as long as they see more than a screenful of rows they may not realize it's limited until they export to Excel. Farfetched I know.



    ------------------------------
    Alnoor Cassim
    Accounting Systems, Inc. (ASI)
    ------------------------------



  • 5.  RE: BI Explorer not exporting all lines - not even close

    Posted 02-12-2025 13:02

    Unfortunately, @Alnoor Cassim, it's the exact same one - I just created it to match.



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