Monthly Archives: June 2013

How to set the Row Limit in SSRS report

Implement the Query rowLimit parameter:

<RSSharePointList xmlns:xsi=”” xmlns:xsd=”“>
  <ListName>Help Desk Requests</ListName>
    <Parameter Name=”rowLimit”>
    <FieldRef Name=”Title” />

Great Plains: You are not allowed to have negative Actual Quantity

When trying to put negative time in Great Plains project accounting in the Timesheet Entry screen, you get the following error:  “You are not allowed to have negative Actual Quantity”.GP-ActualNegative






This is caused in our environment because we import time directly into Great Plains tables, but are not updating the ‘PA Budget Master File’ table (PA01301).

I reset the values in the budget table to arbitrary positive numbers:

update  bccon..pa01301 set
where patu=1 and paprojnumber=’Project Number’


This solution fixes more than just the Actual Quantity.  The field for the Actual Quantity is PAUnpostedQty.