This applies to ar,ic,ap.
For AP check the APDISTxx file fields GLPER,GLFYEAR,trandte
For AR check the ARDISTxx file fields GLER,GLFYEAR,trandte
For AR check the ARDISTxx file fields GLPER,GLFYEAR,trandte
Open foxpro and in the command window:
type the following command:
SET CENTURY ON
Open the cooresponding table,(apdistxx,icdistxx,ardistxx)
type the following command for example:
USE f:\pro50\ardata\ardistxx SHARED
type the following command:
SET FILTER TO EMPTY(glper)
This will give you records with missing data. Fill the corresponding fields, GLPER,GLFYEAR,TRANDTE
EMC