MikeS
Member
We need to upload 2,800 open items into our OneWorld XE SP23_J1 AR database. About 300 of them are in Canadian dollars the rest in USD currency. This is our first experience with multicurrency in JDE. We just turned this on and I am trying test uploads into PY using the two Z1 files F03B11Z1 and F0911Z1.
I wrote a UBE to populate these two files following the guidelines of "BATCH INVOICE PROCESSING - PEOPLESOFT ofn-99-0111-1.htm" (from the Peoplesoft website) and "Batch Input Setup for Invoice Transactions" of the OneWorld XE English documentation CD.
But I am not having much luck with the Canadian open items. The US currency ones upload just fine. On the Canadian ones they come in without any USD values associated with them. I tried all kinds of different variations of putting or not putting values into VJACR, VJCRR, VJCTXN without any luck.
If I fill VJACR with the foreign amount, VJCRR with a fixed exchange rate, VJCRRM with F for foreign, VJCRCD with CAD and leave VJCTXA and VJCTXN fields empty since it says "you should not complete both the currency amount VJACR and foreign taxable amounts fields". I also left the AG field empty. When I upload the data like this I get no errors in the Job log or in the work center file for the job. The open items get created but none of the amount fields are populated. Everything is 0.
Have any of you uploaded foreign currency items into JDE succesfully using the Z1 files? What fields did you populate and which ones did you not?
Thanks for your help.
Mike
I wrote a UBE to populate these two files following the guidelines of "BATCH INVOICE PROCESSING - PEOPLESOFT ofn-99-0111-1.htm" (from the Peoplesoft website) and "Batch Input Setup for Invoice Transactions" of the OneWorld XE English documentation CD.
But I am not having much luck with the Canadian open items. The US currency ones upload just fine. On the Canadian ones they come in without any USD values associated with them. I tried all kinds of different variations of putting or not putting values into VJACR, VJCRR, VJCTXN without any luck.
If I fill VJACR with the foreign amount, VJCRR with a fixed exchange rate, VJCRRM with F for foreign, VJCRCD with CAD and leave VJCTXA and VJCTXN fields empty since it says "you should not complete both the currency amount VJACR and foreign taxable amounts fields". I also left the AG field empty. When I upload the data like this I get no errors in the Job log or in the work center file for the job. The open items get created but none of the amount fields are populated. Everything is 0.
Have any of you uploaded foreign currency items into JDE succesfully using the Z1 files? What fields did you populate and which ones did you not?
Thanks for your help.
Mike