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

Anthony Etzel
/ Categories: Infor LX & BPCS Tips

BPCS/LX Tip of the Day: Inventory Management

Establishing the Quantity On-Hand and the Quantity Available.

LX maintains buckets for information associated with the following inventory transactions for each item:

  • Opening Balance
  • Issues
  • Receipts
  • Adjustments
  • Allocations for the Customer
  • Allocations for Manufacturing

 

The on hand quantity does not include any allocations. To arrive at the on hand quantity, start with the opening balance, less any issues, plus any receipts, then add or subtract any adjustments. Available inventory is the on-hand less any allocations.

 

Previous Article Baan/LN Tip of the Day: Chart of Accounts
Next Article Baan/LN Tip of the Week: Back Dating Cycling Counting Orders
Print
45064 Rate this article:
No rating
Anthony Etzel

Anthony EtzelAnthony Etzel

Other posts by Anthony Etzel

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.

First1213141517192021Last

Theme picker

Tips: LN | Baan

Instead of sharing tables through logical linking, you can replicate table content between companies. This approach allows certain non-key attributes of a record to vary by company. For example, if you replicate bills of materials rather than sharing them, each company can associate a different warehouse with the same bill of material. This way, the bills of materials are consistent across companies, while the warehouses can differ.

Replication also enables selective availability of records in other companies. For instance, when replicating items, you might limit which items are available in a sales company based on their item group, only including end items. You can further refine replication to specific subsets, such as particular item groups.

Keep in mind that replication requires any referenced tables to be either replicated or shared as well.

12345678910Last

Theme picker

Categories