Solved

I have a simple GI that pulls inventory IDs, price classes and prices.When I load this GI in Excel (via an OData link), the results sometimes contain serious errors. Many inventory IDs are repeated, and some IDs don’t show up at all. Strangely, these errors don’t occur every time I load the data. If the data contains errors, I can often get the correct data by refreshing 4-5 times. If I run the GI in Acumatica and export to Excel, the data is always correct. Any ideas on what could be causing this?

Recently updated to the build 21.216.0034. It would appear there has either been some change to what triggers a ‘Product Availability’ sync request, or otherwise a related bug. In previous builds, ‘Product Availability’ record prepared of course based on update to the given inventory ID (Template, Stock, Non Stock). Expected and documented functionality. Since our update to this build last week, it appears that nearly all Inventory ID records are entering the prepare/process queue, even though the majority of those records have not been modified by any expected action (ie, sales order created, PO received, inventory adjustment, etc).  Is this a known situation? Have changes to what triggers a product availability request been meaningfully changed in this build?  Why this matters in our integration: We override the ‘track inventory’ setting for BigCommerce products that we want to allow backorder on (ie, take an order for something not in stock). For items with low velocity, the Invento

 Hi everyone, I am wondering what is the right way to sort Kit in Report Designer. I have build a report based on below: I have add below sort filter:When I run the report, the KitHeaderID is not sort numerical or Alphabetically and is all over the place:I went and look at Kit Specification and it would show the Kit in numerical order. Does anyone have an idea what I need to do in order to have it sort numerically?Kind regards,Calvin

Good morning MFG Community. I am running 22.108.0024. I am entering and Expiration date on one material on the BOM lets say 9/30/2022. I am adding a new Material to the BOM with an Effective date of 10/1/2022. My assumption would be if a create a production order with due date and start date of 9/15/2022 I should see material A on the production order details because the due date and required date are before 9/30/2022. On the other hand, if I crate a future order today for 10/10/2022. I would expect material A to drop off because of the expiration date of 9/30/2022 and the new item B to be added because of the effective date of 10/1/2022. I can not get this to work. No matter what I do, any future orders still have part A and do not show part B

Hi Everyone,I was trying to track all the deleted records on my request primary list. Using generic inquiry. I also enable the “Show deleted records” and yet upon adding on the results grid. I can't add the field name DeletedDatabaseRecord. Is there an additional need to set up to check or to add in order to include the DeletedDatabseRecord on the Results Grid ? Please see attached photo for your reference : Results Grid Relations  Tables :Thank you !! 

In the midwest weekly certified payroll reports are required with activity or without. The ones without are called and Mark as “NO Work”.   AAtrix and Acumatica only produce certified payrolls when there is activity.  Is anyone aware of a method for changing this so all reports are printed Thank you

Good day, see the attached SO import.  I have used it before and it worked to have one order with multiple lines items.  Now the scenario is importing one order per one line item.  The original file contents have changed; I did use the same columns remapping them.Any suggestions;  I have orders with multiple lines.Thank you 

Hello.I am trying to add the Cash Accounts Profile to a new role.I copied the AP Admin role to a new role.In the Access by Role, I granted the Banking menuI login as a user with this roleI click on Cash Account option and I see the cash accounts in screen CA2020PL. So far so goodHowever, when I click on the cash account I get the message:Cannot open record for editing. The form CA202000 does not contain itI can’t figure out what I am missing.We do not have branches, one single company Your help is appreciated 

HI All,we set up dunning letter by document, but on Print/ Release Dunning Letter (AR522000) we can not select specific document to process.And can we filter action by customer, by location, by document?Thanks for your kind advise,Yên Chi

I’ve moved over to using Firefox with Acumatica for some of the productivity extensions (like TST) and have noticed a weird issue that I didn’t have when using Chrome.After I publish customizations, the navigation buttons disappear: Reloading, signing out, clearing cache and cookies doesn’t work. I have to complete exit the browser and then re-enter for it to reappear. When loading a page I see a lot of console errors: --“Cookie “timeStamp” does not have a proper “SameSite” attribute value. Soon, cookies without the “SameSite” attribute or with an invalid value will be treated as “Lax”. This means that the cookie will no longer be sent in third-party contexts. If your application depends on this cookie being available in such contexts, please add the “SameSite=None“ attribute to it. To know more about the “SameSite“ attribute, read https://developer.mozilla.org/docs/Web/HTTP/Headers/Set-Cookie/SameSite Main” --“downloadable font: download failed (font-family: "FontAwesome" style:norm

We have our production/testing tenant on the same instance, and we are wanting to enable project to test time tracking (internal projects) and also expense management.Would there be any issue with enabling in the TESTING tenant?  Will enabling in one tenant (Testing) affect our Production Tenant since it is in the same instance?   We don’t want to cause any issues with our sales team as we are configuring it and testing it.Or would it be best to do in stand-alone environment like another “Test” instance?Also, I haven’t come across any videos or training/configuration of internal projects, if you know any please let me know.  We will probably do billing against projects later but initially we will be using for tracking internal projects and time for employees on those projects. Thanks!

