Replies posted by byates
@charltonh We do not use non stock items in our SO documents for the most part. For the ones that we do, they do not show up on a shipment (as they are a “service Charge” of sorts and not a physical good) and only get moved from SO to AR Invoice, they do not populate on a shipment. I am not sure what you industry or what your processes are so I can’t really speak to your situation.
@byates did you ever resolve this accrual issue? I’m also looking for similar solution as we don’t won’t P&L COGS to hit until month of invoicing So we have been using the Shipped Not invoiced for a few months. Overall it is working well and the financials flow as expected. The inventory value shows up on the BS no issues there. Still does not show in the subledger which is not really a need honestly. Biggest obstacle is building a GI that easily shows what is sitting in the SNI account. Our consultants have spent numerous numerous hours creating a GI to no avail. I personally do not think this is a difficult GI I to build I just have not had the time to look into it. It is easy enough to pull the details from a few other sources (ie SO Order, Shipments) to get to the same info so it has not been on the top of my list. This is just a reporting issue and not an issue with the SNI functionality as it is working as desired.
Been reviewing and testing in our test tenant. Admittedly I am spinning my wheels here a bit as I can’t figure out the mapping. For example, we have they payment type mapped to Payment Summary > Type, but I can figure out where to map the Document Type in the upload file as I can’t find the equivalent of the line Doc. Type (Class:ARadjust, Field:AdjdDocType). Are there any good tutorial videos or any other resources that I can reference to help me get through this? This is the first of any kind of import scenario I have ever ran. Thank you,Brandon
Good progress. You might also want to check in the Schema Builder - Sorting and Grouping tab for the Grouping. You might have removed the sum of the price but still the lines might be grouped by Inventory Item. …. I should have thought about that. That was it! Thanks Raj. (and Donna)
Thanks to you both. I have removed the Sum and added the Promise Date but for whatever reason it is only listing the first line item, but it does show the line comments for all 3 lines. The qty on the one line item is now correct though and shows only the first line qty and not the sum of all lines. So making progress.
Hi @byates For your question#1, you can do an inventory cost adjustment. Refer to the following thread. If you want to remove all inventory and then bring it in with new cost, you can do an inventory issue document and then an inventory receipt. Or inventory adjustment with negative quantity to remove and then with positive quantity to bring it in. For question#2, on what report have you noticed the value with no quantity ? This should not have happened. You may run ‘Recalculate inventory’ for specific item and warehouse and check the numbers again. Regards, @vkumar thanks for the reply. Regarding #2, I am seeing that on all of my Validation reports. More specifically, on the Historical Inventory Valuation report. I am not seeing a “recalculate Inventory” process in my IN module. Perhaps it is somewhere else? I have run the “Validate Inventory” and included “rebuild item history” but that did not correct the costing issue.
@gdow23 Absolutely, I should have clarified in my initial post. So we manage a network of 15 different inventory sites. Our biggest challenge with these sites is around inventory accuracy and control. Currently we rely on physical cycle counts every two weeks to validate our inventory. What I have experienced is that the sites have considerable issues providing us accurate inventory data and we consume a lot of resources chasing down variances. On top of that inventory movements are reported manually. So if we transfer items from one site to another we rely on that site to manually notify us when a transfer shipment occurs. We move a lot of freight so it is not uncommon for a truck load or more to go unreported. Similar issues on the Raw/Pack receipt side. Often I am not aware of a receipt until the AP invoice is received for the goods. It takes more time and resources to look for the receipt in the system, in some cases one does not exist because the site did not notify us that they r
Agreed something is not adding up. Possible to provide more information on the AP Bill and how it was cleared? (check the Applications tab in the AP Bill) You have a prepayment that cleared the bank and is still open. AP Bill was entered for the actual invoice of the prepayment Either the Bill is still open, or it was cleared in one of 3 ways, Apply Prepayment (didn’t happen), Paid Bill via “Checks and Payments” AP Bill was Debit Adjusted out. #1 we know did not happen. IFF #2 happened your bank statement would not reconcile since you have another Credit on the Bank account for the Check payment. #3 is possible as it has not cash impact.
Thanks for the reply @francisw00, much appreciated. At this point I am in a very exploratory stage. I have a very basic understanding of the technology. Since you appear to have some background understanding of this technology and process do you have any suggestions of possible providers that I can explore and contact? I would like to get some basic demo and more importantly a discussion with a professional to explain our needs and desired end goal to see if this is even the best route forward?
Thanks for the input @vkumar. I am being told by our implantation partners that the Deferred Revenue Module is a add on and not part of the out of box solution. I thought that was crazy talk as there isn't a business that would not need this basic functionality of amortizing a deferred expense. However, after reviewing you post, I do not have anything in my system that comes up for deferrals. So, as always, they appear correct. I am still shocked by this however.
@ChandrasekharMThanks for the info. That document is a bit more of an internal look IMO. I am looking for something a bit more “formal” looking that is concise, and clear. If I were to send that to a Vendor I think I would get more questions than actions. I essentially want to mirror my AP Invoice Remit form but with clear verbiage that it is a “Credit Memo Request” so to speak. The above is certainly an option of last resort but was looking for something a bit more formal as stated above.
@jvinski71 You are able to do partial adjustments with Debit Adj’s. For example from time to time our AP clerk enters the wrong AP amount, ie 2,539 vs 2,359. In that case you can create a debit adjust to remove just the $180 over bill. No need to reverse the whole document and re-enter.
Similar issue on our end, however it is not non stock item it is pulling the info from the shipment, Shipping Settings, inputs and placing a line item on the invoice that just says the carrier name a price of zero. We too would like that removed.
@Gabriel Michaud I am seeing some confusing results in the Accrual Report where one receipt has varying results depending on the date selected in the parameters. It appears that the report ran for 01-2021 period is somehow “duplicating” the values. In the example below all numbers are increased by a factor of 14. Seeing similar results on most data but strangely not all. Thoughts?For example:
@Gabriel Michaud Thanks very much for the live stream! I am a little less than half way through. Like you, my Accrual Summary is not tying to the GL summary, so I have taken a bit of a pause to figure that out. Once I get that sorted I will move forward. Very informative video thus far. Many thanks for your efforts here!
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.