A/P Vendor Transactions


I am having an issue when i run the A/P Vendor Transactions (APVTRN01) report.  When the options under show (applied details and fully paid transactions) are selected when the report is generated it returns "Document Description" in the document description.  However, when those options are not selected i can see the description eg. "Professional services - Jan 2023".  Can anyone advise what may be causing this issue?  I am running Sage 300 2022 PU1

Top Replies

  • Hi  I've gone ahead and run the stock factory report APVTRN01.RPT and pasted the results below.  Please see my mark-up's on this screenshot and reply confirming your path to the APVTRN01.RPT Crystal template (see how mine is in the stock location), please provide a screen (if you can) of the issue showing "Document Description" under "Document Description" - it could just be your explanation but I don't have a "Document Description" on mine.  Please also reply with your Crystal file's modification date and size - I'll paste the one from my Sage 300 2023 PU1 lab system below too.  Is there a chance you're running a custom version of the report?  Factory reports will ALWAYS have a modified date of midnight 12:00:00 AM.

    Screenshot of my report showing the file path (C:\Sage300Apps\AP70A\ENG\APVTRN01.RPT):

    Details of my APVTRN01.RPT file (Modified: 29 August 2022, 12:00:00AM, Size: 178KB).

    Overview of my Sage 300 2023, PU1 System and confirming report parameters.  Are my parameters identical to yours? Please advise:

    Good Luck!

  • 0 in reply to Accsys Consulting AU


    Many thanks for your respond.  I believe the form was changed; however, please refer to the below:


    Your parameters match mine.  Would you be able to share an original version of the form?  I am not certain of the exact changes that were made to this form.

  • 0 in reply to Corey


    I was able to locate the original form with works; however, the output is a bit different when compared to yours.

  • 0 in reply to Corey

    Actually  our forms are the same - I just don't have the proper Arial Unicode MS font installed on my test machine.  Nice work restoring to the factory form!  Just in case you wanted to correctly implement the Document Description customisation, the screenshot below will show you how to do it and the correct rows you need to add a "Document Description" field and database field APOBL.DESCINVC.  The problem with the broken report you have was someone added a "Document Description" text field, and the database field to the wrong rows.

    Correct method to add the Document Description to the Vendor Transactions report:

    Good luck!