Resolved Programming Issues Build 407
Project Number DBA Menu Fix Build Summary
P407 GL>General Ledger 407.0.0 Redesign of GLFILE table to streamline data and improve transaction tie backs
P407 Backup Manager 407.0.0 20-35 percent reduction in database size when perform backup and restore after update
P407 GL>General Ledger 407.0.0 New GL_BALANCE table maintained by triggers  to help us dramatically improve the speed of balance account calculations
P407 GL>Analysis and Reports 407.0.0 Improved cross reference information in Analyis screens and Reports
P407 Purch>PO Invoice 407.0.0 New table to handle PO Invoice and Supplier Invoice reversal transactions
P407 Sales>Sales Invoices 407.0.0 Sales and COGs GL posting tie back to sales invoice in data views and SO Inquiry 
P407 Purch>PO Receipts 407.0.0 Purchase GL exception posting tie back to PO Receipt data views and PO Inquiry screen
P407 Purch>PO Detail 407.0.0 New Ref Type field to improve the purpose of the PO related postings
Issue Number DBA Menu Fix Build Summary
DBA-1142 Purch>PO Receipts 407.0.0 PO Receipt - Batch History tab - Label button grey incorrectly
DBA-1201 GL>Reports 407.0.0 Provide option for print to file to display a negative sign instead of a parenthesis
DBA-1504 GL>GL Setup>Account Assignments>Purch 407.0.0 SHIP type descriptors not using purchase exception account specified
DBA-1617 Inventory>Stock Items>Detail 407.0.0 MRP Level not gettting updated correctly when a parent M item is set to inactive
DBA-1671 GL>Journal Entry 407.0.0 Prevent unbalanced journal entry when transitioning from Journal Entry screen to new customer creation
DBA-1672 Sales>Order Picking 407.0.0 Order Picking return allows you to return more than you picked on some operating systems
DBA-1774 Sales>Late Supply 407.0.0 Late Supply can peg to the earliest demand event even when it has been covered by new supply
DBA-1920 Purch>PO List 407.0.0 Improve messaging for default printer error messages launching PO list screen
DBA-1923 PO>Invoice 407.0.0 PO Invoice lines of SHIP descriptor should post to GL Purchase Exception account
DBA-1924 GL>Analysis and Reports 407.0.0 Mercant Account transfer fees cross reference not showing up in reports and screens
DBA-1928 GL>General Ledger 407.0.0 GLFILE database changes to streamline and increase speed of queries
DBA-1929 GL>General Ledger 407.0.0 GL_TRXNTYPE database changes to accommodate numeric value in GLFILE
DBA-1930 GL>Analysis 407.0.0 New stored procedure for report tie backs in Analysis screens
DBA-1931 GL>Reports 407.0.0 New stored procedure for report tie backs in printed reports
DBA-1932 GL>Reports>Journal Report 407.0.0 Journal Report significant improvements
DBA-1933  GL>Reports>Transaction Listing 407.0.0 GL Transaction Report significant improvements
DBA-1934 GL>GL Setup>Account Assignments>Purch 407.0.0 Misc Purchase exceptions by descriptor link GLFILE transaction to PO receipt record
DBA-1935 GL>GL Setup>Account Assignments>Sales 407.0.0 Sales and COGs exception by item category link GLFILE transactions to SO invoice record
DBA-1936 Purch>PO Details 407.0.0 New PO Ref reporting field
DBA-1939 GL>Batch Posting 407.0.0 Speed up and clean up GL Batch Posting process
DBA-1940 Inventory>Analysis>Transactions 407.0.0 MRPSetting fields should only be in the customize box when using monthly trend columns
DBA-1943 Purch>PO Details 407.0.0 PO Details descriptor lookup improvements
DBA-1944 GL>GL Setup>Account Assignments>Purch 407.0.0 Account assignments PO exceptions by descriptor improvements
DBA-1945 Job>Job Details and BOM>Components 407.0.0 BOM Component and Job Detail descriptor lookup improvements
DBA-1946 Sales>SO Details 407.0.0 SO Details descriptor lookup improvements
DBA-1947 Inventory>Descriptors 407.0.0 Descriptor list screen improvements
DBA-1948 Purch>PO Invoice 407.0.0 RNI and closed variance values or Ship Descriptors should be zero on reports and inquiries
DBA-1954 Purch>PO Invoice and AP>Supplier Invoice 407.0.0 New table for PO Invoice and Supplier Invoice reversals
DBA-1955 Purch>PO Schedule 407.0.0 PO Schedule improvements
DBA-1956 Job>Job Routing 407.0.0 Subcon PO line notes are cleared when Traveler notes are changed
DBA-1957 GL>Batch Posting 407.0.0 Convert LEDGERTRANS into a temporary table that is cleared after GL batch posting is completed
DBA-1960 Invnetory>Inventory Setup>Item Categories 407.0.0 Add Sales and COGs GL exceptions to Item Category list screen
DBA-1961 MRP>MRP Settings and Inventory>Stock Status 407.0.0 Add MRP Level to MRP Settings and Stock Status screens
DBA-1962 GL>General Ledger 407.0.0 New GL_BALANCE table to drive faster Balance Sheet performance
DBA-1963 GL>Analysis>Balance Accounts 407.0.0 Speed up GL Balance Account analysis calculations 
DBA-1964 GL>Trial Balance 407.0.0 Speed up GL Trial Balance
DBA-1966 GL>Analysis>Profit and Loss Accounts 407.0.0 Change expense display to negative for Profit and Loss Analysis to support a multi period income statement
DBA-1967 BOM>Component Replace 407.0.0 MRP Level not getting updated correctly when using the component swap under certain conditions
DBA-1968 GL>Analysis 407.0.0 GL lookup improvements - focus only on accounts that have transaction history
DBA-1970 Purch>PO Receipts 407.0.0 Reversal of PO Receipt leaves REFID field blank in PORECS
DBA-1971 Customer>Customer>List 407.0.0 Redesign of customer history screen with active links to SO Inquiry screen
DBA-1972 Invnentory>Stock Items>List 407.0.0 Added Sales history by item to the item history screen
DBA-1973 Screen Output to Excel 407.0.0 Grid output to Excel are not including the total summary values when data is grouped
DBA-1975 Sales>Invoices 407.0.0 Invoice incorrectly reports open deposits that have already been applied
DBA-1977 Sales>Invoices 407.0.0 Order Picking return - validation problem with down arrow
DBA-1982 Inventory>Stock Items>Detail 407.0.0 Added lead days inquiry button for M items (including one off items) in the Stock Detail tab