Sage 100

 View Only

  • 1.  Client trying a BIE IM View (2016). They have add

    Posted 06-08-2017 09:29
    Client trying a BIE IM View (2016). They have added the extended description text field to the view. It views normally in BIE but when exporting to Excel, the extended description text is not holding the cell position so fields are shifting. Any work arounds for this? Would seem to be an export issue in BIE.


  • 2.  RE: Client trying a BIE IM View (2016). They have add

    Posted 06-08-2017 09:47
    Export to CSV seems to work fine.


  • 3.  RE: Client trying a BIE IM View (2016). They have add

    Posted 06-08-2017 16:34
    Did they press the Enter key while entering these Extended descriptions? Maybe the BIE export doesn't strip the CR+LF


  • 4.  RE: Client trying a BIE IM View (2016). They have add

    Posted 06-08-2017 16:36
    ^^ exported to csv and opened in Excel, worked fine. Export direct to Excel, the extended description ended up on it's own line under the item number. Yes, @AlnoorCassim used a hard return in the ext desc when testing.


Related Content