APIntercoData Error: 3315 DAO.Recordset Field
'PO_Line_Item_Data.Bin' cannot be a zero-length string
This error may result from leaving the Bin field blank in the PORV screen. A similar message may result from leaving the Stk blank also. To correct this problem, the parameters of a table in the Modgldb.mdb file need to be changed.
- In the Dasm folder, open the Modgldb.mdb data base
- Click on the Tables tab
- Right click on PO_Line_Item_Data and click Design View
- Click on the Bin field
- Click on the General tab in Field Properties
- Click on the property called "Allow Zero Length"
- Select Yes
- Save the changes and exit the table and the database
Open Windows Explorer in the Mfgsys folder for the following steps:
- Delete the Modcomap.mc
- Delete the Modcomsl.tmp
- Rename the Modcomgl.mc to Modcomgl.hld
- Rename any modcom mcx files to mc
- Run the applicable module communication process, such as APMC, IVMC or Load Daily Transactions. Do not run GLMC yet.
- Run the Daily Allocation Tool (Interco.exe) again
- If you choose you may run APMC, GLMC, IVMC and move the Modcomsl.mc to the SAAM folder. Or you can wait until the next nightly batch and records from the current day's processing will be appended to the mc files.