EBS库存与总账的关联是如何实现的

发件人 BlogPic

MTL_TRANSACTION_ACCOUNTS(MTA)

• Holds the accounting information for each material transaction in MMT

• In most cases, each costed row in MMT should have at least 2 or more rows in MTA to represent the transaction Debit and Credit

• Join to MMT by TRANSACTION_ID

• Troubleshooting columns to verify:

• GL_BATCH_ID = -1

• REFERENCE_ACCOUNT = NOT NULL

• Module

• INLTGL: Transfer to GL

• Form

• Inv>Transactions>Material Distributions

• CSTFQITD

发件人 BlogPic

发件人 BlogPic

ORG_GL_BATCHES (OGB)

• Stores row for each batch of transactions interfaced to GL_INTERFACES

• Troubleshooting columns to verify:

• OGB.GL_BATCH_ID = MTA.GL_BATCH_ID

• ACCOUNT_PERIOD_ID

• ORGANIZATION_ID

• Module

• INLTGL: Transfer to GL

• Form

• Inv>Accounting Close Cycle>View General Ledger Transfers

• INVTTGGL



GL_INTERFACE (GLI)

• Stores row for each batch of transactions interfaced to GL_INTERFACES

• Troubleshooting columns to verify:

• REFERENCE1 = MTA.GL_BATCH_ID / ORGANIZATION_ID

• REFERENCE21 = MTA.GL_BATCH_ID

• REFERENCE22 = MTA.ORGANIZATION_ID

• Run Import to GL > GL Vision Ops (USA) Responsibility

• Designate Source (i.e. Inventory) and Optionally Group ID

• Journals>Import>Run

• Inquiry on Batch

• Inquiry>Journal

• Source = Inventory

• Period = <Period to Query>

发件人 BlogPic

发件人 BlogPic