web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Shipped item not refle...
Microsoft Dynamics SL (Archived)

Shipped item not reflected on sales order or invoice

(0) ShareShare
ReportReport
Posted on by Deb Davis 1,515

I have an item that ships on a sales order, but is not reflected on the invoice detail. The amount of the item does display in the total. What might be causing this to occur?

Thank you,
Deb

*This post is locked for comments

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien Microsoft Employee on at

    Hi Deb,

    If you reprint the invoice, does the item appear?

    Or if this is a customized invoice, does the item appear on the standard report?

  • Deb Davis Profile Picture
    Deb Davis 1,515 on at

    Carolyn,

    Thank you. I have tried the reprint and the standard report. Neither of them produce the line for the item.

    Deb

  • Jennifer Spitler Profile Picture
    Jennifer Spitler Microsoft Employee on at

    Deb,

    The line item missing from the invoice - does it appear as a line item on the Sales Order?    The title of your forum implies it does not display as a line item, but, the amount of the missing line is included in the order total.  Was a Shipper created from this Sales Order?  Does the line item show on the Shipper?  If the line item does not exist on the Sales Order and/or Shipper, it will not display on the invoice report.  Since it was included in the invoice total - I would suggest processing a Credit Memo to the customer's account for the amount, then re-invoice this item either on a new Sales Order/Shipper or directly in AR Invoice and Memo.

    Thanks,

    Jennifer Spitler

  • Deb Davis Profile Picture
    Deb Davis 1,515 on at

    Jennifer,

    Yes, the missing line appears on the sales order. Yes, a shipper was created from the sales order. It appears on both the order and the shipper. All indicates that the line was shipped. It just does not appear on the invoice. I understand about crediting the customer's account, but I need to produce an invoice with this item listed. I can't just have it appear in the total. I am not able to reinvoice, as the problem still occurs on the new order. I do not want to have to work around the system. I would like to resolve the issue as to why this item does not print.

    Thank you,

    Deb

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien Microsoft Employee on at

    Hi Deb,

    Sorry for the delay in our response.  I'm not sure if you still need assistance with this issue, but perhaps if you have access to SQL Server Management Studio, you could look at the database records for that shipper id.

    Select * from soshipline where shipperid = 'xxxxxxxx'

    Replace the x's with the shipper id.  Then compare the lines and see if the missing line is any different from the rest.  Let me know what you find.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans