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>
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”.
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.
From SharePoint PowerShell:
Set-SPUser -Identity “DOMAINusername” -Email “email@yourdomain.com” -Web “http://yourdomain.com”