01344 645950
 

Making I.T. Happen
Accounting and Information Technology, Assistance and Support
 What's new in Sage 50 Accounts 2012 Database ?

 

The changes are few.  Here they are, 2 new tables and some odd bits for VAT numbers and the new Date Lock

Field Table Function
ISP_REFERENCE AUDIT_HEADER INV/SOP/POP Reference
OVERRIDDEN_CLOSED_LEDGER_DATE AUDIT_HEADER Indicate when the closed ledger data has been overridden
ADDRESS_ID  COMMUNICATION_ADDRESS ??
CLOSED_LEDGER_DATE_ENABLED COMPANY Flag to indicate Closed ledger function is in use
CLOSED_LEDGER_CHECK_DATE COMPANY The cut off date for the closed ledger function
ADDRESS_4 ECSALES_HEADER
ADDRESS_5 ECSALES_HEADER
BALANCE  FUND
OPENING_BALANCE FUND
VAT_REG_NUMBER  INVOICE Looks like this is to accommodate customers with multiple VAT registrations so that the number can be stored in each invoice
USED_FOR_CUSTOMERS LETTER_TYPE
USED_FOR_SUPPLIERS LETTER_TYPE
VAT_REG_NUMBER  PURCHASE_ORDER Looks like this is to accommodate suppliers with multiple VAT registrations this is a mirroring of the change in INVOICE Table
VAT_REG_NUMBER  SALES_ORDER Looks like this is to accommodate customers with multiple VAT registrations so that the number can be stored in each invoice
INTRASTAT_IMPORT_DUTY_CODE  STOCK
ISP_REFERENCE STOCK_TRAN INV/SOP/POP Reference

New Tables
VAT_BOX  RTD_SUMMARY 
VAT_BOX_NAME RTD_SUMMARY 
TAX_CODE  RTD_SUMMARY 
AMOUNT_INVOICE  RTD_SUMMARY 
AMOUNT_CREDIT  RTD_SUMMARY 
AMOUNT_BANK  RTD_SUMMARY 
AMOUNT_JOURNAL  RTD_SUMMARY 
AMOUNT_REFUND  RTD_SUMMARY 
AMOUNT_DISCOUNT RTD_SUMMARY 
HEADING_INVOICE RTD_SUMMARY 
HEADING_CREDIT  RTD_SUMMARY 
HEADING_BANK  RTD_SUMMARY 
HEADING_JOURNAL  RTD_SUMMARY 
HEADING_REFUND  RTD_SUMMARY 
TYPE_ID  PROJECT_RESOURCE_TYPE
NAME  PROJECT_RESOURCE_TYPE
RECORD_CREATE_DATE PROJECT_RESOURCE_TYPE
RECORD_MODIFY_DATE PROJECT_RESOURCE_TYPE
RECORD_DELETED PROJECT_RESOURCE_TYPE
 


Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!
Copyright © Making I.T. Happen 2011