Enhancements to Pacioli/400 Accounting Suite Version II

Last Update: 03/12/2008 Release 02.362

 

NOTE: Release 02.362 is the last release at V5R1M0 of the iSeries Operation System.  Future fixes, updates and releases will be at V5R2M0 effective 3/12/2008.

 

This is a List of Enhancements the Pacioli software.  These enhancements are available in the current release of the application. Please see document Updates to Pacioli/400 Accounting Suite Version II for a complete list of all the updates with instructions on obtaining the current release.

 

Where a menu option can be referenced for an update, the following convention is used: Menu Name/Opt/Opt/Option Text.  Menu Name refers to the first menu displayed when you start Pacioli/400 normally.  /Opt indicates that you are to take that menu option, or options in succession.  NOTE: you will not see the option on the menu if you are not licensed to that option or if you are not authorized to that function within a licensed application.  /Option Text refers to the final menu option for the function with the update. For example PACIOLI/1/1 Work with Company Setup tells you to take option 1 from menu PACIOLI and then take option 1 (if shown) from menu PXAMNU.

 

Release

Reference

Description

02.362

AL08009

G/L

Enhanced:

1. Work with Journals.  Added option “S=Copy to Standard.  Allows the user to copy any journal in the list to a Standard Journal. 

02.350

AL07028

A/P

G/L

Enhanced:

1. Work with Vendors – Balance Due Find: line >, >=, <, <=, = and <> enabled on the amount due.

2. GL Account Inquiry – when viewing detail activity, new option 8=Journal lists the journal for the selected line item.

3. GL Period Close – F6 to work with open journals preventing close, F7 to work with standard journals and F10 to work with the current and next year calendars. 

02.342

AL06023

A/P

Condition:

PACIOLI/3/3 Work with Check Writing, Option 9=Reconcile.

Enhanced:

Add report option “Print Reconciled Checks Only”.  Default is Yes.  Force Save = Yes for Report Options.

02.342

AL06012

A/R

Condition:

PACIOLI/4/6 AR Period Close.

Enhanced:

Print both AR Summary Trial Balance and Detail Trial Balance.  Force all Closing report output to SAVE = YES. Audit Closing (who and when).

02.342

AL06010

CV

P/L

Condition:

PACIOLI/1/1 Work with Company Setup.

The Division / Department template configuration was confusing.  Also, users requested the ability to ‘reset’ the division and/or department values for all accounts.

Enhanced:

Screen FS3026 redesigned and now shows a sample account code in both internal and external format.  The help text has been rewritten.  Also, there is now an option for both the Division and the Department to clear, reset or leave as is.

02.340

AL06014

A/P

Enhanced:

·      Work with Bank Accounts: Add option 9=Test Check Format to print the alignment check on the defined printer.  Allows you to verify the check setup.

·      Work with Bank Accounts: Enhanced listing of Bank Account configuration.

02.339

AL06009
CV
P/L

Condition:

PACIOLI/5/2/2 Transfer MAPICS TEMGEN into ControllerVision II (ControllerVision).

PACIOLI/2/7/4 Post MAPICS Journals from TEMGEN (Power Ledger).

To assist in tracking (auditing) MAPICS journal entries, Pacioli now stores the 5-digit journal number and the 5-digit sequence number from the MAPICS Journal Reference ID in the “Notes” field in the Pacioli journal detail record.

Enhanced:

MAPICS journals are numbered xxnnnnnsssss where xx = source type (such as PJ or CR), nnnnn = the journal number and sssss = the sequence number within the journal.  The source type is stored in GLJDTLP/JVTYPT.  The 10-digit journal number and sequence number is stored in the character field GLJDTLP/NOTE.

02.339

AL06008

A/P

A/R

Condition:

Improvements in formatting international addresses.

Enhanced:

When displaying Customer and Vendor addresses, Pacioli shows up to 3 lines of address and a separate line for city, state/province code and zip/postal code (no punctuation, all uppercase with 2 spaces before and after the state/province code).  If the country code for the customer/vendor is different than the company’s country code, the country name (from the Work with Country Codes file) prints on the next line.

02.339

AL06005

P/L

Condition:

PACIOLI/2/7/61 Convert Balances and Journal Detail to Version 1.

Request to convert the current fiscal year and prior fiscal year balances and journals to Version 1 Power Ledger format in support of user legacy programs.

Enhanced:

The chart of accounts, balances and budgets are written to file GLMASTP.  Journal headers and details are written to GLHHDRP and GLHDTLP.  The target files are cleared of records for the company before new records are written.  Files GLJHDRP and GLJDTLP, if they exist, are cleared of records for the company.  The user can choose the library to write to.

02.339

AL06002

A/P

Condition:

PACIOLI/3/3 Work with Check Writing.

Enhanced:

Now supports FormFlex check print processing.  Part of the SpoolFlex family of products.

02.323

AL05022

A/R

Condition:

PACIOLI/4/5/1 AR Inquiry by Customer.

Enhanced:

Added second view containing account synopsis and list of open invoices with applied transactions included.

02.317

AL05003

P/L

Condition:

PACIOLI/2/5 GL Account Inquiry. F21=Detail.

Enhanced:

-       Roll Up / Roll Down enabled.

