Due to scheduled maintenance, some areas of our site are currently inaccessible. Thank you for your patience.

Please reach out to sales@eonesolutions.com with any questions.


You are not allowed to have negative actual quantity importing Project Accounting Timesheets

Published: Sep 26, 2017
Post Author Written by David Youngquist

Importing Project Accounting Timesheets using SmartConnect and receiving an error that says, “Error Number = 1256 Stored Procedure= taPATimeSheetLineInsert Error Description = You are not allowed to have negative actual quantity”

What typically causes this is importing a batch of timesheets, deleting the batch, and then importing them back in again.  In order to resolve the issue, you need to do a check links of the PA Timesheet Transactions tables.  To do this, login to GP and go to Microsoft Dynamics GP – Maintenance – PA Check Links.  When the PA Check Links window opens, highlight the “PA Timesheet Transactions” table, and click the insert button to move the table to the right side of the window.  Then click the OK button to run the check links.

After running the check links you should be able to import the batch again without receiving an error.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.