Packing List

We have added some tracking information on the crystal designer.  When we print the initial packing list everything shows up fine.  However, once we have posted the batch and go into the AR History inquiry, shipping and use the tracking button to print the packing list, the print out is the crystal designer with no information at all.  It is the report like it is not accessing any database.

 

I so not understand this has the pre-posted invoice packing list is fine but the posted invoice packing list is essentially blank and the same crystal report is used for both.

 

Any help would be greatly appreciated.

Parents
  • 0

    If I understand correctly, you added a UDF for tracking information?

    The UDF's are not automatically passed along to the history tables.   You have to add them to the history tables and then link them so that they get passed along.

    You may want to discuss this with your Sage Partner.   They should now how to do this.  It's not rocket science,  but someone showing you how to do it the first time would be easier than trying to give you all the details here.

  • 0 in reply to TomTarget

    I did not add a UDF.  I inserted the items I wanted to add from the database fields.  I then added tables (work ones and history ones) to the SO Packinglistwrk and SO InvoiceTracking.  I brought into the report SO PackingList Tracking Numbers and the SO InvoiceTracking Comment.

    The packing list that goes out with the order is perfect.

    I also added the following tables:

    AR InvoiceHistoryDetail

    AR InvoiceHistoryTracking

    SO ShippingHistoryWork

    I linked the SO packing list wrk and the SO Invoice Tracking to the History files.  I linked by Invoice #, Tracking ID and Comment and the "history" packing list just shows prints out design information.

  • 0 in reply to bluetopaz

    You CANNOT add a works table to another report. They do not exist and are no populated until that printing program creates them and populates them. If you added with an equal join then the resulting form will come out blank.

    The preferred way is to add UDFs to the works table and NOT add other tables. This is covered in the classes at the Sage Summit,

Reply
  • 0 in reply to bluetopaz

    You CANNOT add a works table to another report. They do not exist and are no populated until that printing program creates them and populates them. If you added with an equal join then the resulting form will come out blank.

    The preferred way is to add UDFs to the works table and NOT add other tables. This is covered in the classes at the Sage Summit,

Children
No Data