x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 4 replies
  • Answers 2 answers
  • Subscribers 115 subscribers
  • Views 1200 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
764
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
852
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
877
topics
3k
replies
Sage CRM for Sage 300
183
topics
414
replies
ChristK

AP Error Message Report

SUGGESTED
Posted By

I'm trying to clean up vendor numbers, but I got 33 of the same error messages - "Vendor # has open transactions.  All transactions must be closed and cleared before deletion.  Print the vendor transactions report to list the vendor's open transactions".

I can't figure out how to post what I'm seeing and I can't figure out what the problem is nor how to fix it.  Details only show up when I hit 'Show Fully Paid Transactions'.  Nothing indicates what is open.  There's the original invoice, a payment, payment reversal, and an adjustment.  I'm not sure but am wondering if the issue is that instead of doing a credit note to reverse the original transaction that an adjustment was done to reverse the entry? Could that be why it won't delete?  If so, how can I fix it years after the fact?

  • 0

    It sounds like you to need to talk with your Sage Business partner and/or get some training.

  • 0
    SUGGESTED

    "  All transactions must be closed and cleared before deletion.  "

    Are you trying to DELETE the vendor? You will need to use AP Periodic Processing / Clear history .You can select a particular vendor.

    If you are trying to make the Vendor INACTIVE (often a better idea, so you can keep your history), you first need to find any open transactions and complete them (eg credit note to make an invoice zero).

    Open transaction show in the Vendor Activity / Transactions screen -  take the tick off 'Include fully paid transaction' and any left are open.

    William Woolmer, MicroChannel, Australia

  • 0 in reply to WWOOLMER

    Yeah, I'm trying to delete old vendors that we haven't used in years.  I originally ran it through the Periodic Processing and it gave me 33 errors.  I tried doing the ones with the errors individually and it won't let me.  I looked through the Vendor activity/Transactions screen - there is nothing open that I can see.  I thought maybe that the adjustments to reverse weren't done right, but as I looked at more vendors with the error, there wasn't always adjustments so that can't be it.  I checked through the bank module and it doesn't look like any thing wrong there either. I am stumped.

  • 0 in reply to ChristK
    SUGGESTED

    You can always use Vendor number change and just merge all of the old vendors into a vendor called "ZZZOLD" and that way it will sit at the bottom of your vendors and wrap them all up if you can't figure out what the problem is. Have you run data integrity to see if there's an error?

*Community Hub is the new name for Sage City