Hello Lovelie,

There is not a specific report for posting disposals. There is the disposal report which does have a date range so that you can get the disposals for specific periods which can be exported to Excel and then be modified to be an import file.

I get this question all the time and the thing which always hangs me up is, I am not even sure what a report for the posting of disposals would even look like. Me, being a technician, find myself thinking that it would not be that difficult to throw something to in Crystal which could do the job, but in asking for details, I do get widely differing answers.

I do not know if you have Reporting where you could write your own report to generate the posting. If not, I would suggest the Ideas page here: Ideations - Sage Fixed Assets - Sage City Community to let Dev. know what you want or the SES guys who can create a custom interface to pull the data you are looking for in that posting. See How do I contact Sage Expert Services? (62949) 

~Delray

Hi Lovelie,

You can write a custom report and save the report template for future use.  Pull in the fields you want for your file; asset number, cost, AD, sale proceeds, gain/loss, etc.  Run the report, then send it to excel as a data only report.  This means you have to manually type in the column headers but the data drops nearly into columns.  You may have to edit the excel file a bit for your upload to Oracle.  You can also create a custom group for disposals based on a date range.

Once you get the hand of writing reports it is fairly simple.  You simply add the columns you want and go from there.  You will have a bit of trial and error to get what you want but the process is straightforward.

Alan

Hi Alan, 

Thank you so much . I will try that 

Got it . Thank you Delray!