We are in the process of upgrading to Sage 100 Premium.  Can anyone help me re-write these SQL Queries from our old version of MAS200?  The table names and fields have changed and some of the fields are no longer in the master tables.  Any help is appreciated.

Thanks,

Tommy

For Vendor:

SELECT VendorNumber, PurchasesPTD, PurchasesYTD, PurchasesPYR, PaymentsPTD, PaymentsYTD, PaymentsPYR, DiscountsTakenPTD, DiscountsTakenYTD, DiscountsTakenPYR,

DiscountsLostPTD, DiscountsLostYTD, DiscountsLostPYR, LastCheckAmount, PurchasesNextPeriod, PaymentsNextPeriod,

DiscountsTakenNextPeriod, DiscountsLostNextPeriod From AP1_VendorMaster

For Customer:

SELECT CustomerNumber, UnpaidServiceChrgYTD, SalesPTD, SalesYTD, SalesPYR, COGSPTD, COGSYTD, COGSPYR, CashReceivedPTD, CashReceivedYTD,

CashReceivedPYR, FinanceChrgPTD, FinanceChrgYTD, FinanceChrgPYR, NumberOfInvoicesPTD, NumberOfInvoicesYTD,

NumberOfInvoicesPYR, NumberOfFinanceChargesPTD, NumberOfFinanceChargesYTD, NumberOfFinanceChargesPYR, BalanceForward,

CurrentBalance, Over30Days, Over60Days, Over90Days, Over120Days, UnPaidServiceChrgNextYear, SalesNextPeriod, COGSNextPeriod,

CashReceivedNextPeriod, FinanceChargesNextPeriod, NoInvoicesNextPeriod, NoFinanceChargesNextPeriod

FROM AR1_CustomerMaster