Added Order By pop-list and Descending flag to the Account Inquiry section of this screen. Invoices can be displayed in order of Enterprise, Dr/Cr number, Type, Transaction Date, Original Amount, and Current Balance. The Descending flag determines whether the information is displayed in ascending or descending order.
Modified to optionally display invoices from financial enterprises other than the logged in enterprise. When the SHOW_INTER_COMPANY_INVOICES_AR parameter in program MURM, Initialization Parameter Maintenance, is set to Y, invoices from all financial enterprises will be displayed. When the parameter is set to N, only those invoices from the logged in enterprise will be displayed.
On the Activity Inquiry screen (page 4), added an Order By pop-list, Descending flag, and Suppress Zero Balance Invoices flag to the lower block. Invoices can be displayed in order of Default (Original Invoice date, Original Invoice Number, Invoice Date), Enterprise, Dr/Cr number, Reference, Type, Invoice Date, Original Balance, Current Balance, Debit Amount, and Credit Amount..
The Descending flag determines whether the information is displayed in ascending or descending order.
The Suppress Zero Balance Invoices flag determines whether invoices with a zero dollar balance are displayed.
Added the Contacts Tab, Total Customer Tab, and Enterprise Details Tab to the Customer Credit Inquiry screen.
Customer contacts can be viewed on the Contacts Tab. Contact information includes the contact name, ship to code, email address, recipient flag setting, primary flag setting, notes, user 1 through 4 fields, notes, and phone numbers.
The Total Customer Tab allows you to view credit information for the customer that will be applied in all enterprises for which the customer is valid. The total customer credit information includes the credit limit, available credit, recent high credit, maximum high credit, recent high date, maximum high date, open A/R balance, amount on deposit, open order balance, hold order balance, date last payment, order limit, order discount percentage, required margin percentage, labor rate code, minimum return amount, minimum AFC order value, last shipped date, last ordered date, check last paid, and amount last paid.
The Enterprise Details Tab allows you to view credit information for the customer for the logged in enterprise. The Enterprise Details Tab is only available if the customer has had information entered for this enterprise in program CMMM, Customer Master Maintenance. The enterprise credit information includes the credit limit, available credit, recent high credit, maximum high credit, recent high date, maximum high date, open A/R balance, amount on deposit, open order balance, hold order balance, date last payment, order limit, order discount percentage, required margin percentage, labor rate code, minimum return amount, minimum AFC order value, last shipped date, last ordered date, check last paid, and amount last paid.
Added new multi-select form for processing multiple accounts receivable batches. This program will only display and process batches for the current logged in user.
If you are using the arca.sql file to calculate customer aging overnight, the script will calculate aging as of the system date for all financial enterprises.
If you are using the arca.sql file to calculate customer aging overnight, the script will calculate aging as of the system date for all financial enterprises.
Added new multi-select form for processing multiple accounts receivable batches. This program will only display and process batches for the current logged in user.
Made the following changes to bad check processing.
General ledger journals are no longer generated when the bad check is entered. The accounts receivable postings are created and must be run through program GLRJ, Move Accounts Receivable Journal Transactions, and GLJP, General Ledger Journal Transaction Posting, to be posted to the general ledger. The journal information has been removed from this program for this reason.
The check date, date returned, and check amount are no longer able to be updated after save because it will affect the posting amounts.
All entries made in this program are made in the local currency, even if the original check was in an alternate currency.
Bad check processing includes the following:
Creates an accounts receivable record when a bad check is entered or deleted.
The invoice number for the bad check is NSF followed by a generated invoice number.
Entries are made in the accounts receivable posting detail tables (viewed in program ARHQP, General Ledger Postings Detail History Inquiry).
Only checks for the logged in financial enterprise and manufacturing enterprise can be viewed in this program.
When a check is deleted, then the original NSF record has its total pay update to include the original amount from the deleted record, sot that the two accounts receivable records for the check offset each other.
The accounts receivable batch number for bad checks is the same as the generated invoice number.
Added new multi-select form for processing multiple accounts receivable batches. This program will only display and process batches for the current logged in user.
Reprint information about cash entry batches that have been processed through program ARCR, Cash Receipts Registers and Update. You must know the batch number to run this report.
If you are archiving your accounts receivable records when you run program ARPG, AR Posted Journal Purge, then the archived records are also displayed in this program. Purged records are archived when the ARPG_ARCHIVE_RECORDS parameter is set to Y in program MURM, Initialization Parameter Maintenance.
When the parameter OE_VAL_SRC_DOC is set to N in program MURM, Initialization Parameter Maintenance, the Src Doc Type and Src Doc ID fields can be modified by the user.
Added new [VeriSign™ Response] 
button to view the codes sent back from VeriSign™ or VisaNet™ when the credit card was authorized.
The setting of the COMMENT_LOV_ARIE parameter in program MURM, Initialization Parameter Maintenance, determines whether the boilerplate list of values or a field editor will be displayed when the user double-clicks in the comment text field in this program. See the Comment Lists of Values in Sales Order Entry section for more information.
Added Freight Cost and Inv fields on Maintain Container List screen. Clippership now allows maintenance of the freight cost and invoiced by container.
The weight fields in this program have been modified to use the new 5 decimal place weights and weight rounding. See Item Weight Rounding for more information.
If the unit price is greater than the list price, a warning may be displayed, depending on the setting of the OE_LIST_PRICE_WARN parameter in program MURM, Initialization Parameter Maintenance. If the parameter is set to Y, then a warning will be displayed.
Added the ability to swipe a credit card when the cursor is in the Card/ABA/Instr/Cert field and have it fill in the appropriate information.
Added additional sales order line information to the Other Details screen.
Reformatted Addresses screen. Added new zip code formatting/validation feature. For more information, see program SPNM, Country Code Maintenance.
Added fields for VeriSign™ and VisaNet™ CVV code processing.
The sales location now defaults according to the Default Location Rule pop-list in program SPON, Order and Invoice Number Control, for the financial enterprise.
When changing a sales representative with the product commission scheme in the header, you will be prompted as to whether you wish to update the sales order lines that had the old sales representative to the new sales representative. The default commission code will be determined according to the sales representative settings in program SMMM, Sales Representative Master Maintenance.
The quantity available for kit items is the total number of kits that can be built at this time according to the kit component availability.
Added two new flags: Soldto Contacts use Shipto Address and Ship Contacts use Soldto Address.
When the Soldto Contacts use Shipto Address flag is set to on, and contacts are being automatically created and assigned to mail to addresses, the newly created sold to contact will be assigned to the mail address for the ship to address for the customer.
When the Ship Contacts use Soldto Address flag is set to on, and contacts are being automatically created and assigned to mail to addresses, the newly created ship to contact will be assigned to the mail address for the sold to address for the customer.
If parameter AFC_FROM_PRICING_LOC is set to Y in program MURM, Initialization Parameter Maintenance, and the sales location Price From pop-list is set to Price Based on Customer Location, the AFC charges will be determined using the sales location assigned to the customer's record.
Modification to Price From pop-list definition. When set to Price Based on Customer Location, the price will be calculated according to the plant assigned to the sales location that is assigned to the customer in program CMMM, Customer Master Maintenance. The catalog ID is also taken from the customer location. If the customer's sales location has the Price From pop-list set to Price Based on Specific Plant, the price will be calculated from the Price Plant assigned to that location.
New Make BO Ship Complete flag on the Order Entry tab. When this flag is set to on, all backorders for this sales location will be created with the Ship Complete flag set to on when program OESJ, Sales Order End of Day and Journals, is run.
New Merge Orders flag. When this flag is set to on, any sales orders entered for customers with the Merge Orders flag set to on in program CMMM, Customer Master Maintenance, will be delayed from batch shipment with program OESB, Sales Order Batch Shipping, until the merge time specified in the Merge Time field.
New Merge Time field. Enter the time of day that the merged sales orders should be released to shipping with program OESB, Sales Order Batch Shipping.
The value entered in this field should be entered for a 24 hour clock. For example, 3:00 PM would be entered as 15:00.
This time is only used if the Merge Order flag is set to on for the sales location.
Modified to optionally display invoices from financial enterprises other than the logged in enterprise. When the SHOW_INTER_COMPANY_INVOICES_AR parameter in program MURM, Initialization Parameter Maintenance, is set to Y, invoices from all financial enterprises will be displayed. When the parameter is set to N, only those invoices from the logged in enterprise will be displayed.
Added record counts for unposted entries before the purge date, number of records to be deleted, all posted records for the enterprise, and records actually deleted.
If the ARPG_ARCHIVE_RECORDS parameter is set to Y in program MURM, Initialization Parameter Maintenance, when this program is run, the purged records will be archived instead of being deleted from the database.
Modified purge to move the accounts receivable records to an accounts receivable history table instead of deleting them from the system.
New program used to view detailed information about each invoice.
New program used to print a report listing the accounts receivable journals that were posted to the general ledger for a specific date and prints the posting information with the accounts receivable batch information to make sure that the accounts receivable sub ledger matches the general ledger postings. This report can be run for any date.
If the sub ledger totals for the batches do not match that of the journal entry, then a warning message is printed and the differences are shown.
If the sub ledger batches cannot be found, a warning is printed.