Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Kathy Barthelt
/ Categories: Infor LN & Baan Tips

Infor LN / Baan Tip of the Week: Deleting Records

To improve performance and reduce database growth, deleting records is highly effective. The disadvantage of deleting records is that data is no longer available. Usually, however, not all records need to be saved. For example, line activities are stored by warehouse. Normally, you do not need to keep these records. Therefore, after closing a warehouse order, line activities can be removed. The User's Guide for ERP LN Archiving describes several sessions you can use to delete old data. Other data such as items and business partners can be reviewed once in a while, after which you can delete the data you no longer need. For every order and contract table a session is available to archive and delete old orders. In these sessions, you can specify several characteristics to select the orders to be removed, such as date or status. Run these sessions on a regular basis.
Previous Article Explore your IDF programs
Next Article Infor LX / BPCS Tip of the Week: Optional Authority to Maintain Reason Codes
Print
46164 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

INV810 only deletes the sequence number from the ILI of the item so it is not selected again for counting and does not delete the ICY record.

The ICY Cycle Count sequential history file increases in size with each new cycle count session. Running INV015 will purge all the old ICY records up to the date entered on the set-up screen ‘Enter Cycle Count Ending Date’ field. Physically deleting the old ICY files.

In most cases, when you complete the cycle count posting and run the reports, you can reconcile the data as required. After you reconcile the data for a specific day (or group of days), you can run INV015 to purge the data for that day (or group of days).

It’s almost that time of year – AND with Crossroads RMC and Avalara, you can e-file your 1099s and other forms simply and easily!

If you plan to e-file more than 2,500 forms this year, please let us know and we’ll connect you with our Avalara representative for custom pricing. Otherwise, the link below is completely self-service. Watch the short YouTube video at the bottom of the linked page for a quick walk-through tutorial, and you’ll be ready to get started immediately!   

Learn more> Avalara 1099

First1314151618202122Last

Theme picker

Tips: LN | Baan

All actions required for converting, validating, matching, and posting electronically received bank statements can be performed within a single session:

  • Bank Statement Workbench (tfcmg5610m100)
  • Bank Statement (tfcmg5610m000)

Alternatively, you can use the sequence of electronic bank statement sessions outlined below.

Steps to Process Electronic Bank Statements:

1345678910Last

Theme picker

Categories