Okay so lets say you used Lawson for HR/PR and used some other software for GL as many clients do. Is there a canned program in Lawson that can extract the GL data related to Payroll into a file that we can then feed to the GL system (After some massaging)?
I thought PR198 did this but I can't seem to find out how...
Thanks
Hi Tan - we do just that here - and use the REMOTEGLT file (which is created by the PR198). Since I'm not a GL wizard, actually, it gives me hives, I'll have to search for some documentation if you need it
Thanks SAH,
kinda strange, I don't see anything in the code that would point to creating the REMOTEGLT file but I guess I didn't look hard enough to start with. Any idea which workfile this is?
Or a better question is: Does anyone know the file layout of this REMOTEGLT file ?
Thanks
Here's info from article 115868 -
How is RemoteGLT set up?
Description:
We do not use Lawson General Ledger, but need to have a file for our 3rd party software. Is there a way to get a file for the GLTRANS records that are created from the PR198 (General Ledger Posting) program?
Resolution:
Complete the following steps to get a file for the GLTRANS records created by the PR198 program.
Form transfer to GL01.1 (System Control) program.
Inquire on the Company number and System Code GL.
Click on the Systems button.
On the Main tab, find system code GL.
Click on the Remote Site button. This will bring you to GL01.5 (Remote Site Indicator).
Change the Remote Site field to Yes and enter in a Source Machine Code.
Once you run PR198 in update mode, the remoteglt file will be created.
Note:
The default location for the file that will be created is located in: $LAWDIR/prodline/work/REMOTEGLT directory.
Additional Information:
Keywords:
gscweb, remoteglt, csv, file, PR198, location GLTRANS non-Lawson GL
Hope this is useful
PS - Here's a sample of ours with one line of detail -
"MachineCode","ObjId","System","Program","Summarize","Company","PostingDate","ZoneAcctunit","CntrlDocumentNbr","JrnlBookNbr","JeType","ToCompany","SourceCode","AcctUnit","Account","SubAccount","Activity","AcctCategory","CurrencyCode","Date","SummaryControl","AutoRev","AnalysisFld01","AnalysisFld02","AnalysisFld03","Sign","ResourceType","Resource","ForceDetail","Reference","Description","DocumentNbr","BaseAmount","BaseNd","Baserate","ToBaseAmt","ToBaseNd","ToBaserate","TranAmount","TranNd","AcctCurrency","AcctAmount","AcctRate","AcctNd","UnitsAmount","EffectDate","ProgramInfo","SegmentBlock","RptAmount1","RptRate1","RptNd1","RptAmount2","RptRate2","RptNd2","AtnResourceDesc"
"APPR-02",237674,"AP","AP175","Y",4832,"05/15/2005",,,,"N",4832,"AC","PAYROLL_PSUSP",2210,,,,"USD","05/15/2005","A","N",,,,"0",,,"A","AP175","Accounts Payable Accrual",,291.00,2,1.0000000,291.00,2,,291.00,2,,,,,,"05/15/2005",,,,,,,,,
:blink:
See why it gives me hives??
-Non-Lawson GL clients are delivered a limited selection of general ledger programs under the system code IF -- GL subset must be configured correctly.
-HR00 "Create GL Transactions" flag should be set to YES for records to be created in the GL interface file.
-If client need Dollars and HOURS in their GL, the HR00 "Post Hours to GL" flag should be set to YES.
-HR00 and HR01 "Create Distributions" flags should be set to YES for PRDISTRIB records to be created in Lawson PR history.
-Hard-coded defaulting impacts both the GL accounts and the posting dates.
hth
Kate