Wednesday, February 9, 2011

Update journal category, journal description

When you transfer payroll cost from Payroll to General Ledger using Transfer to GL process, there is no option to tell that these journal should be created with this category or description or change accounting date.

These payroll cost will be inserted in GL_Interface table once transferred to GL from where you can import these into journal batch using Journal --> Import. Normally these journal with be created with journal category Payroll and description like Payroll: request id (of transfer to gl process).

Because these journal doesn't automatically get imported you have option to write a custom process where you can update information about journal. Here is information about columns of GL_INTERFACE

REFERENCE1 Batch name.
REFERENCE2 Batch description
REFERENCE4 Journal entry name
REFERENCE5 Journal entry description
REFERENCE6 Reference or journal number
REFERENCE7 Reverse Journal Flag
REFERENCE8 Reverse Journal Period
REFERENCE10 Journal line description

So you can update these columns with information what you want on Journal. e.g. if you want to make journal with description payroll cost (including bonus) then you can update REFERENCE5.

Please let me know if you have any questions on this post.

No comments:

Post a Comment