Note: This issue was originally created because of the "Purchase Order" report, but all similar reports that might be sent to a supplier need similar changes, like "Outstanding Purchase Orders (Detail showing item lines)" report.
ISSUE 1:
The first column of the report contains two item numbers like this:
Header: Item Name
Detail: CB iItemName (Supplier Part Number)
The above is no good out of the box, it is unreadable, and suppliers want to see their item number first. This needs to be changed to:
Header: Supplier # / Item Name
Detail: Supplier Part Number / CB Item Name
The exiting view can easily be changed like this:
ISNULL(i.PartCode,'') + ' / ' + ISNULL(b.ItemName,'')
ISSUE 2:
Remove decimals places from quantity ordered (CB does not allow partial qty) (same problem in many places in CB)
ISSUE 3:
Add more columns to the view so w don't have to customize it, add:
a.SupplierCode
a.UserModified
a.UserCreated
Note: This issue was originally created because of the "Purchase Order" report, but all similar reports that might be sent to a supplier need similar changes, like "Outstanding Purchase Orders (Detail showing item lines)" report.
ISSUE 1: The first column of the report contains two item numbers like this: Header: Item Name Detail: CB iItemName (Supplier Part Number)
The above is no good out of the box, it is unreadable, and suppliers want to see their item number first. This needs to be changed to: Header: Supplier # / Item Name Detail: Supplier Part Number / CB Item Name
The exiting view can easily be changed like this: ISNULL(i.PartCode,'') + ' / ' + ISNULL(b.ItemName,'')
ISSUE 2: Remove decimals places from quantity ordered (CB does not allow partial qty) (same problem in many places in CB)
ISSUE 3: Add more columns to the view so w don't have to customize it, add: a.SupplierCode a.UserModified a.UserCreated