Mikey_R
Member
I am showing a number of very high (00,000,000's) Gross Amount Unapplied Cash Invoices in Table F03B11 and the open amount is almost always $0. However I cannot find nearly all the receipts in table F03B14 to reconcile the difference between the open amount and gross amount. In fact in most cases the receipts sum up to like a few thousand vs an unapplied cash invoice with gross amount in the millions and an open amount of 0.
I searched for the Document number in F0911 and could not find the transaction that created the large gross amounts in F03B11, very strange.
Does anyone know what might be going on?
I am trying to build a data model, in Power BI, that has all of our invoices gross amounts and all of the transaction activity against those invoices so I can generate AR aging schedules as of any date I want in Power BI. I thought that I could use F03B11 and F03B14 as the fundamental data tables but this unapplied cash issue has me scratching my head.
I am very new to JDE so I apologize if this is obvious but I cannot find a very good answer with a web search.
I searched for the Document number in F0911 and could not find the transaction that created the large gross amounts in F03B11, very strange.
Does anyone know what might be going on?
I am trying to build a data model, in Power BI, that has all of our invoices gross amounts and all of the transaction activity against those invoices so I can generate AR aging schedules as of any date I want in Power BI. I thought that I could use F03B11 and F03B14 as the fundamental data tables but this unapplied cash issue has me scratching my head.
I am very new to JDE so I apologize if this is obvious but I cannot find a very good answer with a web search.