Solved

Hello dear community,I was wondering if someone knows how to fix this error.  "Object reference not set to an instance of an object" Error happens when processing Order Type SC in Sales Orders. This is just in one of our tenants.    

We’re exploring using blanket orders with line splits based on Customer Order Nbr. values, and it appears to be working well! We ran into some odd behavior: when creating a sales order with the REST API (using the /SalesOrder endpoint), we’ve observed that the value specified in the a detail line’s CustomerOrderNbr field is apparently discarded in the generated order whenever that line’s OrderQty is greater than one. This does not seem to happen when creating orders using the web UI; only with API-created orders. Is this expected? Anyone have suggestions for how to troubleshoot? Thanks again! 

 Hello, I can update an inventory item with the code below. I’m not suggesting it’s the best way but it works, the description is updated and saved to the database.public SelectFrom<InventoryItem>.View InventoryItemView;public PXAction<InventoryItem> UpdateItem;[PXButton][PXUIField(DisplayName = "Update Item")]public virtual IEnumerable updateItem(PXAdapter adapter){ List<InventoryItem> l = InventoryItemView.Select().RowCast<InventoryItem>().ToList<InventoryItem>(); InventoryItemView.Current = l.First(); InventoryItemView.Current.Descr = String.Concat(InventoryItemView.Current.Descr, "X"); InventoryItemView.UpdateCurrent(); InventoryItemView.Cache.Persist(PXDBOperation.Update); return adapter.Get();}Using the same method I can update a sales order line.public SelectFrom<SOLine>.View SOLineUpdateView;public PXAction<InventoryItem> UpdateSOLine;[PXButton][PXUIField(DisplayName = "Update SOLine")]public virtual IEnumerable updateSOLine(PXAdapter a

Hello! I am working on a GI to display all line items for bill/adjustment. The goals is to have the parameter and condition set to search by the reference number. With the parameter and conditions I currently have set below, I am experiencing an issue. When I view the GI and attempt to search by reference number, no records are showing for AP Bills or Adjustments. there are multiple records in the system.If I search a specific reference number, the results do appear. How can I fix this issue to show all records and reference numbers when you click the magnifying glass? Thank you!

when creating a Purchase Order from a Sales Order, if the same item appears multiple times in the Sales Order, it gets consolidated into a single line in the PO with the total quantity.We need to retain the multiple lines in the PO exactly as they appear in the Sales Order rather than consolidating them. Is there a way to configure the system to maintain the original line structure when generating the PO?Looking forward to your guidance on this.

Hi everyone, I was wondering if there’s a way to add a customer field status in report filter without coding customization?   As you can see in the screenshot we have status U - WO PendingBut I cannot see it in the additional filtering conditions:   Also is there a way to output the Codes too, so that in the filter parameters the user can see both the value and description?  Thank you in advance.

Hi, client has a BOM with multiple operations.  During the Move transactions, is there a way to have the last Operation be the default?   There is a feature for Control Point, but it seems to force this to be a data collection; however it is not defaulting the last operation?  We do not want data collection for each operation.

Hi Community,If I have edited a customization project, but I did not re-publish it back to the server, is there a way to export/ revert back to the original customization project published in a tenant? I made changes I wish to undo that are not in the server because I did not publish it after making changes. When I re-open the current existing project, the changes I don’t want are in the project.  Thanks,RJ

i added conditional formatting to my sales order to this after the weekend the notes and attachments files have disappeared.how do i put it back

Hello all,I have been looking out for scenarios/solutions where I can forward the emails sent to a specific mail id in Acumatica to some another a/c.I checked out the Assignment Map thing but looks like its not what I’m looking for.I tried to create one by putting up a condition where if the Message has the below setup:  Where value field = Email Account ID field<Email address field>.And then under the Rule Actions tab I setup the employee assuming that the mail will get forwarded to that particular employee.I am doing this correct?

i am try to create a report, but for some reason i can’t link ARinvoice to Soshipment

Good evening,Curious if there is a good report in Acumatica that would generate an AR report of aged invoices based on sales person...or would that be more of a customization request?

Does anyone know how to add the following fields as columns to the Approvals Screen (EP503010)Project ID Vendor Doc ID A proper link to the AP attachement or if there is a way to include the AP invoice PDF as a side panelRight now the only way to get this information is to click into the approval to see the bills and adjustments entry, when you need to click into B&A for each invocie is rather time consuming.  I tried to go into the Screen Customization Editor, however it doesn’t seem like the fields am looking for is inherently part of the EPApprovals DAC. As I am VERY new to the screen customizer I did not try to add the custom field, since i don’t know how to link it to the necessary DAC table. Thanks in Advance!  

I’m curious to learn how other clients are using the system to communicate the freight amount to the Receiving department.  Here is the use case:The Purchasing team creates a PO and sends to the vendor.  The goods on the PO will ship via Collect with one of our own freight carriers, so the supply vendor will not invoice us the freight.  The purchasing team knows the amount of freight for this order.  We’re trying to figure out how to communicate the freight amount within the system so that when our Receiving department receives the order, they know how much to process the Landed Cost transaction for.  Currently, we’re listing a non-stock FREIGHT item on the PO so that it transfers to the Receipt document.  However, this causes issues to the Accounting team because it creates a receipt accrual for the non-stock FREIGHT item for a vendor that will not be billing us the freight.  Thanks for any feedback you can provide!Shawn

Hello, Occasionally, when adding a new payment to an existing sales order with a PUT to the /Payment endpoint, the request succeeds (HTTP 200) but the response body is nearly empty. Rather than containing a Payment structure with ReferneceNbr and other fields, the server gives us a response body like this: {"id":"912d9149-55a4-4b1c-8575-73ebbfc2027c","rowNumber":1,"note":null,"custom":[]} This is problematic for our use case, because we need to store the payment’s ReferenceNbr, which is missing. Is the expected behavior? It appears to happen rarely, but I haven’t been able to determine the cause. Any recommended way to work around it? Any help is appreciated, thanks!

Is it possible to re-use of Blob format in acumatica.(E.g:Data.uploadfilerevision table). If So, How?

We have customers with multiple locations that are all setup as separate accounts.  There is a “parent” account that all invoices are sent to.  Each location has different contacts and the parent company wants bills with each locations name because they have checks with each location’s name and address.Our problem is how to apply a company wide credit limit so that when it is calculated it considers all the “child” accounts also.Thank you for any insights

HI All, I have a processing form built on the graph below, and so far, I can’t for the life of me get the Processing buttons to show.  I’m wondering if this is due to the processing form running on a DAC with the PX Hidden attribute - have never tried this before, or am I missing something else?  There is a View Delegate involved which takes data from a MASCCommissionDetail DAC which is persisted to the Database, and summarizes the data into a List of MASCProcessDetail.  The form is shown below.  This works exactly as required (except that there is no Process/Process All buttons visible)The MASCProcessDetail DAC is marked with the PXHidden attribute:  Essentially what I’m trying to do, isSummarise all the data in MASCCommissionDetail into MASCProcessDetail.  There is a many to one relationship between MASCCommissionDetail (many) and MASCProcess Detail (one), and when the processing form runs create one record  in APInvoice for each MASCProcessDetail record.  (I know how to do this part

We are running 2023R2.  We setup Inventory Item Access restriction so that certain stock and non-stock items are restricted to certain users (mainly along branch lines).  While the users can only see the items they are allowed on the main Inventory Stock/Non-Stock items GI screen, it appears that they see ALL items when they are trying to pick items in Project Quotes (Estimation tab) or Project Cost Budget (and perhaps in other areas).  Does any one know if this is a known issues or is there something we are not doing right?  Thanks in advance for your help.

I’m hoping someone can point me in the right direction; I’m guessing there’s probably even some stuff in the standard help that covers this but I’m striking out.If I run one of the stock AP or AR reports (I’ll use “AP Balance by GL Account” as my example), they all have a date or period parameter.  What I’m being asked for is to run these reports as of a specific date, like running the AP Balance as of the previous month end, so that we can then tie to the appropriate GL accounts.The issue with As-Of reporting in every ERP I’ve ever worked with is that, for subledger reports like AR and AP, the transactions are always changing.  GL is easy to run “as of”, because you never close or delete a GL transaction (worst case, you create a new transaction in the same period to reverse it).  It’s very possible on an AP subledger report that I may come in on February 3 and need to post an bill with a posting date of January 31.  I may also, on the same day, pay and close a January 10 bill.  I can

Hello!I’m trying to edit a report, but when I clicked on the “Edit report” button instead of downloading, it just sends me to a screen called “report definitions”Can I get some help? Really appreciate your answers, thanks

Looking for tips/help on updating the default Empty Item UOM from HOUR to EA. When we try and change it we get errors but can’t find where it’s pulling the errors from - our templates all have branch/billing rule/allocation rules filled out (as do our projects). And there isn’t anywhere to select defaults for those on the preferences page.  here is the error we get: Is this a customization?

Acumatica standard behavior sets the Sales Order owner to the user who converts a quote to an order.  I’m unable to find a way to set it instead to the Sales Quote owner.  I looked in Customer Management and Sales Order Preferences, and in Order Types.  And there’s no ability to configure and use an assignment map for Sales Orders.  Can this only be done via a customization?

I am working on an import scenario to create new customers. The site has multi base currency and two branches AU and US. I’m feeding the Restrict visibility to field in the import scenario yet getting this error.    

Our company brings in sales orders via our homemade website. Quiet often we have to change the order quantity on a sales order. When we do that and press save we get an error that says “Applied Amount Cannot Exceed the Unbilled Balance”. We have been able to plug numbers into the payments screen until we are able to save but I don’t think we are doing it the appropriate what. What is the correct steps for changing the quantity ordered for an SO?