Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #11827
    DJobin
    Participant

    I need to export a set of books for CRA.

    Has anyone done this?

    What is the best way of doing this?

    #14112
    MSchappler
    Moderator

    Copy the source application database file and then paste it to a target location of your choosing and then rename the target application database file to an appropriate name. Open your workstation and add a row and select the application database under the file column.

    Before entering the target application database, right mouse click Tools > Script Evaluate > and select the following script:

    nv2.exe > system > database_id_set.qw_script

    Select the target database and click OK.

    Enter the target application database and perform the default setup and then re-enter the application database. Remove the transactions from NewViews > Account > Ledgers that you do not wish to be shown using Block > Delete.

    Regards to All,

    Martin

    #14113
    DJobin
    Participant

    Martin,

    This is good as a first step. But the next step is more complicated.

    CRA wants the data in one of the following formats:

    ASCII, fixed length
    ASCII CSV
    MS Access
    MS Excel
    DBF
    ASCII print report

    #14114
    MSchappler
    Moderator

    You can use Print > Account Ledgers on your accounts (NewViews > Account > AP and etc ..) and then Set the destination to display which will show the data in Excel. From Excel you can save the spread sheets to files that you can then forward to CRA.

    I suggest that you review the Select Columns button in Print > Account Ledgers to choose the columns for your output to Excel.

    Regards to All,

    Martin

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.