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
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (