First read this topic: Before you Upgrade.
The Costs for all the Estimates on a Quotation can be viewed by clicking the Menu button above the Items grid and selecting ‘Costs’ - see image below:
Quotations, Sales Orders, Purchase Orders, Customer Credit Notes and Work Orders.
The upgrade script clears all the Planning Board tasks that are linked to Sales Orders.
Estimates - Linked Materials - Linked Materials can now be added, updated and deleted directly inside an Estimate on Pre-press, Finishing and Packaging services.
Transactions - The Subtotal, VAT and Total (Inc) have been removed from the transaction footers in favour of using the Item Grid Totals - see image below:
Fixed Price / Fixed Cost - A Fixed Price (and Fixed Cost) where applicable has been added to the Transaction Items on the following Transactions:
The fieldname is TOTALVAT_TEXT - see image below:
Production fields (Speed, etc.) have been added to Quotation Items (See image below). The production values update the Hr/s field and are copied through to the Sales Order and Work Order.
The production values don’t update pricing on Quote and Sales Order Items.
VAT Types have now been implemented in all the accounting modules and the VAT is now calculated at an Item level - see image below:
In the transactions, the Total (Exc), VAT and Total (Inc) fields are simply totalled to the corresponding fields in the Transaction Header.
The VAT was calculated on the Transaction total before - this could cause minor rounding differences when existing transactions are re-saved.
The upgrade script will add the standard VAT Types - see image below. VAT Types can be updated in Main Menu > Setup > Settings & defaults > Accounting > VAT Types.
The default VAT Type for each module also need to be set in General Settings > Accounting.
Ledger Transactions that are created by other modules (eg. Customer/Supplier Invoices) won’t have a VAT Type in the Ledger, because the VAT is set on the Transaction Items.
Functionality has been added to improve the way that opening balances are loaded for General Ledger accounts. Accounts Receivable and Payable should be loaded as Customer and Supplier Invoices directly in the Ledger - ideally 1 invoice for each Ageing period: 30 days, 60 days, etc.
Create an Entry Type for Opening Balances as per the screenshot below. The Type = OB is the flag that will exclude these transactions from showing up when the Trial Errors filter is used. This means the opening balance transactions can be ‘single-entry’ - only the Debit or Credit account needs to be set.
Below is a simple example of an opening Trial Balance that need to be captured as well as screenshots of some of the opening balance transactions.
Cash (Debit)
Inventory (Debit)
Loans
All Transactions
Make sure the Trial Balance matches exactly the last Trial Balance from the old system.