re-picking and invoicing

[Chris Kelleher]

Hello:

We have a situation where users periodically hit CTRL-C during picking and packing update. I
know. I know! We oughta smack 'em.

What's happening is that they actually ship the product. However, the line item on which they
were working is not properly and/or completely processed. We find ourselves in some of the
following scenarios.

Order-Line rec examples below:

Qty-orig-ord: 30 Qty-shipped: 0
Qty-open-ord: 30 Qty-alloc: 0
Qty-on-pps: 30

Or

Qty-orig-ord: 6 Qty-shipped: 0
Qty-open-ord: 6 Qty-alloc: 0
Qty-on-pps: 0

In both cases, the product has actually gone out the door.

What's the best way to clean this up, NOT re-ship the item, and allow us to generate an invoice?
Programmatically and/or via system menus.

Thanks!

Scott Turnamian

 

[Chris Kelleher]

Scott,
I do not have access to MXP any more, but could you do an invoice by order
or a direct bill? We actually had several issues with the picking/packing
programs. Wait until you ship the product and put it back into stock at the
same time. OUCH!!! Negative quantities on pps is another. These were as of
7.4a and just happen to come to mind right now.

Jim Granfield
K and M Electronics, Inc a subsidiary of
ITT Industries
Engineered for Life

 

[Chris Kelleher]

Before I address the invoicing issue let me ask if you have checked your OP Item Journal. It is
very possible that you
have incomplete items in the journal. This will cause your journal to not reset, leading to all
kinds of fun at month end.

Assuming the item journal is ok, you could try sneaking under the covers and setting drop-ship on
the order-line to 'Yes'
This should allow you to billing the order-lines through op 4 8 without any inventory impact.
(always try in a test environment first).

You might also want to look for orphaned invoice-lines.

My company has completely rewritten the packing update and direct billing functions so there are no
more ctrl-c issues. (and it is significantly faster and locking is rare) If you are interested
that me know.

Rick Wiles
Chief Application Architect
Boston Information Group.
wiles@bostoninfogroup.com
(401) 954-4311