ML190 – Ledger Journal Posting

System
Multi-Ledger (ML)
Type
Batch program
Updates
30 tables
References
62 tables

ML190 (Ledger Journal Posting) is a Lawson Multi-Ledger batch program. It updates ADDRDATA, CKPOINT, CUACCTAU, CUCODESAU, CUCONVAU, CURELATAU, CUTABLEAU, CUTRNSLAU and 22 more and references ACDETAILAU, ACHEADERAU, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 54 more.

About ML190

Run Ledger Journal Posting (ML190) to post Multi-Book Ledger journal entries. The program posts released journal entries created in the Multi-Book Ledger application or interfaced from a non-Lawson application. NOTE A journal entry must be released before it can be posted. The program does not post journal entries that have a journal hold code assigned. **Processing Effect The Journal Posting program - Posts released journal entries with a posting date less than or equal to the Through Posting Date you define. - Creates balancing entries for interzone journal entries. - Creates auto-balancing entries for recurring journal entries that were created in currencies other than the company base currency and posts them either to the auto-balancing system account (if the company uses the auto-balancing option) or the error suspense account (if the company does not use auto-balancing). - Updates account balances. - Changes the journal entries to a Posted status. - Changes journal entry transaction lines to Historical status. - Updates the Undistributed Retained Earnings account for Income Statement accounts.

More information: If you select a company group, all the companies in the company group must be assigned to the ledger, with a ledger calendar defined for each. You can limit the posting to a through posting date and to an operator. You can post multiple journal entries at the same time as long as the Company, Fiscal Year, Period, System Code, or Operator is different for each job. If you are posting intercompany journal entries, run Ledger Journal Posting (ML190) for both the originating ("from") company and the posting ("to") company. The program gives you the following reporting options: - You can request the report to contain all journal entries, or only updated journal entries. - You can include or exclude comments and attribute values from the report. - You can generate the report in base currency, report currency one, report currency two, or all three currencies. - You can select one of four report styles: Standard is the style use for base currency reports. Separate produces a separate report for each currency. Inline shows all the currency calculations in the same report Both is a combination of Separate and Inline, where both an inline reportand up to three separate reports are generated. - Standard is the style use for base currency reports. - Separate produces a separate report for each currency. - Inline shows all the currency calculations in the same report - Both is a combination of Separate and Inline, where both an inline reportand up to three separate reports are generated. You cannot run this program and Ledger Period Closing (ML199) at the same time. To inquire on posted journal entries, use in Ledger Transaction Analysis (ML90.1) and Ledger Account Analysis (ML95.1).

Updated files (30)

TableDescriptionSystem
ADDRDATAAddress CodeIF
CKPOINTNo description in the Lawson data dictionary
CUACCTAUCU Account AuditIF
CUCODESAUCurrency Codes AuditIF
CUCONVAUCurrency Exchange Rate AuditIF
CURELATAUCurrency Relation AuditIF
CUTABLEAUCurrency Table AuditIF
CUTRNSLAUCurrency Translation AuditIF
GLCHTDTLAUChart Detail AuditIF
GLMASTERGeneral Ledger Account MasterIF
GLMASTERAUAccount Master AuditIF
GLNAMESAUGeneral Ledger Names AuditIF
GLSYSTEMGeneral Ledger CompanyIF
GLSYSTEMAUGL Company AuditIF
JBKSEQNBRJournal Book Sequence NumberGL
JBOOKHDRJournal Book HeaderIF
MLAMOUNTSMulti-Book Ledger AmountsML
MLCALMAPMulti-Book Ledger Calendar MapML
MLCOLEDGERMulti Book Ledger Co LedgerML
MLCONSOLMulti Book Ledger ConsolidatedML
MLCONTROLMulti Book Ledger ControlML
MLCUAMOUNTML Ledger Currency AmountML
MLCUCNTRLMl Ledger Currency ControlML
MLJELOGMulti Ledger Journal Entry LogML
MLMONITORML MonitorML
MLMXVALUEML Attribute ValueML
MLTRANSML TransactionsML
MLULPOSTML Post Acct Unit TotalML
MLUNITSML UnitsML
SUBCKPOINTSubledger Check PointIF

Referenced files (62)

TableDescriptionSystem
ACDETAILAUCA Alloc Code Detail AuditGL
ACHEADERAUCA Alloc Code Definition AuditGL
AMACCTAUAsset Account AuditAM
AMACCTGPAUAsset Account Group AuditAM
AMASTTYPAUAsset Type AuditAM
AMAUGRPAUAM Accounting Unit Group AuditAM
AMDICT2No description in the Lawson data dictionaryAM
AMDIVISNAUAM Division AuditAM
AMSYSOPTAUNo description in the Lawson data dictionaryAM
AUMXVALUAUAU Attribute Value AuditIF
AUMXVLDTAUAU Attribute Value Edate AuditIF
CAALOCGPAUAllocation Group AuditGL
CADETAILAUAllocation Detail AuditGL
CAHEADERAUAllocation Header AuditGL
CUACCTCurrency Gain and Loss AccountIF
CUCODESCurrency CodesIF
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
CUTABLECurrency TableIF
CUTRANSLCurrency TranslationIF
FBADJCODAUBudget Adjustment Code AuditGL
FBCNTRLAUBudget Journal Control AuditGL
FBDETAILAUBudget Detail AuditGL
FBFNDHDRAUBudget Edit Group AuditGL
FBHEADERAUBudget Header AuditGL
FBHSTHDRAUBudget Version AuditGL
FBINTBUAUBudget Interbudget Rel AuditGL
FBSPREADAUBudget Spread Code AuditGL
FBTRANSAUBudget Transactions AuditGL
GLACMXVLAUGL Acct Attribute Value AuditIF
GLADDRESSGeneral Ledger Company AddressIF
GLAUTMXVAUGL AU Attribute Template AuditGL
GLCGCPYCompany Group CompanyIF
GLCHARTGeneral Ledger ChartIF
GLCHARTDTLGeneral Ledger Chart DetailIF
GLCPYGRPGeneral Ledger Company GroupIF
GLESACCTGeneral Ledger Error SuspenseIF
GLINTCOGeneral Ledger IntercompanyIF
GLNAMESGeneral Ledger NamesIF
GLZONEGeneral Ledger ZoneGL
GTMXVALUAUJE Attribute Value AuditIF
INSTCTRYCDIntrastat Country CodesTX
JBKOPCODEJournal Book Operator CodeIF
JBKSYSCODEJournal Book SystemIF
MACAPDTLInvoice Distrib ConversionMA
MLLEDGERMulti Book LedgerML
MXCATDEFAUAttribute Definition AuditIF
MXELEMNTAUAttribute Element AuditIF
MXLSTDTLAUAttribute List Detail AuditIF
MXLSTHDRAUAttribute List Header AuditIF
MXOBJCATAUAttribute Object AuditIF
MXTMPDTLAUAttribute Template Dtl AuditIF
MXTMPHDRAUAttribute Template Hdr AuditIF
MXTPEFDTAUAttr Template EDate Dtl AuditIF
MXTPHEDTAUAttr Template EDate Hdr AuditIF
MXVALIDATEAttribute ValidationIF
MXVALIDAUAttribute Validation AuditIF
MXVEWDTLAUAttribute View Detail AuditIF
MXVEWHDRAUAttribute View Header AuditIF
RJMXVALUAURecurring JE Attr Value AuditIF
SYSTEMCODESystem CodeIF
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (12)

ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSC, IFSG, IFUP, SLSE, SLSU