x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 598 views
  • Users 0 members are here
Browse Forums
Announcements
104
topics
4
replies
General Discussion
1k
topics
2k
replies
Mr Zorba

Cannot find Transaction. This transaction type cannot be viewed here. Please go to Order Enquiries

SOLVED
Posted By

Hi,

I was converting a Pro Forma to a sales order and I recevied an error message. I tried to continue but I kept getting this error.

I closed Sage and reopened it and it say COMPLETED under document status saying its converted it but it didnt.

When I click view order from the Pro Forma I get the error "This transaction type cannot be viewed here. Please go to Order Enquiries"

Does anybody know how I go about solving this issue? Will this affect Sage in any way?

Thanks

Parents
  • 0

    It would be useful to know what the error message was that you got when converting the Pro Forma to an Order. 

    The reason you're getting this specific error is because the DocumentTypeID for the record is incorrect; for an order it should be 0 and it's probably still 2 (i.e. still thinks it's a Pro Forma).  You can try modifying the value in the database if you're confident that you know what you're doing.

  • 0 in reply to Chris Burke
    SUGGESTED

    In the View Proforma menu option, what does it have in the "Order No" column for that proforma?  Does that order exist? 

    You could mark the original proforma as Live (DocumentStatusID=0) and try again, making a note of any error messages!

    It's unlikely that any accounts have been affected but it's possible some stock has been allocated to a corrupt order - so it's worth running Prove Ledgers in Accounting System Manager.

Reply
  • 0 in reply to Chris Burke
    SUGGESTED

    In the View Proforma menu option, what does it have in the "Order No" column for that proforma?  Does that order exist? 

    You could mark the original proforma as Live (DocumentStatusID=0) and try again, making a note of any error messages!

    It's unlikely that any accounts have been affected but it's possible some stock has been allocated to a corrupt order - so it's worth running Prove Ledgers in Accounting System Manager.

Children
No Data

*Community Hub is the new name for Sage City