Replies posted by byates
Thanks @kandybeatty49. The location costing layers is something I had not previously read about. So I guess my question at this point is how can I tell what transaction is creating costing issues? There should be a transaction(s) that are received in at a considerable lower cost and/or and adjustment that has changed the total blended costs? I find it suspect that all transaction costings look good but then the reported valuation at the end is off. To add to this the issue seems to “Self Correct” in the subsequent period. This is what was lending me to believe it was some sort of DB issue.
Hello, You might try filtering Inventory Transactions by Account for the transaction types needed by the auditors. Select the Inventory Asset Account(s). You will need Receipts and Adjustments. The Reason Code will help you sort out different kinds of adjustment (Physical Count vs. Landed Cost). Inventory Transactions by Account does not include Vendor or Purchase Order details. Laura Thanks Laura, I will give that a try. The Inventory Transactions by Account does not include Reason Code but I know a way to xref the two. But I did want to ask a general question as I have seen this on a few GIs and it never has worked. Around the Period, in the header if makes you select a single period, but also has the Date Range to the right. The date range has no impact on the results and only the Period impacts the results. How do I active the date range so I don’t have to run this GI 24 different ways?
All you need to do is set the Aggregate function to Average or Min/Max. If you dont set anything then when you use the Group By in your GI it will default to Sum. So if you have 1 receipt line you will have the correct valye but if you have 2 receipt lines it will double the values, 3 will triple it etc. So therefore if you use Average it will display correct as if it has 2 lines it will double it an then divide the result by2. You could also use Max or Min as that will take the highest/lowest value, @dcomerford Thanks for the tip. This has indeed worked. However, I can not yet vouch for its complete correction of the issue. High level it did correct the testing receipts I have been looking at but not yet confirmed this has not caused some other kind of issue with the totals on receipts with multiple lines. But early indications is that this worked. I have noted that this GI has become wildly slow to run. up to 30 seconds for the GI to load at times. Not sure what caused this no
@kandybeatty49 not all records are duplicating as @manikantad18 pointed out. below is an example: Hi @byates you need to refer to the GI relations highlighted in the above screenshot to resolve the issue @manikantad18, wasn’t quite following your above GI references, where you stated you tried changing the join to Inner with no luck. I tried changing the Join to every other possible option with non correcting the returned results.
@Chris Hackett Morning, I have not. I have been playing around with this in test and no matter what I do it will not let me skip a financial year. ie, I generate a new calendar and click “User-Defined Periods” the Fiscal Year defaults to 2023 (next in line) and even when manually changed it always goes back to 2023. Can’t find a way to override the fiscal year.
@kandybeatty49Currently Allocation Mode is Purchase Price variance. BUT you just led me to one of my open audit items. I was unaware that we could capitalize the PPV costs to inventory account. Question on this, will it treat it similarly to a Landed Cost adjustment and recapitalize the asset on the balance sheet? Not terrible applicable to the question at hand but useful information to have.
@Laura02Thanks Laura, while I agree and that was the first place that I had checked. Below is the posting class general for this item. I honestly do not know what the III means. I just know that we have processed many AP invoices for this same item in the past without issue. So something has changed for sure.
Hi @kandybeatty49!! Let me know if the below does not work for you. Thanks! 3/6/2023 7:37:25 PM Error:AP Error: PPV Subaccount mask cannot be assembled correctly. Please, check settings for the Inventory Posting ClassPX.Data.PXException: AP Error: PPV Subaccount mask cannot be assembled correctly. Please, check settings for the Inventory Posting Class at PX.Objects.AP.APReleaseProcess.RetrievePPVAccount(PXGraph aOpGraph, POReceiptLineR1 aLine, Nullable`1& aPPVAcctID, Nullable`1& aPPVSubID) at PX.Objects.PO.GraphExtensions.APReleaseProcessExt.UpdatePOOnRelease.ApplyPPVAmount(Nullable`1 ppvAmt, JournalEntry je, GLTran patternTran, APTran tran, POReceiptLineR1 rctLine, CurrencyInfo curyInfo) at PX.Objects.PO.GraphExtensions.APReleaseProcessExt.UpdatePOOnRelease.ApplyPurchasePriceVariance(Boolean isPrebooking, JournalEntry je, GLTran patternTran, CurrencyInfo curyInfo, APInvoice apdoc, APTran tran) at PX.Objects.PO.GraphExtensions.APReleaseProcessExt.UpdatePOOnRelease.Invoi
Thank you all.What do you do in the event you have an unreleased move and material transaction on a Production Order that is in “Complete” status? it will not allow me to process the trans due the the ProdOrd being Complete and I don’t see an option to open the Prod order back up.Thoughts?
Thanks @kandybeatty49 I have to admit, this is a completely unconceivable design. While I understand controls that guard against taking un planned discounts, to completely lock out manual intervention is a BIG oversight on the Devs part. This issue, literally, makes the AR module unusable for our Company, as 98% of our customers take discounts regardless of the remit date and take them off Gross invoice before discounts. Nonetheless, I am always appreciative of your input. You are a rockstar!
@kandybeatty49 Below is a screen shot of the current error. I did figure out that I can go into each invoice and change the Cash Discount date after the AR invoice is released (grossly inefficient given the number of invoices on a remittance). This allows me to enter a CD. However, since the system calculates the CD based of the total invoice price and the customer calculates the CD based of the Gross invoice price (before discounts are taken) my “available Cash Discount Balance” in the system is always less than what is being taken. So, now while I have found a work around the the date constraint I am still in the same spot as the available discount is not big enough for the actual CD taken.
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.