Here's a way to do a 'quick and dirty' balance sheet or income statement in FRx. Unless you use Advanced Financial Analysis for your financial statements, you may not realize that you can use GP Account Categories in FRx. In an FRx row format, open the Link to GL window.
* click image to enlarge
Select the 'Account Type' radio button and note how the account definition window changes. Select the Account Type (equivalent to GP Account Category) appropriate for the row. In this example, we're setting up an income statement and making the first row 'Product Sales' so Account Type 31 is used.
* click image to enlarge
Note that the Link appears with '/A' at the end. This identifies the entry as an Account Type as opposed to an Account Code. One caveat with using the Account Type for report definition - your Account Categories in GP must be assigned properly when setting up you chart of accounts!
Another caveat with using the Account Type in FRx is if customized account categories are used in GP, they will not be available in FRx since an index number is not assigned, by default, to new categories.
ReplyDeleteThanks for the input Lisa! I tested this and although GP doesn't show an index in the Account Category Setup window, an index is assigned in the Account Category table. FRx doesn't recognize the new account index in the Account Type selection window, but you can type the Account Type in the GL Link field in the Row Format. Not so elegant, but it works.
ReplyDelete