RPI Consultants Knowledge Base

Coding to the Inventory Account… from AP!

It happens way more often than organizations realize.  Invoices get coded directly to the inventory account – which is no bueno when we are talking about a balance sheet GL account that is purportedly supposed to tie to a sub system (and that system is IC, not AP!)

So why do we see directly Coded Invoices and Credits for Inventory Items in the first place?   Don’t inventory items need to come through a PO to be received in as Inventory in the first place?   Yes, they sure do!

But sometimes we have instances where charges for a PO are credited and re-invoiced for an already matched line.  There is Lawson functionality to handle this (MA75 PO Invoice Cancel – more on that below), but quite often, with approval from purchasing, the invoice, and the credit are simply processed as Expense (/Non-PO) type invoices and coded to the Accounting Unit/Account distribution on the PO Line.You know what I mean...

This actually works for Non-Stock, Special and Service Items where it basically nets to the correct GL postings for the AU and Expense Account.

For Inventory items, however, the distribution on the PO Line is coded to the balance sheet (i.e. GL inventory account).  Coding to this account on the invoice will cause discrepancies between the Inventory Balance as reflected in the IC module and the GL Account.  Some of our clients use system restrictions at the Chart of Accounts (GL00) or Accounting Unit (GL20) level to only allow relevant Subsystems to post to the inventory asset account, thereby systematically preventing this reconciling issue from arising.

To find out if this might be an issue in your company simply export GL transactions for the inventory account and look for anything with a source system of “AP.”

Four tips to address this issue:

Leverage MA75 PO Invoice Cancel

This screen operates in a similar manner to Lawson’s MA70 Reverse Match (Inquire on Company, Vendor, Invoice > Select Reverse Match), except that MA70 is used for invoices that have not been posted or paid and allows you to bring up the invoice in AP30.4 in order to cancel it.

Once a PO invoice has dependent records (posted GL distributions or payments) Lawson is going to make use live with it forever.

What the MA75 does, it allows to automatically:

  • Create a credit that balances out payment and distributions for the original (and historical) invoice.
  • Unties the PO from Invoice, making it available for future matches

In the event of a ‘credit and rebill’ the credit would automatically be generated by MA75 and the ‘rebill’ invoice could be entered and matched appropriately.

The MA75 process may also be useful in a situation where invoices have been mismatched to a PO and subsequent Invoices required lines that are now closed.   Or in the event you have some crazy MNR postings and need to reverse them out for GL purposes.   When you re-entered the PO Invoice in these scenarios (with a period at the end to distinguish) and matched it correctly to the PO,  the new invoice and PO Cancel credit will result in $0 payment to the vendor.

Use the Inventory Tolerance Account

If for whatever reasons, processing an Expense (Non-PO) Invoice for an Inventory Item is the best course of action, considering leveraging the Inventory Tolerance Account as listed in the IC04 GL Category for that item and coding the Invoice and Credit to this account.   Remember when inventory transactions or values get funky, all roads lead to the Inventory Tolerance Account!

Populate PO Numbers on EXP (Non-PO) type invoices and Credits

This actually applies to all Non-PO invoices processed in relation to Purchase Orders, including direct coded any credit and re-bills, or invoice adjustments for closed PO Lines that are currently coded as EXP type invoices.   Always have the PO Number on AP20 populated with relevant PO!  While not a required field, it will allow the invoice/credit to be drillable from PO20 and make it available for queries and reports against the PO.

Leverage Subsystem Controls for Specific GL Accounts

We recommend the following GL Accounts be limited (in GL00 or GL20) to postings from specific subsystems as follows:

  1. AP Liability Account(s) – limited to AP
  2. Inventory Account(s) – limited to RQ, IC, PO and GL
  3. Received not Invoiced / PO Receipt Accrual account(s) – limited to IC, PO, AP, MA and GL

Access GL00.4 Account Information, select the systems button.

Access GL00.4 Account Information, select the systems button.

Enter allowed posting systems.

Enter allowed posting systems.

Want More Content?

Sign up and get access to all our new Knowledge Base content, including new and upcoming Webinars, Virtual User Groups, Product Demos, White Papers, & Case Studies.

[gravityform id=”4″ title=”false” description=”false” ajax=”false” /]

Follow us online for faster access to announcements, knowledge base updates, and upcoming events!

Entire Knowledge Base

All Products, Solutions, & Professional Services

Contact Us to Get Started

Don’t Just Take Our Word for it!

See What Our Clients Have to Say

Denver Health

“RPI brought in senior people that our folks related to and were able to work with easily. Their folks have been approachable, they listen to us, and they have been responsive to our questions – and when we see things we want to do a little differently, they have listened and figured out how to make it happen. “

Keith Thompson
Director of ERP Applications

Atlanta Public Schools

“Prior to RPI, we were really struggling with our HR technology. They brought in expertise to provide solutions to business problems, thought leadership for our long term strategic planning, and they help us make sure we are implementing new initiatives in an order that doesn’t create problems in the future. RPI has been a God-send. “

Skye Duckett
Chief Human Resources Officer

Nuvance Health

“We knew our Accounts Payable processes were unsustainable for our planned growth and RPI Consultants offered a blueprint for automating our most time-intensive workflow – invoice processing.”

Miles McIvor
Accounting Systems Manager

San Diego State University

“Our favorite outcome of the solution is the automation, which enables us to provide better service to our customers. Also, our consultant, Michael Madsen, was knowledgeable, easy to work with, patient, dependable and flexible with his schedule.”

Catherine Love
Associate Human Resources Director

Bon Secours Health System

“RPI has more than just knowledge, their consultants are personable leaders who will drive more efficient solutions. They challenged us to think outside the box and to believe that we could design a best-practice solution with minimal ongoing costs.”

Joel Stafford
Director of Accounts Payable

Lippert Components

“We understood we required a robust, customized solution. RPI not only had the product expertise, they listened to our needs to make sure the project was a success.”

Chris Tozier
Director of Information Technology

Bassett Medical Center

“Overall the project went really well, I’m very pleased with the outcome. I don’t think having any other consulting team on the project would have been able to provide us as much knowledge as RPI has been able to. “

Sue Pokorny
Manager of HRIS & Compensation

MD National Capital Park & Planning Commission

“Working with Anne Bwogi [RPI Project Manager] is fun. She keeps us grounded and makes sure we are thoroughly engaged. We have a name for her – the Annetrack. The Annetrack is on schedule so you better get on board.”

Derek Morgan
ERP Business Analyst

Aspirus

“Our relationship with RPI is great, they are like an extension of the Aspirus team. When we have a question, we reach out to them and get answers right away. If we have a big project, we bounce it off them immediately to get their ideas and ask for their expertise.”

Jen Underwood
Director of Supply Chain Informatics and Systems

Our People are the Difference

And Our Culture is Our Greatest Asset

A lot of people say it, we really mean it. We recruit good people. People who are great at what they do and fun to work with. We look for diverse strengths and abilities, a passion for excellent client service, and an entrepreneurial drive to get the job done.

We also practice what we preach and use the industry’s leading software to help manage our projects, engage with our client project teams, and enable our team to stay connected and collaborate. This open, team-based approach gives each customer and project the cumulative value of our entire team’s knowledge and experience.

The RPI Consultants Blog

News, Announcements, Celebrations, & Upcoming Events

News & Announcements

High Fives & Go Lives

Go to Top