Sales Order and Purchase Order files, in the interests of usability,
and set the flag to "void" these orders once they had been
invoiced. Worked great, and they could even inspect hese "archived"
(as they thought of them) orders and reprint documents etc.
Eventually they realised however that these records were now
invisible to reporting programs or any other software that accesses
the Axapta tables directly (such as Demand Planner). It turns out
the data is moved to tables called SalesTableDelete, SalesLineDelete
etc, and that the information is held in a column of type Image as a
BLOB. Axapta has a system class called BinData that it uses to
retrieve these records, one by one.
I have persuaded the customer to stop using this facility
for "archive" purposes as it is not really suitable. However they
want to retrieve the information and move it back to the Sales
Purchase tables so that the last few weeks worth of information is
available for querying, reporting etc. If anyone has a job or
script (presumably using the BinData class) to achieve this it would
be very helpful.
Hans
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
| Business finance course | Business to business finance | Small business finance |
| Business finance consultant | Business finance magazine | Business finance schools |
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
