Loading...

Purchase Order Accruals

Comments

4 comments

  • Kris Corrigan

    Hi 

    For Purchase Accrual Journal Entries how can we easily export this to excel, previously we used the tasks and EBMSEZExport, in V30 I have a option under Tools to export however I am being asked for the format ID and then a file, is this the way of exporting this to excel or is there an another way?

    Thanks

    Kris

  • Maggie U.

    Hi Kris,

    Thanks for the screen shot - that helped me better understand your process. This process uses GL Export Formats to export the journal entry. Export Formats allow you to configure how the export file is created - the order of the columns and the information that is placed into each column. This is so the file is prepared for an import into another system. You can create export formats from the GL Posting Export Format screen. 

    Thanks,
    Maggie

     

  • Maggie U.

    Hi Kris,

    Sounds like you are selecting an import option rather than an export option. If you select Tools - > Export to Excel, you'll receive the standard export prompt to export all entries or selected entries and to choose to export as XML:

    Thanks,

    Maggie

  • Kris Corrigan

    Thanks Maggie 

    I don't see the export to excel, the export option I was referring to was 'Export Journal Entry' (as shown below)

    Kris

Please sign in to leave a comment.