Updating generic general ledger tables

26 Apr

Although i MIS supports full detail, export and import procedures can be time consuming.You can produce detail transaction reports directly in i MIS to support more summarized entries.Can anybody please provide me a list of data tables used in Accounts Receivale, Accounts Payable and General Ledger module of JDE E1 8.12. view the attached send me an email to [email protected] Best Rgds, Francis Chin _____" id="ctl00_m_m_i_ctl00_gr_ctl01_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="3200785" / F09 01 Account Master F09 02 Account Balance F09 11 Account Ledger F04 11 Account Payble Ledger F03 11 Account Receivable Ledger Major IMP Finance Related Applications P03 B2002 Standard Invoice Entry/Customer Ledger Enquiry (A/R) P03 B218 Account Balance Enquiry P00 25 Ledger Type Master Setup P00 15A Currency Exchange Rate Entry P04 11 Standard Voucher Entry ( A/P)/Supplier Ledger Enquiry P04 13M Supplier Payment Enquiry P09 09 Online Chart of Accounts P09 11 Journal Entry G/L P09 200 Account Ledger Enquiry P09 07 Flex Format Setup P00 10 Company Name & Numbers Thanks & Regards, Dileep Srivastav 9869951709" id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="3200814" / List of IMP Tables for A/R , A/P & G/L is : F09 01 Account Master F09 02 Account Balance F09 11 Account Ledger F04 11 Account Payble Ledger F03 11 Account Receivable Ledger Major IMP Finance Related Applications P03 B2002 Standard Invoice Entry/Customer Ledger Enquiry (A/R) P03 B218 Account Balance Enquiry P00 25 Ledger Type Master Setup P00 15A Currency Exchange Rate Entry P04 11 Standard Voucher Entry ( A/P)/Supplier Ledger Enquiry P04 13M Supplier Payment Enquiry P09 09 Online Chart of Accounts P09 11 Journal Entry G/L P09 200 Account Ledger Enquiry P09 07 Flex Format Setup P00 10 Company Name & Numbers Thanks & Regards, Dileep Srivastav 9869951709 F0911/F0902 - GL detail and summary F0411 - AP details F0401 - Vendor master F0413/F0414 - AP checks F0311 - AR details F0301 - Customer Master These are main AP/AR tables.

: (Solomon only) With this option enabled, the individual’s name will be placed into the contact name field of the created Solomon vendor record.This option has no impact on the processing or refunds for Bill To IDs where the member type is a company, in which case the vendor name is populated with the company name.from running the next GL interface and creating duplicate files and file names.field is left blank, the system prompts you to provide a valid path and file name when the interface is run.If you do not specify the path and file type for the export file in this field, you can only specify an Omnis print file with a extension when the interface is run.