AGRIS Customer Documentation

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

General Information

How long will a purge take?

Purge times take an average of 4 MB per minute.

Is there an order I should Purge in?

Packages can be purged in any order except for ACP-ACR-INV. ACP & ACR must be purged before INV.

For more information on purging (checklists, how-to, etc): How to Purge a Dataset.

ACP

  • VOUCHERS MUST BE MARKED ACTUAL TO PURGE

  • The dates that control the purge criteria are not affected by marking vouchers actual, so they can be marked actual on today’s date & they will still purge.

FILES PURGED

ACCOUNTS PAYABLE FILES

  • ACCPAY.ACP

  • DISBURSE.ACP

  • ACPGLDTL.ACP

  • ACPTOTAL.ACP

ACCOUNTS PAYABLE REMARKS FILE

  • ACPRMRKS.ACP

ACR

  • Finance charge invoices are processed through one extra date criteria.  They must be at least 18-months older than the Accounting Date Groups Default Date.  This is done so that Cumulative Finance Charges may still be run on statements.

FILES PURGED

ACCOUNTS RECIEVABLE FILES

  • ACCREC.ACR

  • ACRTRAN2.ACR

  • PAYMENTS.ACR

  • ACRGLDTL.ACR

  • ACRTOTAL.ACR

  • ACRRMRKS.ACR

ACCOUNTS REVIEVABLE REMARKS FILE

  • ACRRMRKS.ACR

ACCOUNTS RECEIVABLE HISTORICAL BALANCE FILES

  • HISTORY.ACR

ACCOUNTS RECEIVABLE CONTACT INFORMATION FILE

  • CONTACT.ACR

ACCOUNTS RECEIVEABLE BUDGET AGREEMENTS FILE

  • ACRBBMST.ACR

AGY

  • AgroGuide does not have a purge function to delete history, but it does have a purge function to wipe out a client.

  • AgroGuide will not allow a name/address record to be deleted if there is a field history or blend record attached to that name id.

  • AgroGuide has built in the ability to “remove” the key but leave the record for regulatory purposes.
    AGY > AgroGuide > Displays the window that shows farm name tree > go to ACTIONS > Purge client > merge field attributes to the new name id, then you can delete the old name id in AGRIS name/Address.

BNK

  • ONLY RECONCILED TRANSACTIONS WILL PURGE.

  • Uses Ledger date on transactions to purge

FILES PURGED

BANK FILES

  • BANKACCT.BNK

  • BNKGLDTL.BNK

  • BNKTOTAL.BNK

CFT

FILES PURGED

COMMUNICATION LOG – AGLOGIC

  • E01COLOG.CFT

COMMUNICATION LOG – ATLAS

  • E01COLOG.CFT

COMMUNICATION LOG – PASSPORT POS

  • E01COLOG.CFT

COMMUNICATION LOG – AGRIS WEB SERVICES

  • E01COLOG.CFT

COMMUNICATION LOG – DTN MARKET INFORMATION

  • E01COLOG.CFT

COMMUNICATION LOG – PINNACLE PALM POS

  • E01COLOG.CFT

INV

FILES PURGED

INVENTORY DELIVERY TICKETS FILE

  • DTICKETS.INV

INVENTORY SALES/PURCHASE ORDERS FILE

  • INVORDS2.INV

  • ORDERS.INV

INVENTORY ACTIVITY FILES

  • INVTRAN1.INV

  • INVTRAN3.INV

  • INVTRAN4.INV

  • INVTRAN5.INV

  • INVTRAN6.INV

  • INVTRAN7.INV

INVENTORY INACTIVE SUBITEMS BALANCE FILES

  • INVTOTAL.INV

INVENTORY SPECIFICATIONS/REMARKS FILE

  • SREMARKS.INV

INVENTORY AUDIT FILE

  • INVAUDIT.INV

OPERATIONAL COSTS

  • I34ALLOC.INV

GRN

  • The grain package is unique in that it will cycle through the same files during each document type purge.

Settlements

a.      If this is a voided Settlement and the void date < purge date, then purge.

b.      If the settlement date > or = purge date, then do not purge.

c.      If this Settlement includes a partial payment on a Delivery Sheet Application that was not fully paid before the purge date, then do not purge.

d.      If none of the above is true, purge all records for this Settlement.

Contracts

a.      If the Contract status <> “S”, then do not purge.

b.      If the due date > or = purge date, then do not purge.

c.      If units applied /canceled > contract units, then do not purge.

d.      If any pricing or cancelation dates > or = purge date, then do not purge.

e.      If any of the delivery Sheet Applications for this contract were not paid before the purge date, then do not purge.

f.       If none of the above is true, purge this Contract.

Scale Tickets

a.      If void ticket and ship date < purge date, then purge.

b.      If transfer ticket and ship date > purge date and hauler voucher numbers exist and no estimates exist, then purge.

c.      If estimated weights, grades or freight, then do not purge.

d.      If hauler voucher number does not exist, then do not purge.

e.      If all applications are not on Delivery Sheets, then do not purge.

f.       If the Delivery Sheet is not paid, then do not purge.

g.      If the date paid > or = purge date, then do not purge.

