Skip to Content
0
Feb 23, 2009 at 09:52 AM

How to retrieve the ARCHIVED Sales order data

3238 Views

Hi All,

When issuing the output for the delivery, it is giving an error saying 'Sales Order XXXX does not exist' due to which the prices in the output were displayed as '0'. Reason for this can be that 'the order might have been archived'.

My requirement is,

1. If Sales Order doesnu2019t exist in data base then need to check if Sales order exists in archive data base.

2. If yes, take needed data from archive data base tables to calculate price. The logic of price calculation should be the same as for not archived Sales Orders.

Can anyone help me on this..?

Please tell me how to check whether the Sales order exists in the Archived database. Please share the table names(sample logic if possible) sothat I can use them in the report logic.

Please tell me how to pull the data from the archive database tables to calculate the price.

Thank you in advance.

Thanks & Regards,

Paddu.

Edited by: Paddu K on Feb 23, 2009 3:42 PM