Partial shipments and back orders in SOP

What is the proper procedure when shipping and invoicing partial shipment and creating back orders?  Here is what we would like:

1.  Order is entered in Sales Transaction Entry screen for 100 units of a part (not drop shipped, we manufacture it)
2.  We ship 50 to the customer.  At this point we would like the Sales Order to show 100 Ordered, 50 Shipped, and 50 B/O.
3.  We ship 20 more to the customer.  No we would like the Sales Order to show 100 Ordered, 70 Shipped, and 30 B/O.

For some reason our sales order always prints 0 in the Shipped column, even if there is a quantity on left back order.  We are not creating backorder orders, we are just filling in the Qty to Invoice, Qty to Fulfill, and Qty to Back order on the sales order, then using the Actions/Transfer option and check the Transfer to an Invoice checkbox (Create BackOrder is unchecked because we don't want to create a separate Back Order order).

Any help would be appreciated.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

It sounds like your processes ok....I just tested it on our test system and it works ok here, these are the steps I followed.

1.  I entered an Order for 100 units and back ordered all 100
2.  Fulfilled 50 and Invoiced 50 and transferred to an invoice.

The invoice showed 100 ordered, 50 shipped and 50 on back order

This is where I ran into the problem; once the invoice is transferred it updates the quantities on the order.  The order now says there is 100 on order and 50 back ordered.

If I fulfilled and ship 20 more

The invoice now shows 100 ordered, 20 shipped and 30 on backorder.

If you would like it to show 70 shipped you can create a modified field in the report that takes the Qty ordered - Qty cancelled - qty on back order and it should show you the total shipped.

If your sales order is always printing 0, I am thinking there is something wrong with the formula in your report.

The formula I have in my report is......

A conditional formula
Result Type is Currency

Conditional: SOP_Line_Work.QTY < 0.00000
True: SOP_Line_Work.Qty
False: SOP_Line_Work.Qty_To_Invoice

Let me know if you have any other questions or if I need to clarify anything.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chad_J_LemmerAuthor Commented:
Thanks for pointing me in the right direction.  I ended up changing the field in the Shipped column to the "Qty Prev Invoiced" from the Sales Transaction Amounts Work table.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.