Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Regular Contributor
dlevasseur
Posts: 182
Registered: 11-13-2008
0

SO Shipping not updating Quantity Shipped on SO Entry Lines?

We've been fighting a problem where every so often an order gets shipped, but the Quantity Shipped is not updated on the SO Lines.  The history is updated properly, but SO Lines will still show 0 shipped even though the order is complete.

 

Anyone else having funky problems with SO Entry/Shipping?  There have also been some issues with backorders updating.

 

So far I haven't been able to recreate the issue at will, it just seems to happen every so often.

 

MAS90 v4.4.0.2

-Dan
Regular Contributor
mattk
Posts: 57
Registered: 03-04-2009
0

Re: SO Shipping not updating Quantity Shipped on SO Entry Lines?

We have all kinds of problems with backorders and totals. MAS 90/200 has some major bugs in this area that are not being properly addressed. The LastExtension field in SO History is not accurate, as it shows the Total Extension, not the last extension. I am finding that some sales orders (in the history files), after shipping wind up with 0 qty orderedoriginal, 0 qty orderedrevised, 0 qty backordered... So it is actually a good thing that the LastExtension amount is the total extension, because it winds up being the only way I can recalculate the order total so that I can correct the incorrect totals which get written to SO_salesorderhistoryheader.
Matthew C. Kaney
Regular Contributor
dlevasseur
Posts: 182
Registered: 11-13-2008
0

Re: SO Shipping not updating Quantity Shipped on SO Entry Lines?

I have found that this seems to be order specific.  I have found a few of my orders that end up with this problem and can freely replicate the issue in a test box.

 

Other than updating to SU3, any other suggestions on where to start looking?

-Dan
Regular Contributor
dlevasseur
Posts: 182
Registered: 11-13-2008
0

Re: SO Shipping not updating Quantity Shipped on SO Entry Lines?

SU3 did not fix the issue.

-Dan
Regular Contributor
dlevasseur
Posts: 182
Registered: 11-13-2008
0

Re: SO Shipping not updating Quantity Shipped on SO Entry Lines?

Hrm...  Turns out my user defined scripts on SO_Entry_Header are causing this.

 

I had two Post Validate scripts in place.  One to msgbox a warning if a certain termscode was used and a second that would copy the ordertype into a storagevar when changed.

 

If either of these scripts where enabled, backorders would not be brought to the lines properly.  But not all backorders.  I haven't been able to find similarities between the orders to see why these scripts would make a difference to that specific order.

 

Also, why would User Defined Scripts have anything to do with transaction processing?

-Dan