Versions Compared

Version Old Version 1 New Version 2
Changes made by

Tina Brady (Deactivated)

Tina Brady (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Accounts Receivable > Reports > Shipped Not Invoiced sometimes returns Shipments that are not returned in AR Invoice Entry > Actions > Get Shipments > View Not Invoiced Packing Slips. If this happens, review

  • Verify the Shipment Lines and Header are marked Shipped Complete

  • Uncheck the Invoice when Complete checkbox on the associated Sales Order headers.

Invoice when Complete
This field specifies an invoice to be created only when the associated sales order is completely shipped. If not all sales order releases are shipped, no invoices will be created when the Get Shipments action or the Generate Shipment Invoices process is executed. This validation occurs for both regular shipments and drop shipments. Image Removed

...

This SQL select will get a list of the help locate Sales Orders for the Packs. Use DMT to update InvcOrderCmp from 1 to 0

selectdistinct OH.Company,OH.OrderNum, C.CustID CustomerCustID, OH.InvcOrderCmp

from ERP.OrderHed OH, ERP.Customer C, ERP.ShipDtl SD

where C.Company=OH.Company and C.CustNum=OH.CustNum and OH.Company='CC5'

and C.Company=SD.Company and OH.OrderNum=SD.OrderNum and SD.PackNum in(6628,7098,6977,7093,7103,7095,7096,7178,7179,7181,7159,7313)

orderby OH.Company, OH.OrderNum