Solved

I cannot seem to get the relations working on this table, and im baffled since it seems like it should be as simple as simple gets.Case: I am making a nested GI, all the sub-GI’s work fine. they consist of a date column and a column showing the needed value for the item in question.The issue is each day will only have one or two columns of data, so as a foundation/starting point for the nested GI im using the SM.DateInfo table, then making relations to the sub-GI’s using a left join. This connection simply will not work. I tried using just the DateInfo and SOOrder table and doing a similar left join, hoping a stock table would work, and nothing. I even tried to convert the date on other tables to an integer and join with the DateInfo.DateInt field to no avail.As a separate test i made a GI with just the DateInfo table, have the results grid show just the date field, and tried to put conditions on it to pare down the results. Between Today()-400 and Today(). i get no results. Again, no

Hello,I am using contract based rest api. I was looking for the endpoint which can help me to fetch updated inventory changes nearly on real time based scenario, where I can pass updated date filter. So, can you please suggest which entity or endpoint would work better for this?And also looking for the endpoint where I can update stock quantity.Please look into the issue.Thank you

Hi Team We are facing an issue while choose the Discount code in Sales Quote depend upon the code we have setup a Approval to the owner to confirm the QuoteFor this customer the price class is assigned for Tier 3Please see the below screenshot:This is Discount added While choose for the scenario it shows this errorPlease advise.

Hello Guys,i have created two customerfieldsUsrStandorte1 , Fieldname: Leistungsstandort UsrStandorte2 , Fieldname: LeistungsstandortUsrStandorte1 is in Screen ID : IN202000 UsrStandorte2 is in Screen ID : SO301000 I want the field UsrStandort2 to automatically take its value from UsrStandort1. This should be done via customizations, but I haven’t been able to get it to work. Does anyone have a tip on how to approach this? Hope you can lend me a hand

 Hello everyone,I need to add a filter to my report so that I can filter it by OpportunityID.Below are my screenshots showing the steps I’ve taken so far.Can someone please help me with this?Thanks in advance,Pantea 

Hello every oneI am currently working on a report containing bank information. These are encrypted . How can I get them decrypted in a report?I found a thread about a function:  PX.Objects.CA.Descriptor.ReportFunctions.GetBut I really do not know where to build this function in the report.Thanks

In Customized Screens , I started Customize existing screen AR303000 .I selected EDIT ASPX button And added the below code to Tabs after Compliance Tab .<px:PXTabItem Text="MyNewTab">  <Template>    <px:PXButton runat="server" ID="btnGetResult" Text="GetResult"><AutoCallBack Command="GetResult" Target="ds" ></AutoCallBack></px:PXButton>    <px:PXGrid ID="grid" runat="server" >      <Levels>        <px:PXGridLevel DataMember="CurrentCustomer">          <Columns>            <px:PXGridColumn Width="200px" DataField="UsrNoOfHits" ></px:PXGridColumn>            <px:PXGridColumn Width="250px" DataField="UsrBookMarkRating" ></px:PXGridColumn>            <px:PXGridColumn Width="350px" DataField="UsrNotes" ></px:PXGridColumn>            <px:PXGridColumn Width="350px" DataField="UsrSanctionsCheckMessage" ></px:PXGridColumn>          </Columns>          <Mode AllowAddNew="False" Al

I’m trying to modify the existing Journal Transaction report to ignore subaccounts.  We have subaccount enabled in our set up but it is only meaningful in certain situations.  When I want to look at the activity in an ACCOUNT, I don’t want it broken up by subaccount. I know the GLHistory tables are used to pull the opening balances and they are organized by account & subaccount.  When I try to collapse the grouping around subaccount I get garbage for opening balances.I’ve also tried abandoning the GLHistory table and have built up the opening balance by pulling in all records from GLTRAN and totaling all of the DR/(CR)’s prior to the period I want.  But, I can’t get that calculated variable to pass from the detail section of the report to the header section for the account.  Can anyone suggest an approach to either pull the combined records from GLHISTORY or how to pass a variable from a detail section BACK to a header section.Thanks in advance.

