A COA (Certificate of Analysis) must be linked to a received product’s batch (LOT) number. This is specifically required in the chemical, food, and pharmaceutical industries. These COAs are usually required when a product is sold to a client or is used as a reference for quality control.
Start by entering a From and To Receipt Date OR enter a GRN number
Select or deselect the Only Show When COA Number is ‘NONE’
If Only Show When COA Number is ‘NONE’ is not selected, it will display the lines where a COA is already linked.
Select the Refresh icon to load the data grid
The screen will display all Purchase Orders where a COA is required and the COA number is equal to NONE
Select a line on the grid, the blue fields for stock codes, PO number will populate
Enter a COA number and select the word Link
SPECIAL FEATURES
The user must first enter a COA number during the PO Receipt process. If the number is not available, the user must enter NONE. A Custom Form field must be created for this in SYSPRO
TECHNICAL
To record a COA number, a System Setting must be updated. Select Settings / System Settings from the Ribbon bar and locate RECEIVING in the System Name drop-down. Update the COA_REQUIRED_FIELD value to Y(es).
SYSPRO REQUIREMENTS & Business objects used
A GRN number is generated within SYSPRO and then passed to WMS.
REFERENCE
REC002
FUNCTIONALITY OVERVIEW
COA’s (certificate of analysis) are used by DATASCOPE clients in the chemical, food and pharmaceutical industries. These certificates are linked to the batch (LOT) number of the product being receipted. When this product is sold on to a client these certificates are often needed to pass onto the customer, or used for reference as quality control.
During PO receipt a COA number is requested if the Custom form field (specified in the system setting Receiving> COA Required Field) is Y for the stock code being receipted.
The user enters a COA number or if not available enters the word NONE.
This screen will display all entries where a COA is required and the COA number is NONE
STANDARD PROCESS
Use the date filters or GRN number to populate the grid
Select a line on the grid, the blue fields for stock code, PO number, line will populate
Enter a COA number and click link
SPECIAL FEATURES
Selecting or de selecting the Only show where COA numbers is NONE will show all liens with COA’s linked too
TECHNICAL
Relevant Settings
SYSPRO Requirements & Business objects used
None
DATASCOPE Table updates
tblPalletItem - COANumber