Share
ReportHi,
Can anyone of you tell me on how to get GL Account Number based on job number or cost code for purchasing transaction.
Thanks,
Jyotshna
*This post is locked for comments
You’re offline. This is a read only version of the page.
210
Hi,
Can anyone of you tell me on how to get GL Account Number based on job number or cost code for purchasing transaction.
Thanks,
Jyotshna
*This post is locked for comments
Okay, but from where does the Job Number or Cost Code originate? It sounds like you want to map GL distribution accounts to the job number/cost code, correct?
I wrote a stored proc which uses econnect and executes taPMDistribution. Below is the way how I do it, for now I hardcoded the account number but I want to get it based on job number or cost code.
Exec taPMDistribution
@I_vDOCTYPE=1
,@I_vVCHRNMBR=@VoucherNum
,@I_vVENDORID=@VendorId
,@I_vDISTTYPE=6
--,@I_vACTINDX=@ACTINDX
,@I_vACTNUMST='10-51-01000-5055'
,@I_vCRDTAMNT=0
,@I_vDEBITAMT=@LineAmount
,@I_vDistRef=''
,@O_iErrorState=@ErrState output
,@oErrString=@ErrOut output
Are you using the Project Accounting or Job Cost module or another 3rd party application for job costing?
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (