Ray Justus
Reputable Poster
Re: Budget Uploads
Ian,
You can find instructions for Eric's method in Section 14 of the General Accounting Guide. One caveat: Do not put anything in the first column of the header line of the spreadsheet so that it will sort to the top and be the record that gets deleted instead of the first data record. See page 14-44 of the General Accounting Guide. Do not put the words 'Account Number' in cell A1.
Ray W. Justus
Kitchell Corporation
1707 East Highland Avenue, Suite 100
Phoenix, AZ 85016-4679
(602) 631-6157
mailto: [email protected]
>>> <[email protected]> 02/06/01 01:11PM >>>
Ian,
I've done many uploads for job budgets in (OW and World)as well as regular budgets using the F0902z1 file. It doesn't require that you be in balance like a JE and is fairly easy to work with. If you go to menu G1421 and find interactive app P0902z1, you can enter budgets here manually and then view the F0902z1 to see what fields are required. I then use Access to populate the fields... After the file is populated, run the R14110 to populate the F0902 file for the budgets.
Eric
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
Ian,
You can find instructions for Eric's method in Section 14 of the General Accounting Guide. One caveat: Do not put anything in the first column of the header line of the spreadsheet so that it will sort to the top and be the record that gets deleted instead of the first data record. See page 14-44 of the General Accounting Guide. Do not put the words 'Account Number' in cell A1.
Ray W. Justus
Kitchell Corporation
1707 East Highland Avenue, Suite 100
Phoenix, AZ 85016-4679
(602) 631-6157
mailto: [email protected]
>>> <[email protected]> 02/06/01 01:11PM >>>
Ian,
I've done many uploads for job budgets in (OW and World)as well as regular budgets using the F0902z1 file. It doesn't require that you be in balance like a JE and is fairly easy to work with. If you go to menu G1421 and find interactive app P0902z1, you can enter budgets here manually and then view the F0902z1 to see what fields are required. I then use Access to populate the fields... After the file is populated, run the R14110 to populate the F0902 file for the budgets.
Eric
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************