Archives!!!

demi222

This is what my customer is asking:
She makes orders and wants to archive every order before she posts them. Then she wants to be able to view the archived orders (report 405) even if they have been posted, or not.

From Purchases and Payables-> Order...she makes and order
then she chooses Function-> Archive Document.

Then she may or may not post this.

How can I make it so that she can view always her archived documents? I know of form 5167 Purchase Order Archive... I don't know how to make a document print from that form.

Please help...

DenSter

You make a copy of report 405 and you change it to run from the 'Purchase Header Archive' and the 'Purchase Line Archive' tables. You'll probably get some compile errors for missing fields and such, but you can solve those as you go. Then you add access to the report to form 5167 and you're done. Don't forget to clearly include a caption in the report that it is an archived order.

demi222

I have done this... copied report 405, and renamed it to archived orders. The problem is that my report prints out everything, except for the lines ... it won't print the Purchase Line Archive lines...

I have been trying this for 3 days now... I don't know what else to look at...

Waldo

Did you also re-assign the record variables in code?

demi222

Yes, I have... renamed everything!

One question... the Purchase line table has a whole lot of functions... do I need to make these functions in the Purchase line archive table?

Waldo

I don't think so. The archive is just a copy of the normal table. No validates has to be run when filling the tables.

DenSter

There's no need to create any functions. What you need to do is make sure that the dataitem link between the header table and the line table is correct. Then, you need to go through all the code associated with all dataitems above the line dataitem and check for SETFILTER or SETRANGE commands that may screw up your filtering. Then, if that still doesn't give you the result you need, you need to go through all the section code to see if THOSE have the filtering code.

Your best best would be to turn on the debugger and run the report, step through all the code and see where you expect it to get the right records, but it doesn't.

There's probably a variable in the report of the type 'Purchase Line" that needs to be set to the archive line and the document type filter taken off, something like that.

Dont give up dude, this is the fun stuff!!! 8)

Savatage

DenSter wrote:

Dont give up dude, this is the fun stuff!!! 8)

:-k

demi222

in the copyloop section of the report... the code has the following


PurchLine.CalcVATAmountLines(0,"Purchase
Header",PurchArchLine,VATAmountLine);

PurchLine.UpdateVATOnLines(0,"Purchase Header ",PurchLine,VATAmountLine);

These are functions that are in the Purchase Line table... do I need to add the functions also to the Purchase Line archive table? Otherwise, the report wont run...

Waldo

hm, good question.

If I'm not mistaken, these functions are meant to fill temporary tables for printing VAT lines on the report. So, you do no harm adding these functions to the archive-tables.

If you don't need VAT on the report, I would just delete the VAT-part of the report, including these function calls.

demi222

I removed whatever had to do with VAT from my report... everything shows up when I print preview except for the Purchase Line Archive lines...

any other suggestions?

Arhontis

Hi,

Why do you want to use a report for that?

I have done the same functionality by adding to the main menu a link to the form "Purchase Order Archive" or "Sales Order Archive" for sales...

"Why print when you can see it on screen?"

Waldo

:-k

Personally, I think the default functionality is:

when you want to print the order from the archive, first restore it as an order (an archived one is not an actual order), then print it.

:-k

demi222

for some reason, they want to be able to view the order as they sent it to their customer.

I am able to view the purchase line archive lines... but have one problem with this...
In the roundloop section of the report it has PurchLine.DELETEALL;

and in the copyloop section the same thing...

I made them into PurchLineArch.DELETEALL;

However, this deletes the lines, and nothing can be viewed... if I comment these two out, then it prints each line twice, and continues to print from other orders, etc.

Any ideas?

:?

DenSter

No no no....there is no need to recreate an order just to be able to print. You want to print from the Archive, so there is no need to recalculate any amounts. It's historical data that you display, so you can simply display the values that are in the archive tables. There are no calculate VAT functions in the archive tables simply because you don't NEED to recalculate those numbers.

Also, don't do a DELETEALL in your report, that removes your archived data and you wont be able to report them again. Just remove those functions from your archive report and display the values. Remeber this is a report to only display historical data, so you dont need to recalculate anything, and you dont need to create/modify any records either. All you need to do is display what is in the table.

demi222

If I don't do the delete all, the lines show up, however, they print out twice.. Also, the previous archived data lines also print out...

Don't know what's happening...