h.      If the Contract exists, then do not purge.

i.        If the Settlement exists, then do no purge.

j.        If none of the above is true, then purge this ticket.

Delivery Sheets

a.      If this is voided Settlement detail and the Settlement does not exist, then purge.

b.      If this is a voided delivery Sheet and the date voided < purge date, then purge.

c.      If the Delivery Sheet is not paid, then do not purge.

d.      If the date paid > or = purge date, then do not purge.

e.      If the Contract exists, then do not purge.

f.       If the Settlement exists, then do not purge.

g.      If any Scale Ticket Applications exist, then do not purge.

h.      If none of the above is true for all the applications, then purge all applications for this Delivery Sheet.

Daily Position Information

a.      If the date is less than purge date, then purge.

Warehouse Receipts

a.      If the Warehouse Receipt is still active, then do not purge.

b.      If the date cancelled > or = purge date, then do not purge.

c.      If Delivery Sheets exist for the Receipt, then do not purge.

d.      If none of the above is true, then purge this Receipt.

Contract Pricing

a.      If the Contract does not exist, then purge.

Contract Remarks and Delivery Schedules

a.      If this is a Standard Remarks, then do not purge.

b.      If this is not a Standard Remark and the Contract does not exist, then purge.

Scale Ticket Applications

a.      If the Ticket does not exist, then purge.

FILES PURGED

GRAIN SETTLEMENTS FILES

  • SETTLMNT.GRN

  • CUSTOTAL.GRN

  • GRNCONT3.GRN

  • GRNCONT4.GRN

  • GRNRMRKS.GRN

  • GRNCONT5.GRN

  • GRNCONT6.GRN

GRAIN CONTRACTS FILES

  • CONTRAC1.GRN

  • CONTRAC2.GRN

  • GRNCONT3.GRN

  • GRNCONT4.GRN

  • GRNCONT5.GRN

  • GRNCONT6.GRN

GRAIN TICKETS FILES

  • TICKETS1.GRN

  • TICKETS2.GRN

  • GRNTKTS3.GRN

  • GRNTKTS4.GRN

  • GRNTKTS5.GRN

  • GRNCONT3.GRN

  • GRNCONT4.GRN

  • GRNRMRKS.GRN

  • GRNCONT5.GRN

  • GRNCONT6.GRN

GRAIN DELIVERY SHEETS FILES

  • DSHEETS1.GRN

  • DSHEETS2.GRN

  • GRNCONT3.GRN

  • GRNRNKS.GRN

  • GRNCONT4.GRN

  • GRNCONT5.GRN

  • GRNCONT6.GRN

GRAIN POSITION FILES

  • POSITION.GRN

  • HDGECHGN.GRN

  • GRNDPRCH.GRN

GRAIN WAREHOUSE RECEIPTS

  • WHSRECPT.GRN

PEDIMENTO

  • C61PDMNT.GRN

NAM

  • Purging of name/Address only purges Inactive or Temporary Name ID’s.

  • Due to the small amount of disk space that can be reclaimed, purging name/address is not worth the time investment.

FILES PURGED

  • NAMEADDR.NAM

  • RELATION.NAM

  • COMMENTS.NAM

  • NAMSPLTS.NAM

  • NAMLICEN.NAM

  • SPLGROUP.NAM

  • N10FARMS.NAM

  • N11FIELD.NAM

PAY

  • Purging Payroll is STRONGLY not recommended.

  • The amount of disk space recovered is not worth issues that may develop in reporting requirements if needed for audit purposes. But if they are purging Payroll, this option allows you to remove Labor Distribution, Paycheck detail, Employee YTD totals & Employee Information.

  • All tax reports should be run for purged period.

  • W-2 Forms should be printed & W-2 Diskette created for purged periods

FILES PURGED

  • EMPLOYEE.PAY

  • EMPDEDUC.PAY

  • EMPTOTAL.PAY

  • PAYCHECK.PAY

  • JOBHOURS.PAY

  • EMPSPLIT.PAY

PAT

FILES PURGED

  • PRODUCED.PAT

  • REFUNDED.PAT

  • PATAUDIT.PAT

SJI

FILES PURGED

SYSTEM JOURNAL ENTRY FILE

  • SPERIODS.SJI

  • SYSENTRY.SJI

EXECUTION ID MASTER FILE

  • SYSEXBUD.SJI

  • SYSEXMST.SJI

LEDGER DETAIL FILE

§   

SYS

FILES PURGED

SYSTEM DELETED RECORDS FILE

§  TRANSACT.AGR

o   SYSTEM ERROR LOG FILE *This will purge all datasets, not just the one you are purging*

§  ERRORLOG.AGR

o   SYSTEM ACTIVITY LOG FILE

§  ACTIVITY.AGR

o   SYSTEM DOCUMENT TRACKING FILE

§  SYSTRANS.AGR

o   SYSTEM LOGIN LOG FILE

§  SYSLOGIN.AGR

o   USER OVERRIDE HISTORY FILE

o   REPORT STREAM LOG FILE

 

 

 

 

  • No labels

✦✦✦

3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2011 - 2024 Cultura Technologies LLC. All Rights Reserved Worldwide.  Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.