Open AR

Hello everyone,

I'm in the process of using F0311Z1 & F0911Z1 to upload open invoices (AR) from an external system into JDE. However, no matter what I do, JDE ignores my open amounts. For example, if the gross amount is $150 and the open amount is (VJAAP) is $30, the record created in F0311 will read $150 in both... What am I missing?

Thanks,
J.

Jeff,
You will need to either create a payment for all the invoices where original amount does not equal open amount or change the original amount. During world conversions, we always created payments to validate the open amounts. This allowed AR the ability to reverse payments without several entries. If you want to work outside standard processing, you can always edit the records manually.
Jeff73 <[email protected]> wrote:Hello everyone,I'm in the process of using F0311Z1 & F0911Z1 to upload open invoices (AR) from an external system into JDE. However, no matter what I do, JDE ignores my open amounts. For example, if the gross amount is $150 and the open amount is (VJAAP) is $30, the record created in F0311 will read $150 in both... What am I missing?Thanks,J.
A7.3 Cume 11
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=52515
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World™ mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+


---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more


World, OW B733X and Xe

Is it at all possible to totally separate the creation of AR items thru P03110Z from hitting the GL? I'm asking this because, in our case, the AR items I'm trying to bring over to JDE have been created and maintained on another system, yet all the generated JEs (on that system) have been manually keyed in into JDE so that the accounts in question always reflect the "reality" on JDE. The result is that I don't want to create them again...

Thanks,
J.

Jeff73, It is possible, but not recommended. What I've done is convert the legacy data into an AR clearing account for both debit and credit purposes. That way my AR balance sheet account is not affected and if there are any errors, I can look to the clearing account to resolve the problem. I encourage clients who are converting AR balances to leave the JE's in place as that allows corrections to happen later on without the creation of one sided JE's.

Jeff73 <[email protected]> wrote:Is it at all possible to totally separate the creation of AR items thru P03110Z from hitting the GL? I'm asking this because, in our case, the AR items I'm trying to bring over to JDE have been created and maintained on another system, yet all the generated JEs (on that system) have been manually keyed in into JDE so that the accounts in question always reflect the "reality" on JDE. The result is that I don't want to create them again...Thanks,J.
A7.3 Cume 11
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=53252
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World™ mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+


---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.


World, OW B733X and Xe

Mike,

How do you do that? I can force the AE account number to be hit on the F0911Z1 file, but all the RI accounts being hit default from the BU... I can create a "bogus" BU and link to some clearing account just for the upload, but I'm not sure if that's a good idea b/c I'll have to go back to every invoice and change the responsible BU back to what it should be once it's loaded correctly...

Thanks,
J.

Jeff,You shouldn't need to change the responsible BU. The responsible BU only controls access, not posting activity. Posting is controlled by AAI's and field GLC on the record.

Jeff73 <[email protected]> wrote:Mike,How do you do that? I can force the AE account number to be hit on the F0911Z1 file, but all the RI accounts being hit default from the BU... I can create a "bogus" BU and link to some clearing account just for the upload, but I'm not sure if that's a good idea b/c I'll have to go back to every invoice and change the responsible BU back to what it should be once it's loaded correctly...Thanks,J.
A7.3 Cume 11
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=53327
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World™ mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+


---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.


World, OW B733X and Xe