Project Accounting View

By Tracey BrinkmanMicrosoft Dynamics GP, , With 0 comments

By Ryan McBee   IF EXISTS (SELECT type,name FROM sysobjects WHERE name = ‘PACosts’ AND type = ‘V’) DROP VIEW PACosts GO ——————————————————————– CREATE VIEW PACosts AS   SELECT¬† ‘Timesheet’ AS DocumentType, ‘ ‘ as VendorInvoice, dbo.PA10001.PAPROJNUMBER AS ProjectNumber, LTRIM(RTRIM(dbo.PA10000.PATSNO)) + ‘-‘ + CONVERT(VARCHAR(10), dbo.PA10001.LNITMSEQ) AS DocumentNumber, dbo.PA10001.PACOSTCATID AS CostCategory, ‘LABOR’ AS Item, ‘Labor’ as

Read More