Monthly Archives: June 2013

How to set the Row Limit in SSRS report

Implement the Query rowLimit parameter:

<RSSharePointList xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema“>
  <ListName>Help Desk Requests</ListName>
<Query>
<Parameters>
    <Parameter Name=”rowLimit”>
        <DefaultValue>9999</DefaultValue>
    </Parameter>  
</Parameters>
</Query>
 <ViewFields>
    <FieldRef Name=”Title” />
   </ViewFields>
</RSSharePointList>

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

 

 

 

 

Resolution:

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
papostedqty=’500′
,PAUnpostedTotalCostN=’5000′
,PAUnpostAccrRevN=’5000′
,PABilled_QtyN=’5000′
,PAApproved_Quantity=’5000′
,PAUnpostedQty=5000
where patu=1 and paprojnumber=’Project Number’

 

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