f0911

I am trying to relate tables F0911 with F7601B and F76101B by using F0911.GLVINV = xxBNNF (invoice number) and F0911.GLAN8 = xxAN8V (supplier code) with the aim to bring invoice details such as SERIES (FHBSER) and INVOICE TYPE (FHDCT), for example. However a few lines do not contain F0911.GLVINV...

Hello everyone, I am working on data analysis on F0911 and I am really surprised to find that around 20% of the table has duplicates (all the fields are the same expect GLJELN and GLSFX). This doesn't make sense in an accounting point of view. I don't really understand how the data are...

Hi, We put amounts received in an Unapplied Receipt and we posted our batches without having applied invoices to go faster. a batch was created when I applied the RU to invoices. I was unable to balance a receipt for the amount of X , I put the batch "pending" while waiting to be able to find...

We are converting/upgrading 3 years of historical, transactional data from JDE 8.12 on the AS/400 to JDE 9.2 on Oracle 12c. There is a multitude of data integrity issues from the past 8 years of processing on JDE 8.12. So, this has become a hybrid project, whereby it's more like a net new...

Hello JDE Gurus! I need to extract data from the F42119 table and include the OBJACCT and SUBACCT fields as well. Basically I am trying to take detailed sales ledger data + the GL accounts where this data was posted. Right now I am trying to get that GL accounts from the F0911 table but my...

Looking for Input... Recently saw several F0902 Balances that did not match against the F0911 GL Detail. Struggling to figure out how that happens. - I found the batches - and there were no errors, WC Messages or Logs - SQL the Sum for a Period, and the Detail did not match the period...