Start a conversation Sign in
Start a conversation
  1. horizongosupport
  2. Source Default Category
  3. Source Default Folder

How To - Correct duplicate items on aging report (DNP)


Overview:
I have some items that have duplicated on my aging report.  Where did they come from?  How can I get rid of these duplicate items.  I have already tried indexing and recalculating the customer balances.

Steps:

From FDW
  1. use mfcust
  2. ?reccount()
  3. index on custno unique to temp
  4. count to customers
  5. ?customers
  6. If the value displayed in #5 is less than the number in #2 then there are duplicates in the customer file

.....if there are duplicates........


  1. copy to mfuniq
  2. close databases
  3. use mfcust exclusive
  4. copy to mfcback
  5. zap
  6. append from mfuniq
  7. quit

Note: Be careful when doing this, make sure you make a backup of the entire customer file in step 10, or go to a DOS prompt and make a copy of mfcust.dbf to mfcback.dbf
Choose files or drag and drop files
Was this article helpful?
Yes
No

  1. Bob Hogan

  2. Posted

Comments