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
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.
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
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
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?
#1
André Arnaud de Cal...
292,688
Super User 2025 Season 1
#2
Martin Dráb
231,643
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
