Before upgrading to 8.1A, I was able to print out the "reason" we enter on every Inventory adjustment we did. Since then the crystal report I am using gives me no information after the upgrade. Where can I find the "reason" column in the database to get the information after the upgrade? I have tried in the ICW81 Adjustment Audit List, but that only keep the information for the current day.

Doug

Hi Doug,

Is this a customized Crystal Report that prints adjustments prior to posting? Or on the audit list file after posting? Or the Transaction History file?

As far as I can find, the report tables never looked at the pre-posted IC transactions, whether this was for Adjustments, Shipments or Stock Transfers. It only ever read the respective Audit List files, which get written to after posting. Adagio IC version 81A uses different files for storing the audit list information, and the IC81A report table is required for reports that work on the audit list files. I see that the Reason field works when using this file.

In Adagio IC 81A, you do not have to print and purge the audit lists in order to get the information into Transaction History - posting the adjustment (or other transaction types) writes directly to history. This means that you don't have to be in a hurry to purge audit lists anymore, as you used to have to do in versions 8.0A or older.

The Transactions History file does not store the Reason information, neither in the old version nor in 81A. It appears that the only place to get the Reason in a Crystal Report is the audit list file.

If you have Adagio GridView, this can read the Adjustment file before transactions are posted. And the Reason is properly displayed.

This is a customized Crystal Report that was looking at the Feild: "ICW65Adjustments.Reason" I can still run this report and see all the reasons going back to 1999 up until the update was done, after which there are no more adjustments saved in this table (because 81A uses different files).

I can read this information from the Adjustment file before transactions are posted, but I want to go back and generate reports several months and in some cases, years. I can see the adjustmens using the Transaction History but not the "Reason".

I was hoping then information was still stored like in the previous version, and I just needed to find it.

Hi Doug,

The ICW65 table and the 'Adjustments' portion looks at the data file ICADJTR.dat, which is the old adjustment audit list file. Indeed if you can see adjustment records going back to 1999, then you are looking at an audit file, because Adagio Inventory did not exist until 2001 - these older transactions came from Accpac Plus IC. Inventory does not save information after it is posted, but instead moves it to the audit list and transaction history data files.

If you want to get the new adjustment Reason and other information, you will need to write a new report based on the ICW81 table.

I am in the process of writing a new report using the ICW81 table, but I can not find the "Reason" in any of the tables. I have gone through all the ICW81 files using Crystal Reports and still can't find it. The only place I can find it is in the ICW65Adjustments and that only has the old data. Am I looking in the wrong Place?

Doug
PS. thanks for the speedy replys

When selecting a table, you need to scroll to the end of the IC table list and look for those with ICW81, not ICW65.

If you create a new report and select the 'ICW81 Adjustment Audit List' table, the 'Reason' field is about halfway down the list of fields within the table, underneath 'Cost'.

That is what I have done. I am using
Field: ICW81 Adjustment Audit List.Reason
but it only shows me todays Adjustments, and I need to go back to last month to get the reasons that were entered.

Thanks
Doug

Aha! You are wanting to merge the 2 files together, the one based on the old file and the one based on the new file. You cannot simply use 'Add database to report' to do this, because this assumes 'side-by-side' linking and not 'merge files together'. You need to do separate reports, your existing one and a brand new one that is identical except for being based on the ICW81 table.

Presumably your existing report based on the old ICW65 file is working OK. Now what you need to do is insert the new ICW81 report as a sub-report into the existing ICW65 report. The easiest place to insert is the Report Footer section, so you can get all the old adjustments and then all the new ones.

If you are sorting/grouping the adjustment - say by item number for example - then it gets a bit trickier. You then need to insert the sub-report into the Group Footer (by item number) section, and you also need to set the sub-report link by item number. In the 81A sub-report, you will need to hide most sections, such as the report header/footer and the page header/footer.

I sort of understand what you are saying, I have made several sub-reports before, but I'm not sure that will solve my problem. I can see my "Reasons" before April 2008 (upgrade date) and for today, but I can't find the "Reasons" in-between April and Today. I don't know where the "Reasons" have been stored (or if they are being stored) in Inventory 8.1A

Doug

Hi, Doug,

The ICW81 Adjustment Audit List table stores the 'Reason' after the Adjustment transaction has been posted and up until the Adjustment Audit List is purged.

It sounds like the Adjustment Audit List in Adagio was purged prior to today. This would explain why you can see the reasons for adjustments posted today in Adagio only.