Are there any solutions out there that would allow for upwards of 5000 task lines on a project? We realize there are limitations based on tiers, but we are getting stopped when we upload a certain number of rows to populate a cost budget. Are we misunderstanding the line upload limitation as an upload is the same as a “commercial transaction”?Or is there a way to do Parent Projects and Subprojects? Are there any solutions out there that would tackle that? Would love to hear anyone’s ideas. Thank you!   

 Does anyone have experience with creating a custom Payment Method/Export File that can generate a Batch Payment file to upload and create International payments? The MYOB Acumatica out-of-the-box options appear to only include:NZ Domestic Payments AU Domestic Payments The scenarios I'm looking to cover are:Paying from an Australian ANZ Bank to New Zealand Bank Accounts Paying from a New Zealand ASB Bank to US Bank Accounts

When creating a kit assembly, we’ve found that lotted components are automatically allocated based on the FIFO setting on the Serial/Lot class.  However the not tracked components require a Default Issue From value on the Item Warehouse Details form, or the Line Details need to be specified manually.When a shipment is created from a sales order and includes these same not tracked components, the components are automatically allocated based on the pick priority of the locations on the warehouse.  Is this the expected behavior for kit assemblies?  Any ideas how to automate this so that the location can be dynamic, similar to how it already works for shipments?Thanks in advance!Laura

Use case: We have some expense items configured to post to job-related GL accounts and others configured to post to G&A GL accounts.  How can we enforce the correct pairing of these expense items with projects on expense receipts?Scenario 1: A user creates an expense receipt for the purchase of job materials and enters an expense item that posts to a job-related GL account.  How can we make the entry of Project/Project Task/Cost Code required for this scenario and prohibit entering Project X - Non-Project Code?Scenario 2: A user creates an expense receipt for the purchase of office supplies and enters an expense item that posts to a G&A GL account.  How can we force the entry of Project X - Non-Project Code?  

Hi everyone,I'm looking for a way to audit a specific user's activity in Acumatica. Ideally, I want to view a detailed history or trail that includes all screens the user interacted with and any changes they made across the system (such as record updates, document edits, field-level changes, etc.).Is there a Generic Inquiry or report that provides this kind of audit trail? Or is there a recommended approach or customization to capture this level of detail?I’m using 2024R1

Does anyone have experience accessing the following internal field while importing?CurrentDocument.CuryUnbilledOrderTotalI need access to it because I want to remove a cancelled order line, get the new unbilled $ amount, and then enter that number into the “applied to order”I BELIEVE I can’t simply do math on what I am removing, as there’s an external tax calculation that needs to happen after removing the line and saving the order  

Acumatica markets its software as being sold based on the number of transactions the customer performs. So in theory, it should not care about the hardware specs of an individual client server that is running Private Cloud, as long as they are operating within the limitations of their transaction count (Acumatica will care with regards to servers it hosts on clients’ behalf, because there is a cost impact to Acumatica of provisioning more performant/expensive servers).However, if you look at the help documentation, you get statements like this with regards to Private Cloud subscriptions (https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=54ef574c-0adf-48a0-b5be-d3438a6e5400):When your organization purchases a Private Cloud Subscription (PCS) or Private Cloud Perpetual (PCP) license for Acumatica ERP, your purchase manager selects a License Tier, which limits the parameters that influence system performance. The License Tiers are grouped into the following series:S Series: Inc

The Additional Sorting condition does not seem to be working.  To explain further, here is the sorting/ grouping done in the report designer. However, when we tried to use the ‘Sales Order.Sched. Shipment’ in the Additional Sort and Filters: Additional Sorting Condition which doesn’t seem to be working. I even tried to output the Sched. Shipment Date in the report itself. I hope you can help Identify what I am doing wrong. I have attached the actual report just in case you may want to take a deep dive on the report. Thank you so much for your time in looking in to this. 

We have several assets with NBV of $0.00 and beyond the end of Useful Life, but the status of the asset is still Active, while the status on the Balance tab shows Fully Depreciated. See below: How do we get the statuses to synch up? This is not the case with all assets with no NBV.Thanks.

