Skip to content
+1-888-319-3663

COMMUNITY FORUM

PA Billing Note Employee Expense

Tanya asked 3 years ago
I know you can do this with a timesheet, but it doesn’t seem to work with Employee Expenses?  Is it possible?
 

PA Billing note not available in SmartConnect
By Kevin, Senior Application DeveloperThursday, December 8, 2011

 

 
 


When bringing in a Project Accounting Timesheet, the PA Billing Note does not show up to be mapped to.
You can add that field as an additional item. 
1. Go to Tools – SmartConnect – Node Maintenance 
2. Select the timesheet node type from the lookup 
3. Select line item and hit edit node 
4. Add a line to the bottom with the following Parameter=PAtx500 Display Name=Billing Note Type=String 
5. Click Save and OK to exit all the windows.
Answers
Ethan Sorenson Staff answered 3 years ago
Tanya,
SmartConnect can only connect to existing eConnect nodes. In the example Kevin referenced there is a field in eConnect that SmartConnect does not have available for mapping out of the box. If you add it to Node Maintenance with the same name as eConnect has, it will work.
 
In the below eConnect schema we can see that there isn’t an element with that name. 
https://docs.microsoft.com/en-us/previous-versions/dynamicsgp/developer/jj193378%28v%3dmsdn.10%29
 
Instead, you can map the value to a user defined field, or you can use a post document SQL task to insert the value directly into the GP table.
Tech Tuesday: SQL Task Example – SmartConnect

If you would like to submit an answer or comment, please sign in to the eOne portal.