Received/Not Invoiced report in Reports--Purchasing--Analysis the report was showing transactions in POP Received/Not Invoiced. Instead Matching the Invoice for those Receipts user created other Invoices and correct the Accrual Journal Entry of the Received Transactions.


Now the problem is Inventory Qty and GL A/c Balance is right…

I ran into an interesting scenario this week. A client (who we'll call X) provides a device to it's end user companies and provides services around that device. At the end of the service term, the end gets to keep the device. Because of this, some end users ask to purchase a manufacturers extended warranty through client X.

This an interesting example of the SOP to POP functionality. Client X is shipping a device from their…

Last week we looked at counting Payable Transactions in Dynamics GP by week. This week, we are moving on to counting Purchase Orders. The idea behind this series is to give managers a sense of the transaction volume and timing to better manage this function. For AP, a transaction is pretty much a transaction. Not so for P.O.’s. A hundred line P.O. can takes much longer to create than a 10 one line P.O.’s so the measures of volume are number of P.O.’s, number of P.O. lines and number of invoices matched.
There are 2 views in here, one for P.O.’s  and one for Invoice matching along with 3 queries, P.O's, P.O. Lines and Invoice Matching. As before, all of these are by week with a week starting on Friday. Simply reorder the days in the view to changes the week starting date.

Buy the Microsof Dyamics GP 2010 Cookbook

This is also available for download at http://www.box.net/shared/39q0rmbz09
--View for Purchase Order Receipts
--View is needed to combine work and history Receipts
Create view Metrics_PORec as
select Case 
when datename(weekday,receiptdate) = 'Friday' then receiptdate
when datename(weekday,receiptdate) = 'Saturday' then dateadd(Day,6,receiptdate)
when datename(weekday,receiptdate) = 'Sunday' then dateadd(Day,5,receiptdate)
when datename(weekday,receiptdate) = 'Monday' then dateadd(Day,4,receiptdate)
when datename(weekday,receiptdate) = 'Tuesday' then dateadd(Day,3,receiptdate)
when datename(weekday,receiptdate) = 'Wednesday' then dateadd(Day,2,receiptdate)
when datename(weekday,receiptdate) = 'Thursday' then dateadd(Day,1,receiptdate)
else '01/01/1900' end as WeekEndDate,poprctnm ,
        receiptdate,
        'work' as status
    from pop10300
    where poptype=1
union
select  Case 
when datename(weekday,receiptdate) = 'Friday' then receiptdate
when datename(weekday,receiptdate) = 'Saturday' then dateadd(Day,6,receiptdate)
when datename(weekday,receiptdate) = 'Sunday' then dateadd(Day,5,receiptdate)
when datename(weekday,receiptdate) = 'Monday' then dateadd(Day,4,receiptdate)
when datename(weekday,receiptdate) = 'Tuesday' then dateadd(Day,3,receiptdate)
when datename(weekday,receiptdate) = 'Wednesday' then dateadd(Day,2,receiptdate)
when datename(weekday,receiptdate) = 'Thursday' then dateadd(Day,1,receiptdate)
else '01/01/1900' end as WeekEndDate,poprctnm,
        receiptdate,
        'hist' as status
    from pop30300
    Where Poptype=1
-------------------------------------…