If a ticket has not been imported from WinWeigh the system will create an exception log showing the reason. These logs can be viewed via the below steps:
Hover over Administration
Click on Transactions
Click on the Burger menu in the top-right corner
Click on WinWeigh Exceptions
These exceptions are caused by data mismatches between Weighsoft and the WinWeigh data and need to be corrected in WinWeigh.
Important: If no tickets are importing at all, please raise a case with support so this can be looked into.
Below are the various exceptions that can be encountered, where they need to be resolved and general resolution.
If advice is needed on how to make the correction in WinWeigh, please speak with WinWeigh as Access can only advise on what needs correcting.
Account 'x' not found
This issue is caused by the customer in WinWeigh not tying up with the Account in Weighsoft. The customer on the job will need to be corrected in WinWeigh.
If WinWeigh need to review the data, this stored in the CUSTOMER column of the WEIGHING table.
Address location 'y' not found for customer account x
The address number on WinWeigh cannot be found in Weighsoft. Check under the account in Weighsoft for the correct address number and update WinWeigh with the correct address number.
If WinWeigh need to review the data, this stored in the DESTINATION column of the WEIGHING table.
Product 'x' not found
The product code in WinWeigh is not tallying up with the product code in Weighsoft, this will need correcting in WinWeigh if incorrect, or adding to Weighsoft if already correct in WinWeigh.
If WinWeigh need to review the data, the product stored in the PRODUCT column of the WEIGHING table.
Quantity is null for ticket 'y' at outlet 'x'
This exception occurs if the unit code in WinWeigh is 'P' and no quantity has been set in WinWeigh. Setting the quantity or correcting the unit if incorrect will resolve this.
The unit code in WinWeigh is stored in the UNIT_OF_SALE column on the WEIGHING table and the Quantity is stored in the QUANTITY column on the WEIGHING table.
Outlet 'x' not found
This issue has one of two possible root causes
The incorrect site has been set in WinWeigh
The site is set correctly, but the plant has not been set if required
The site and plant in WinWeigh will need to be corrected as appropriate. If the site needs correcting, WinWeigh may need to manually correct the column ORIGINAL_LOCATION on the WEIGHING table to match the SITE seen in the front end of WinWeigh.
Note: You may also want to check if an EWC code is set as required as this will also affect the outlet selected on import (if there is an EWC a waste outlet is selected, otherwise a material outlet is selected).
Ticket y: Outlet 'x' cannot process EWC w
This issue stems from the EWC in WinWeigh not being available to the outlet in Weighsoft. Check and correct the EWC in WinWeigh, or if the EWC is correct the EWC will need adding to the list of EWC Codes available to the outlet in Weighsoft.
If WinWeigh need to correct the EWC, this is stored in the EWC_CODE column on the PRODUCT table.