Miguel Verde
Member
First, using SQL, I have been charged with getting the check register and certain fields have been required. I have a basic understanding of the AP System, I just want to find out if some of the transactions that happen in our system is custom, occurs in all JD Edwards Systems and I want to get a stronger understanding of certain transactions.
1. My understanding is that the AP Ledger is a mini-General Ledger, but shows everything that happens in AP. Voids show up in the F0414, but why don't they appear in F0411?
2. Similar to Voids not appearing in F0411, I wanted to know why Voids and the PO (void) Document Type doesn't appear in the General Ledger? I thought everytime something happened in the system, the General Ledger recorded it.
3. For Non Purchase Order payment, to find out what Department (MCU) and Account (OBJ) the money was charged too, this information can only be obtained by going to the General Ledger (GL Distribution). Is there a reason why this information wouldn't be in the AP System (customization) or does all JD Edwards AP Systems work this way?
4. What is the accepted way to join F0411 and F0911? Just joining on KCO, DCT and DOC, gives rise to Cartesian Products (many to many). Right now, this is the hardest part of my project to figure out as I don't know if you can get around Cartesian Products, especially when you have multiple line items and Accounting fixes mistakes on the fly and it gets recorded in the General Ledger.
I will continue to research this like I always do, just wanted to get some input from JDE List.
Thanks
1. My understanding is that the AP Ledger is a mini-General Ledger, but shows everything that happens in AP. Voids show up in the F0414, but why don't they appear in F0411?
2. Similar to Voids not appearing in F0411, I wanted to know why Voids and the PO (void) Document Type doesn't appear in the General Ledger? I thought everytime something happened in the system, the General Ledger recorded it.
3. For Non Purchase Order payment, to find out what Department (MCU) and Account (OBJ) the money was charged too, this information can only be obtained by going to the General Ledger (GL Distribution). Is there a reason why this information wouldn't be in the AP System (customization) or does all JD Edwards AP Systems work this way?
4. What is the accepted way to join F0411 and F0911? Just joining on KCO, DCT and DOC, gives rise to Cartesian Products (many to many). Right now, this is the hardest part of my project to figure out as I don't know if you can get around Cartesian Products, especially when you have multiple line items and Accounting fixes mistakes on the fly and it gets recorded in the General Ledger.
I will continue to research this like I always do, just wanted to get some input from JDE List.
Thanks