Hi, we are in the situation where we often have 1 quoted amount for multiple items. We are not provided per item pricing and some items are not in our inventory.Items are typically shipped over time, so we are receiving incrementally.We have need to track the quantities with descriptions, so we’ve set up non-stock “quoted lot” for items not currently in inventory, and use stock part numbers if existing. These are on the PO at zero cost. We have found that when received, the line items with $0 cost are not flowing into the project cost code transactions. How do we pass this info to the project without requiring a cost to be received on the PO? 

Sales Orders screen has Inventory’s availability calculation on the screen’s bottom part. How can I add that line of On Hand, Available, Available for Shipping and Allocated values on another Acumatica screen where again a Stock Items are visible?  I need to add it on Purchase Orders screen. Would I need to create an extension or only editing the Screen Editor would be enough?

I want to prevent a custom page from loading based on a condition.  For example, I want to put an expiration date on my custom application.  When the application date has expired, I want to prevent the page from being accessed.  I’m trying to roll my own security on my custom app.I found documentation that used this scenario:public static bool IsActive() => PXAccess.FeatureInstalled<FeaturesSet.someFeature>();If I put public static bool IsActive() => false; in my graph, should that prevent the page from loading?  It doesn’t seem to have any effect.If that is not the way to do it, does anyone know how?   

For the tariffs in Acumatica, we are looking at using a document discount (with the discount % being input as a negative).  We are wanting the sales order line discounts to post to one GL account and the discount used for the tariff to post to different account.  What is the proper way of setting this up in Acumatica?

I can not get process and process all to show up on this graph:     public class RecycleSeries : PXGraph<RecycleSeries>    {        [PXProcessButton]        public PXProcessing<Series> SeriesRecords;        public PXSelect<            SeriesDetail,            Where<SeriesDetail.seriesID, Equal<Current<Series.bookSeriesID>>>>            SeriesDetailRecords;                public RecycleSeries()        {            SeriesRecords.SetSelected<Series.selected>();             SeriesRecords.SetProcessDelegate(Process);             SeriesRecords.SetProcessAllVisible(true);             SeriesRecords.SetProcessVisible(true);         }Removed Process handler for clarity.Could the aspx be messed up?I have this for the aspx:  <CallbackCommands> <px:PXDSCallbackCommand Visible="True" Name="Process" ></px:PXDSCallbackCommand> <px:PXDSCallbackCommand Visible="True" Name="ProcessAll" ></px:PXDSCallbackCommand></CallbackCo

Does anyone know if it’s possible to manually trigger a Shipment document to sync to ShipStation? Our client has configured the ShipStation integration to only sync Shipments with certain Ship Via codes to ShipStation. However, sometimes orders are placed and the Shipment document is created with the wrong codes, so they don’t get synced to ShipStation.Is it possible after changing the Ship Via on the Shipment document to trigger the integration to sync the revised Shipment to ShipStation?

Getting this error while confirming the shipment.FEDEX: PACKAGINGTYPE.MISSING.OR.INVALID Packaging type missing or invalid. This looks like error dude to FedEx configuration.

Hello,I have a customer who is using DRP and Kit Assembly to plan out what needs to be assembled for Sales Orders that drop in each week. One example is the Kit Assembly pictured below:Even though this Kit Assembly has been created, DRP is not considering it in the Inventory Planning calculations. The customer is understandably concerned because they don’t want to create unneeded inventory by creating new Kit Assemblies every day, as Inventory Planning Display is suggesting:The Kit Assembly is On Hold, but that is taken care of in Inventory Planning Preferences:I have exhausted what I suspect could be the issue including the following:Kit Assembly and Distribution Requirements Planning are both enabled on the Enable/Disable Features (CS100000) form The Stock Item has the “Is a kit” box checked The Kit Specification is Active The General tab on the Stock Item has a Planning Method of DRP The Inventory Planning tab on the Stock Item has “Kit Assembly” as the Source The PACKAGING Warehous