Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
unidentified user
moore
Posts: 1
Registered: 07-14-2011
0

Re-Printing a Sales Order that has been invoiced

:smileysad:I cannot seem to figure out how to re-print a sales order which has already been invoiced.

When I go to Sales Printing, and enter the sales order number in, it tells me there's no orders to print.

 

I realize that normally (before it's invoiced).. and you've printed it already, you have to back in and check of print sales order for it to print again.

 

But this is not available once an order has been invoiced.

 

Help!  Thank you.

Super Contributor
connex
Posts: 794
Registered: 10-29-2008
0

Re: Re-Printing a Sales Order that has been invoiced

[ Edited ]

If you have S/O history enabled you can print it from the Sales Order Inquiries (Sales Order/Quote History Inquiry).

 

...and welcome to the forums!

Dan Burleson
Sage Authorized Consultant - Ask me about advanced scripting!
e-mail me here
Sage MAS Partner
givingtr
Posts: 348
Registered: 11-14-2008
0

Re: Re-Printing a Sales Order that has been invoiced

[ Edited ]

I don't believe completed orders can be reprinted, so you'd have to create a custom report. If you're saving the orders in Paperless Office, just select your saved pdf and re-print. If not, configure Paperless Office and start saving them.

Mark Kotyla
Giving Tree Consulting, LLC
(860) 313-0720
Super Contributor
connex
Posts: 794
Registered: 10-29-2008
0

Re: Re-Printing a Sales Order that has been invoiced

[ Edited ]

Mark is right! My bad. The only canned report that will print the details of the order is the Sales Order and Quote History report, but not all the billing and shipping header data.  I looked at redirecting the sales order form to the work table for this report, but there is too much data that is not there.

 

With MS Access or your favorite database application you could create a query with the same columns as the SO_SalesOrderWrk table but that come from the SO Sales Order History Header and Detail tables.  Then you would redirect a 4.40 SO form to that external table. If you use MS Access you could still have it run off the standard MAS90 custom reports menus (not with MS SQL though - SOTAMAS90 is the only "ODBC" DSN allowed). Other type DSN's like those using native MS Access work.

 

If you are familiar with converting reports and how the data structures changed in the new BO platform it is possible to use a 4.05 version sales order form to print from sales order history (not for the impatient). You have to strip out a lot of stuff, but perhaps a lot quicker than creating one from scratch.

 

Example of a 4.05 SO form printing from 4.40 sales order history:

 

 

Sample SO History reprint using 4.05 SO form

 

 

Dan Burleson
Sage Authorized Consultant - Ask me about advanced scripting!
e-mail me here
Moderator
skirmoochsage
Posts: 181
Registered: 07-09-2010
0

Re: Re-Printing a Sales Order that has been invoiced

Moore, the community has given you some great suggestions to get what you need, but I thought I would chirp in and let you know why you aren't able to reprint those completed orders. When sales orders are invoiced complete, the Sales Journal Update actually removes the records from the open sales order files (SO_SalesOrderHeader, etc). Order/Quote History is retained in different file(s), if being retained, and is purged manually.

 

If there is information that was originally on the order and we don't store this information in Order/Quote History, please feel free to drop us an enhancement request using the Product Feedback link which appears at the top of this page. Other users can vote on your ideas as well.

-------------------------------------------------------------------------------
Have an idea? Submit an enhancement request