-       F16 Subset added.

-       5=Display all fields for a single entry.

o       Drill down to Pacioli A/R and A/P inquiries.

-       F10/F11 window right side of list to see additional fields

-       F21 print list added.

-       Net / Total Debits / Total Credits on display.

02.317

AL05002

P/L

Condition:

PACIOLI/2/1/1 Work with Journals.

Move a Journal to a different period.

Enhanced:

Users, authorized to “Post a Journal”, now have an option to ‘move’ an open journal to a different period.  Also, F5=Refresh has been added to the Work with Journals display.

02.316

A/R

Enhanced:

·       Added support for off-line batch entry of EDI 820 (Remittance Advices).  Payments are edited and loaded into a batch for review before applying the cash and posting the batch.

02.304

CV

P/L

Updates:

Added Column Code:

·       CHP01 Variance %: Current Period Activity Variance Current Year as a Percent of the Previous Period Activity.

02.301

*NEW*

In partnership with DRV Technologies, Pacioli/400 now includes SpoolFlex, software that gives companies the ability to capture AS/400 reports from their existing applications, transform that data into various formats such as PDF, HTML, Excel, XML and distribute electronically.  Call DRV Technologies at 770-674-1491 and request a trial license code.  DRV Technologies can assist you in getting up and running quickly.  Visit them on the web at DRV Technologies Spool Management Software for the AS/400 and iSeries.

02.272

AL03090

CV

P/L

Updates:

Added 2 Column Codes:

·      RCVCY Variance % - Current Period Activity Variance, Current Year, to Current Period Budget-2 Budget.  Similar to BCPCY for Budget-1 Budget.

·      RTVCY Variance % - Current Year to Date Activity Variance, Current Year, to Current Year to Date Budget-2 Budget.  Similar to BTPCY for Budget-1 Budget.

02.232

AL03073

CV

P/L

Condition:

PACIOLI/5/4/1 General Ledger Account File Maintenance (ControllerVision).

PACIOLI/2/4/1 Chart of Accounts File Maintenance (Power Ledger).

When working with the budgets by individual accounts, the user would like to “lock-in” the fiscal year and budget type.

Enhanced:

The user can now specify a fiscal year and budget type to work with and save these selections.

02.232

AL03071

CV

P/L

Condition:

PACIOLI/5/3/1 Request Financial Statements (ControllerVision).

PACIOLI/2/2/1 Print Financial Statements (Power Ledger).

Users want the ability to limit specific users to be able to only print some financial statement report requests.

Enhanced:

Individual users can be locked out of maintaining financial statement report requests but still be able to print selected report requests.  Users with special authority can now authorize other users to individual report requests.

02.229

AL03041

CV

P/L

Condition:

ALSHELPR/54 Move Converted CURHIS Journals to a Different Period (ControllerVision and Power Ledger).

After converting MAPICS closed period journals from the CURHIS file (menu ALPHELPR/52), the Version II user determines that one or more of these journals were posted to the wrong period.

Enhanced:

The assumption is that the only issue with the journal is the period.  Otherwise the journal is correct and all of the balances are correct for the periods involved.  This enhancement lists only those journals, which were converted from CURHIS, and allows the user to change the journal period to any valid period for the company.

02.228

AL03042

ALL

Condition:

PACIOLI/1/2 Work with User Profiles.

Request to provide 3=Copy function.

Enhanced:

Prompts for new user id and name.  Copies all User Functions, Company Authorizations and saved report options.

02.223

AL03023

CV

P/L

Condition:

Convert CURHIS from MAPICS DB/XA.  Menu ALSHELPR, option 52.  Users want to stagger when they bring individual companies into Pacioli/400.

Enhanced:

User now given a selection of companies to convert CURHIS.  One company is done at a time thus allowing users to stage implementing companies.

02.223

 

Enhanced:

·         ALSMENUR 31 Create Duplicate Environment.  Enhancement to allow user to create a duplicate of the active environment to be used for testing or training.

02.222

AL03013

P/L

Condition:

Request to go directly to Account Inquiry.

Enhanced:

If, upon starting Pacioli/400, a user is only authorized to Account Inquiry (Application = XA and User Function = ACCINQ) go directly to the Inquiry screen (skip all menus).  Upon exiting inquiry, return to the calling screen.

02.220

AL03004

Condition:

1099-MISC.  User does not have a means to manage the invoices coded as 1099 or to reset the vendor’s 1099 amount.

Enhanced:

Moved option 3 to build the 1099 payees to option 4 and added option 3 to work with the A/P vendor 1099 information.  The User Guide for 1099-MISC Support has been updated to reflect these changes and describe how to use the new function.

02.210

AL02010

Condition:

User imports or creates a regular journal and the journal should be an accrual journal.

Enhanced:

New option Work with Journals screen (GL20) allows user to convert an open regular journal to an accrual journal. Likewise, the user can convert an open accrual journal into a regular journal.

02.207

AL02013

Condition:   After converting Version 1 Power Ledger to the Pacioli/400 Accounting Suite, some journals were loaded to Version 1 P/L.  These journals need to be copied to Version II.

Enhanced:    Added command LODV1JRNL to import a single Version 1 P/L journal from Journal Entry.

 

***End of Document***