By using this website, you agree to our Terms of Use (click here)
We've been on Acumatica for about 18 months. Purchase receipts and Inventory never match at month end (i.e. the GL Trial Balance Summary to the detail reports). For the first year or so, I always figured it was our process, learning the new ERP, unreleased items, etc. But now that we feel pretty familiar, these should be balancing. I've never had an ERP where the detail and the GL didn't match in all modules every month.
We do have some non-stock items (miscellaneous items that don't hit inventory). We also process drop ships in Acumatica. We do issue POs for these, and also invoice customers for these. I'm not sure if they are throwing us off, but something is.
Any feedback would be great!
Some points that might explain it, or at least narrow down what the cause of the issue is hereb
Are users receiving Inventory with an Inventory receipt directly, by passing the purchase receipts?
Are you processing returns which you are not taking into account when adding the numbers of the PO receipts?
Are you looking at all types of purchase receipts?
Vendor Returns were mostly fixed in version 2018R2. That may play a part.
Are you set to have discrepancies in AP Cost vs Recipt Cost go to a PPV account or Inventory? First books the difference in value to a PPV account, the 2nd should update your inventory cost. Settings are found in Purchasing Preferences.
Thanks Russ for the reply--great point. Yes, purchase price variances go to PPV account. But we don't see much there, ususally a few hundred $ per month, and we're off 10s of thousands in purchase receipts each month. Or at least so far this year is is accumulated to 25k. Any other ideas?
Thanks Ellie for the response, great questions!
Yes, all PO receipts are done off the PO. But our non-stock items have no receipt function, and drop ships are received off vendor invoice (but don't hit inventory). I use the purchase receipts accrual details report, and it includes returns. So i don't think that is where we are going wrong!
Are you trying to reconcile the Purchase Accrual Summary (PO630500) report to the Trial Balance Summary (GL632000) report?
And then also the Inventory Valuation (IN615500) report to the Trial Balance Summary (GL632000) report?
There are some new inquiries in Acumatica 2019 R1 called Discrepancy by Account (AP409010) and Discrepancy by Account (AR409010) that allow you to reconcile the Accounts Payable and Accounts Receivable modules to the General Ledger For more info, checkout this post:
https://www.augforums.com/augforums/everything-else/acumatica-2019-r1-new-features/paged/2/#post-3922
It would be nice if they add the same kind of inquiries for Purchase Accrual and Inventory in the future.
Thanks Tim for the response. Yes, nearly. I'm using Purchase Receipt Details; PO 631000, a GI GIOZ0123 for Inventory and GL632000 for trial balance.
I just ran the inventory valuation and compared with the GI we've been using and they are way off. I'll wait to compare at month end--that might be a big part of the variance!
Stay tuned. We're still on 2017R2 so I'm sure that doesn't help at all!
I forgot about this approach that I tried a while back. It might help you:
Thanks--I'll check it out, but I don't think we close many POs manually.
Check that all inventory documents were actually released. We've just recently started having an issue where released distribution documents (eg. Purchase Receipts) aren't getting their associated IN document released automatically. This is an intermittent issue. It caused us to have the GL out of balance with IN issue until we discovered it.
Thanks--yes, that's the first thing I do in our month end processes is to check releases in all the modules. But Tim pointed me to a new inventory report (valuation instead of the inventory list we were using) and it seems to help some. Not quite there yet, but getting closer.
Thanks so much for the idea!