Notifications
Announcements
No record found.
What tables are used for AP Voucher, and AP Receipt?GeneralJournalAccountEntry??
*This post is locked for comments
Hi bmruser,
All vouchers are posted in the tables GeneralJournalEntry and GeneralJournalAccountEntry. What is the background of your question?
I need the Header information to vouchers and Payment Details for mapping to JDE. Here is some of the requirments from JDE:
SOURCE_SYSTEM
DOCUMENT_COMPANY
DOCUMENT_NUMBER
DOCUMENT_TYPE
DOCUMENT_PAY_ITEM
DOCUMENT_PAY_ITEM_EXT
SOURCE_BUSINESS_UNIT_CODE
SOURCE_SUPPLIER_IDENTIFIER
SOURCE_PAYMENT_TERMS_CODE
SOURCE_ACCOUNT_IDENTIFIER
SOURCE_PAYEE_IDENTIFIER
SOURCE_ITEM_IDENTIFIER
SOURCE_PAYMENT_INSTR_CODE
INVOICE_DATE
VOUCHER_DATE
NET_DUE_DATE
DISCOUNT_DATE
GL_DATE
COMPANY_CODE
BATCH_NUMBER
BATCH_TYPE
BATCH_DATE
PAY_STATUS_CODE
GL_OFFSET_SRCCD
GL_POSTED_FLAG
VOID_FLAG
SUPPLIER_INVOICE_NUMBER
REFERENCE_TXT
REMARK_TXT
QUANTITY
TRANSACTION_UOM
TXN_CURRENCY
TXN_GROSS_AMT
TXN_OPEN_AMT
TXN_DISCOUNT_AVAILABLE_AMT
TXN_DISCOUNT_TAKEN_AMT
TXN_TAXABLE_AMT
TXN_TAX_AMT
INTERCOMPANY_FLAG
SOURCE_UPDATED_DATETIME
What is JDE? I don't know what should be the meaning of each field you listed above. So I cannot comment if the above mentioned tables are sufficient or not.
I'm moving Data from AX to JDE, and need to define what these fields are in AX
DocumentNumber = GeneralJournalEntry.VoucherID
I'm think the table needs to be LedgerjournalTrans, because it's asking for Line Number, Warehouse Location, Amounts, etc...
Sorry, I have to repeat my earlier reply as I ( and possible more persons) don't know what you mean with JDE and the list with fields.
JD Edwards ERP system, it's similar to AX. I need the AX tables that show AP Voucher (details) and AP Receipt payments.
Hope this helps, I'm doing a data migration
Where can I get the voucher details? Or how is that associated with GeneralJournalEntry
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