Good day,The attached import scenario indicates that the operation is complete.  No errors.  When I run, the import does not show any errors but it does not update the fields on the sheet.I am perplexed.  Usually it is an error with the mapping. Any advice would be greatly appreicated.Thank you@Evan G 

Is there a way in which the body of the Invoice notification can be changed depending on whether the document is an invoice or a credit memo?I am able to use the ‘type’ field where applicable (subject etc.), but the wording in the body of the invoice differs from that in the credit note:‘Please remit payment….’ for invoice.‘If you have any …..’ for credit memo. 

I am trying to make a Shared filter for open orders where the order type is one of these: (RA, RB, RE, RI, RS)I have tried many combinations of And/Or but I’m still seeing sales orders with type “SO” in my results.What is the correct way to use these operators? They are not in the documentation.  

In our system setup the Employee Time Cards do not generate GL batch, only Project Transaction.We have a situation where duplicated time cards were released and two transactions booked at the project.Question is how to delete one of the transactions to eliminate the double cost allocation?-Reverse button is inactive because GL batch is not generated (which is expected as mentioned before)-Delete button is inactive because transaction is with Released status

Hi EveryoneI am encountered a problem in dash board - cash position .Not sure why not all the cash account are capture and only certain cash account’s figure will reflected in the dashboard. Not sure if there is any setting wrongly.Please refer to the attached file for details explanation. Hope anyone can advise for me. thank you 

Currently, Sales Orders take Salesperson from the Customer level. Is it possible to change the setting to take Salesperson as Project Level? 

I have a customization that will travel through the lines of a sales order. There could be two groups of SOLine records that I need to process on the same SO.I have one main var to look at the SOLine records:var lines = SelectFrom<SOLine>. Where<SOLine.orderType.IsEqual<SOOrder.orderType.FromCurrent> .And<SOLine.orderNbr.IsEqual<SOOrder.orderNbr.FromCurrent>>>. View.Select(soOrderEntry);Then I’m using:foreach(SOLine line in lines){ //A bunch of code here}If I need another iterator to go through SOLine records on the same SO within the foreach loop and write (can I have multiple iterators on the same PXSelect?):foreach(SOLine lineTwo in lines){ //A bunch of code here}If I update lineTwo with:soOrderEntry.Transactions.Update(lineTwo);Will that update the proper record or will having multiple variables confuse the cache?

Hello,I am currently trying to add a button to Cases where I can create an opportunity. See below for graph initiation and insert. Note that this is proof of concept. #region Actions public PXAction<PX.Objects.CR.CRCase> CreateOpportunity; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Create Opportunity")] protected void createOpportunity() { CRCase cCase = Base.Case.Current; OpportunityMaint graph = PXGraph.CreateInstance<OpportunityMaint>(); CROpportunity opty = new CROpportunity { BAccountID = cCase.CustomerID, ContactID = cCase.ContactID, //Status = "N", //ClassID = "SERVICE", //StageID = "L", Subject = cCase.Subject }; graph.Opportunity.Insert(opty); if (graph != null) { PXRedirectHelper.TryRedirect(graph, PXRedirectHelper.WindowMode

Hi, we are adding a new subsidiary in the system and need to upload the open GL balance of both income statement and balance sheet. Is there any step by step guide that we can follow? Is there a template we can use? Any specific GLs that we cannot upload directly? Thank you for your assistance.Regards,Aaren

I would like to add an upload button to be able to upload an excel file with the lines an AP payment should be applied.  What do I need to do in the customizations? 

Hello,     The requirement is as below.      Supposing I am designing a report with report designer, and this report would show all the items ordered in today, and group by itemID.  I would like to show the lines sorting by orderQty of each line item descending. Here, the order qty of each line is a calculated sum value, I did not find a way to sort by the sum value.     Can someone give me a hand on this requirement?     I know there is a workround, if I export this report into excel, and it is very easy to sort by the order qty field. However, I still would like to know is it possible to just display the lines in the sequence of sum value directly.

Hi everybody,I am currently working on a Generic Inquiry that needs to give out the latest location after a transfer.I read something about Self-Joins which doesn’t seem to be working for the INTran object.Basically, I need to evaluate if the ToLocationID is the one from the latest transaction and display this location. Does anybody know a feasible solution?The client is currently operating in 2022 R1.

I want to update the warehouse for a specific material on my BOMS. I created an import scenario with the goal of identifying the BOM id and inserting the warehouse however I keep getting an error. I made sure to uncheck the lines with -1 to prevent a new line from being created. I feel like I am missing a line to allow this to work. Any help is greatly appreciated! 

Good morning!Can the columns in an Opportunity Summary be rearranged?If so, please advise how.  Thanks.