kimdandnavbc.com

  • Home
  • Blogs
  • About
  • Contact

Inventory

Inventory

Inventory Expected Cost and Subcontractors Purchase Orders, Oh and WIP…

So you use subcontractor work centers in routings for items that you produce and you find that the Planning Worksheet effectively creates your productions orders. Followed by the Subcontract Worksheet creating the associated purchase orders. Receipts from the purchase orders, create output entries against the production orders and life is Read more…

By kdallefeld, 5 months ago
Inventory

Inventory to GL Reconciliation – WIP

Inventory reconciliation for companies using production orders is not complete without discussing production order work-in-process (WIP). Flushing methods can impact when entries are made to WIP as can subcontract purchase orders. The following flow is based on manual flushing. Consumptions against a production order add dollars to WIP (debit for Read more…

By kdallefeld, 6 monthsAugust 15, 2022 ago
Inventory

Inventory to GL Reconciliation – Chapter 6 – Abnormal Date

First thought, is ‘how can a date be abnormal?’ A date is a date, right? Well, the point is that it’s abnormal to have an invoice date on a purchase order before the receipt date of the product.  Okay, I realize that for many of us this is not true, Read more…

By kdallefeld, 7 monthsJune 27, 2022 ago
Inventory

Inventory to GL Reconciliation – Chapter 8 – Purchase Orders

First, I tell you that you might have abnormal dates and now I’m saying that your purchase orders can cause an out of balance issue. You’re probably thinking what? How? Let’s think through this flow: PO has quantity and unit cost on each line Purchase Order Receipt – creates an Read more…

By kdallefeld, 7 monthsJune 20, 2022 ago
Inventory

Inventory to GL Reconciliation – Chapter 7 – Adjust Cost

The most common reaction I see, when telling someone that your out of balance issue is related to Adjust Cost is, “but I have Automatic Cost Posting turned. and with Automatic Cost Posting, I thought it took care of Adjust Cost and you didn’t have to run manually.” What does Read more…

By kdallefeld, 7 monthsJune 20, 2022 ago
Inventory

Inventory to GL Reconciliation – Chapter 5 – The Report

When someone inquires as to how to reconcile their inventory to the general ledger or someone complains ‘my inventory does not tie to my general ledger’, my first response is a question……What report are you using to do your reconciliation?  The majority of the time, the answer is ‘Inventory Valuation.’  Read more…

By kdallefeld, 7 months ago
Inventory

Inventory to GL Reconciliation – Chapter 4 – Posting Groups

Inventory posting groups control the balance sheet portion on entries relating to inventory. When inventory posting groups do not ‘line up’ to the desired group of items, it typically points to a change on the item card without an associated change in the general ledger. In more drastic out of Read more…

By kdallefeld, 8 monthsMay 31, 2022 ago
Inventory

Inventory to GL Reconciliation – Chapter 3 – Posting Setups

We always talk about the importance of posting setups; no where is it as important as when it comes to subledger reconciliations. There are two posting setups that are important related to inventory subledger reconciliation – inventory posting setup and general posting setup.  Inventory posting groups combine with location code Read more…

By kdallefeld, 8 monthsMay 24, 2022 ago
Inventory

Inventory to GL Reconciliation – Chapter 2 – Direct Posting

What is direct posting? It’s a toggle/flag/checkbox on a general ledger account card. What does it do, you ask? It controls whether you can use the specific general ledger account in postings. And by that, I mean that you cannot manually enter the account in journals or on documents. Why Read more…

By kdallefeld, 9 monthsMay 16, 2022 ago
Inventory

Inventory to GL Reconciliation Chapter 1- Concepts

There are a handful of concepts intricately connected and are an absolute must for understanding how inventory transaction flows throughout the system, what is affected and how the subledger is connected to the general ledger. Posting an inventory transaction has three important pieces. 1) To track quantity, records are posted Read more…

By kdallefeld, 9 monthsMay 9, 2022 ago

Posts navigation

1 2 Next
  • BC Release 2023 Wave 1 – The Great, The Good, The OK – One Consultant’s Opinion
  • Assisted Setup – My Journey
  • Assisted Setup Series – Report on Financial Health – Process Consolidations
  • Assisted Setup Series – Report on Financial Health – Setup an IRS 1096 feature
  • Assisted Setup-Get ready for First Invoice/Customize Document Layouts
  • Twitter
  • LinkedIn
  • Email
Hestia | Developed by ThemeIsle