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
46206 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

When I try to enter a 3-way match invoice with zero cost items, I get an error 'Must have value/cost entry.

Resolution
​ACP500 requires a positive value to create a 'C' transaction when entering a 3-way match invoice. If you are receiving inventory items for free (no charge) and have a purchase order for it and need to include the quantity in inventory, you should first receive your items through PUR550 using something like a 'U' transaction. Then, you would enter a 'C' transaction with the quantity and zero cost through PUR550. This will change the status of the line in the HPO file to '3', fully received and costed. Once this is completed, you will be able to enter an invoice for your zero-cost item through ACP500 without getting the error message 'Must have value/cost entry.

First1415161719212223Last

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