Solved

Client would like to enter notes as they are creating/adding to sales order via matrix items and have these carry over to the SOLines when they click Add & Close.  Is this even possible?As far as I can tell, the notes/attachments on the matrix table view don’t actually do anything currently.I’ve done many customizations, including to matrix items (with much help from ​@Zoltan Febert) but this one looks like another tricky one where I need to override the AddOrderLines method somehow.After clicking Add & Close I can’t find this in the CSAnswers table using:SELECT * FROM Note WHERE NoteText = 'Test Note 123' 

I have a report, attached below, that has several filters. However, One of the filter, Customer, can be selected, but doesn’t filter the report. Any reason why the report wouldn’t be filtering correctly?

I have been working on creating a very simple report. Based on a single view which has 1000 row.To Start I tried adding adding a single column.But only 10 rows are getting printed with the same dataI am attaching the images for the reference 

Hi all,I was wondering if there is a way to get the system to calculate the unit price/cost by updating the ext price/costUpdating the Unit Price to $700 calculated the Ext. Price to $4,200However, updating the Ext. Price did not automatically update the Unit PriceIs it possible for this to happen?Thanks

Hi.  When I am printing the schedule of values on the AIA Report, only the items that are being billed are printing.  How do I get the entire schedule of values to print (including the items not being billed on the current pay application?

We need to 0 the qty of an item that did not come in.When I create the receipt and change the Received Qty to 0, I get error: Quantity must be greater than 0.What is the right process to indicate a receipt is short?

We have a couple of business processes that require us to immediately update sales orders as new records are created in the system - not on a schedule. For example, we need to add the CRDF non-stock item to CO shipping address sales orders as they land in the system for tax calculation purposes.I’ve been able to create GI’s to filter down to the orders we want to update, and a business event that uses an import scenario to add the item to an order. The GI is configured to trigger based on record change, when the record is inserted into the search. We need to do this because we also apply filtering on the GI.I’ve confirmed all the functionality works in testing, but in a live situation the flow fails because of error: 0 records of 1 have been processed. The last error was Another process has updated the 'SOOrder' record. Your changes will be lost.As best I can tell this is happening because the business event’s import scenario is running too fast. I believe the import fails because the

I have a GI that outputs QtyAvail for each of our two warehouses on separate rows from the INLocationStatus table. I know to get the total QTY I can group the report by item.In this same GI however, I need to also output the total QtyAvail from both warehouses in the following format:Item - Warehouse - QtyAvail - Total QtyAvailABC - WHS1 - 10 - 50ABC - WHS2 - 40 - 50Is this possible?

Hi all, Does anyone know if there’s a way to pick Sales Order lines without having to create a shipment first?Right now, the only way we can pick is once a shipment’s been created, and we run everything through our WMS. The standard pick/pack/ship process doesn’t really suit our setup, and I’m wondering if there’s a better way to pre-pick stock into a designated area ahead of time?We’ve thought about just transferring the available stock into that area manually, then once the shipment’s created, reviewing the lines and updating them to the right location — but honestly, I’m hoping there’s a smoother, more efficient (ideally system-driven) method out there.Anyone come across a workaround or setup for this?

I’m creating a GI tool based on the AMRPDetail table,Users need to be able to input a sales order number into a parameter and then have the GI filter to show any sales orders “less than or equal to” that sales order number.I created a formula to parse out the SO number from the related document field. Can I use that formula field as the parameter? Thank you!

I try override the behavior of Shipped Qty on SOShipLine. from the scenario creating of sales order to creation of shipment using create shipment button. and after that there’s no changes of Shipped Quantity in Shipment Screen.  

Hello, I have created a new attribute for customers which will show their shipping account number (no carrier plug ins are used). I would like to add this to the shipping tab (or create an attribute tab) in Sales Orders. Is this possible?  

Context:  We are matching purchase orders to vendor bills based on the amount. Since we are not implementing the inventory, we are not using the purchase receipts. The items used are non-stock items.Scenario: In our purchase order, we have a single line item with a quantity of 1 and the full amount entered. Our goal is to perform partial billing. We attempted to create a bill against the purchase order and tried changing the unit cost, because the Amount field is not editable. After releasing the bill, the Purchase Order status changed to Closed (cannot do any AP bill) . When reviewing the PO transaction details, the Billed Amount is shown, but the Unbilled Amount is not.  Question: Are there any steps we may have missed? Is there a known workaround  for this scenario?  Thank you in advance and appreciate your help.   

Good day, we updated our item weights from pounds to KG and volume to CBM,  Currently our open PO count about 800.  I would like to a suggestion on how we can update all of them at once without have to open each one, recalculate and then close.  Anyone ideas.  Right the PO if not recalculated after open has the weight and volume from when it was created.   Thank you.Evan

On the Requisitions screen, you can select a PO Type and create a PO from the requisition.  I want to add the same Project Drop-Ship option that is available on the Purchase Orders screen to the Requisitions screen.  I’ve added the Project Drop-Ship option to the DDL.  When I go to Create Orders, it fails (obviously) because there is no project ID on a requisition.  I added UsrProjectID to the RQRequisition table.  I clicked Create Orders after selecting my custom DDL item and it looks like the code is “trying” to do what I want, but the Project ID is not provided to action.  My thought is that I can override the Create Orders to provide the custom Project ID field I added.When I look at the code for Create Orders, all the methods that do the work to create a PO are protected.  It looks like I would have to practically rewrite the entire code base just to do what I am trying to do.I think I can do an override on a protected method, but before I dive into copying 1000 lines of code, I’m

Hello,Hoping this is an easy one, I am trying to set/change the “From” to something other than Default on templates.  When I hit the magnifying glass, the only option is Default.  Is there something I need to change to allow the selection of another email account?  I have created email accounts for all users as well and still only get Default as an option.  

Has anyone created a quote process in the service module?Quote to sales order is working well in the main system, but I am struggling to make the same duplicate process for quote to service orders. Help please

Details on Lot number attributes to use this for the Supplier Serial Number.You can add attributes for an item of a lot or serial classThe Lot/Serial Details, ScreenId=IN2096PL Show the Lot number and Manufacturing number.The value of the attribute is only visible when you select the Inventory ITEM, Lot/Serial Details Screen.All other Attributes is visible on the CS Answer DAC. I am not finding the Attributes for the Lot Serial number and need to print this number on a label.How do we access the values?  

We have found that the Mass Change form erroneously converts the UOMs in the BOM to the base UOM instead of leaving it as it was.  This is catastrophic for us who use UOM conversions on our Raw Materials that are defined as a 20’ EA on the Stock Item, but in the BOM we consume IN (inches).  In the below example the BOM was erroneously changed to consume 272.00 EA (272 20’ pieces) instead of 272.00 IN (inches).Anyone else out there that has experienced this? 

I have created a generic inquiry to track the last time stock was counted (this is to identify items that have not recently been counted).  It works well until I activate the parameter for warehouse.  If the user captures a warehouse, the parameter value automatically becomes cleared after you capture it.  Has anybody experienced this before?  I’ve attached the generic inquiry.Version:  2024R1Build: 24.109.0016

I have setup a restriction group for a warehouse based on a service technician. In native Acumatica if I go to the service order or appointment, click details tab and add an item all I see are those stock items that are associated with that warehouse no other items or warehouses. If I go to the app, and do the same thing in an appointment I see all items, it looks like the warehouse restriction group does not work in the app or I am missing something in the app setup. Any help is appreciated. Thank you to all. 

I have a business event that gets fired off a GI and I'm running across a issue that the event won’t fire because it says the ScreenID for that particular GI is not available in the system monitor. I have re-created that GI and given it a different screenID but that GI still won’t fire.I have checked the sitemap to confirm that GI is showing up and it is. I can run that GI without any issues or the newly created one with zero issues and my results are displayed.Is this a bug in a older version of Acumatica or any other recommendations?ContextScreenId = GI992709ContextUserIdentity = adminCurrentCompany = CompanyNameEventID = Scheduler_SchedulerThrewExceptionEventIdSourceContext = SchedulerException =PX.Data.PXException: Error: This generic inquiry does not exist anymore.   at PX.Data.PXGenericInqGrph.PrepareCaches(String id, String name, Dictionary`2 parameters, Boolean fetchSchema)   at PX.Data.PXGenericInqGrph.CreateInstance(PXSiteMapNode node, Boolean fetchSchema, String prefix)   at

Hi, I am trying to setup an Adobe eSign in MYOB Acumatica instance by following this link MYOB Acumatica Adobe E-signI have already set the configuration in the Adobe side. But unfortunately, I couldn’t find the eSign in MYOB, and when I check it in the Access Rights by Licence Type, it is Revoked for all Licence Types.  How can I access the eSign functionality?

Hi Team, Please refer to the photo of issue I'm having with acumatica App. Fails to open work order says not connected to server. I have closed and reinstalled the app. 

We are trying to use the features of CRM and are stuggling to set up a Marketing Campaign. We are attempting to use CRM to market to existing customers and to prospects.  We have taken on a new product line and will sell the new product line to both existing customers and to prospects that we have not sold to.  We think we should treat both customers and propsects as “Leads” for this new product line. Is that correct? When we add customers and prospects to the Members of the Marketing Campaign, do we add them as a “Lead” or as a “Contact”? Any guidance is greatly appreciated.