LINKED PURCHASE ORDERS AND JOB COSTING - MISSING CORRUPTED INFORMATION

melissa

Hi,

I have one site where they link their purchase orders to Job costing so when placing the PO they choose the job and the cost code it relates to.  After the payroll upgrade was done to 2.70.00 they started to experience issues when using PIR - message was no budget line exists. 

After investigating with the help of Pegasus we realised that when creating a PO and choosing the job and cost code and posting it was posting to the DOLINE table but the do_jline was empty.  This in turn caused the JWIPR table to have a blank jw_line.  The next problem is these have not posted to the JCLINE table either or has posted in but with missing info i.e. no job number so sits corrupted at the top of the table.  

I have been basically adding in the missing line numbers & jcline numbers to DOLINE and JWIPR and appending in the missing info if required in JCLINE and deleting the corrupted lines however, this has been happening now since the payroll upgrade and I am wondering if it could be a defect in that version.  

Has anyone experienced similar issues?

Regards

Melissa

claire-craig

Hi Melissa

Yes we have had customers experience this as well but we then also found they had their PCs recently upgraded to Windows 10.  We fixed the JCLINE and JWIPR tables and also applied the registry DWORD fix (below) to the Opera3 user PCs and so far we haven't had any further issues - most recent one was around 4-5 weeks ago? 

We are very careful however on applying the below as it was only supposedly for certain Windows build but we have found issues creeping back in and we have had to apply this for latest 2004 build so we only apply it on a case by case need 

Add in these entries to the registry:
[HKEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesLanmanWorkstationParameters]
"FileInfoCacheLifetime"=dword:00000000
"FileNotFoundCacheLifetime"=dword:00000000
"DirectoryCacheLifetime"=dword:00000000

Regards

Claire