You’re offline. This is a read only version of the page.
450
I am using GP 9 on Windows Server 2003 R2. I am trying to insert timesheets via econnect using c#. All timesheets that are not for a fixed price project are inserted successfully. However when I attempt to insert a timesheet for a fixed price project I recieve this error:
Error Number = 1233 Stored Procedure taPATimeSheetLineInsert Error Description = PA WIP IDX Account does not have access to Currency ID
Node Identifier Parameters: taPATimeSheetLineInsert
Another thing that I noticed is that when I go to add a currency to an existing account no options are listed. I cannot add anything. (I assume this is because functional currency is set up but I thought it might be worth mentioning) We are not using Multicurrency, however Functional Curreny is set up and the compony does have access to the currency.
I am out of things I know how to try. This problem has me stumped. ANY help would be greatly appreciated. Thanks in advance!!! If you need anything else just let me know.
*This post is locked for comments
Hi Rob,
Hope it all works out for you.
Regards,
Hugh
So here is the answer, which I think is what you were getting at.
MC40200.CURRNIDX was not equal to MC40000.FUNCRIDX.
I had to update the index in the MC40000 table to be the same as the MC40200 table.
Thanks for all the help,
Rob
Hi,
If you process a TS that only has header information and no line items, does this work for FF? The currency id is needed in both the header and detail lines.
If your code calculates accrued revenue - PATACRV, there is most likely no amount in the FF projects. Check the input data layout to your code layout as FF and TM timesheets require different calculations.
If the trx can be put into GP directly, then there is no issue with the account index itself, if the trx creates distributions and can in fact be posted.
Create some TM and FF ts entries manually and check pa10100, 10101 before posting. Create the identical TS in your other TS system and compare the data layouts. My thinking is that the data could be off by one column/calculation due to the slight difference between TM and FF.
The sp's check the MC40000 table, review this table for accuracy.
Regards,
Hugh
"Check the integration/econnect configuration to ensure that the Z-US$ and '1007' are present on the upload of the FF TS."
Where (how) do I check the integration/econnect config?
"When you entered the TS manually, were you able to edit/post/print them without errors?"
Yes
"Special characters in the Project Number/CostC/ of the FF projects could cause issues."
Just the '-' char. It works on all the others though.
"Under fincancial cards, I suggest you bring up the multicurrency account access and select the account number and although no details can be entered, just click on apply."
Gave this a try. Still not working :(
Thanks
Rob
Hi,
Check the integration/econnect configuration to ensure that the Z-US$ and '1007' are present on the upload of the FF TS.
When you entered the TS manually, were you able to edit/post/print them without errors?
Special characters in the Project Number/CostC/ of the FF projects could cause issues.
Under fincancial cards, I suggest you bring up the multicurrency account access and select the account number and although no details can be entered, just click on apply.
Regards,
Hugh
hey,
Not sure what you mean by "Check the input trx config for a value of '0' in the column for 'CURRNIDX'". But I checked pa01201 and 01301 and they both have Z-US$ for the PAMCCURNCYID, I can manually enter a timesheet for the same project. Not sure what else to do.
Hi,
Check the input trx config for a value of '0' in the column for 'CURRNIDX'. Check the PAMCCURNCYID in the pa01201,01301 tables to ensure the functional currency id is properly loaded for your TS projects.
Test a manual TS entry within the GP trx entry window to ensure the TS projects will accept a TS entry without error.
Let me know if this is of assistance...
Hugh
Wow! your quick. thanks for the fast response.
I dont have a multicurrency option under Cards--> Financial, however when I veiw currenies for a specific account it does not give me the option of adding a currency (in Select Account Currencies). Functional currency is set up.
Hi,
The error indicates that your WIP account for the specified project does not have access to the currency indicated on the timesheet. Check your account under cards financial mutlicurrency and also ensure that a currency (functional) is appearing on your TS entry.
Let me know if this solves your issue.....
Hugh
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (