Solved

For exmaple,Vendor Lead Time as 100 days for Warehouse 1Vendor Lead Time as 200 days for Warehouse 2  etc...

Hi there, For any GI results page like the stock Sales Order screen (SO3010PL), why do some fields allow you to filter by checking or unchecking specific values like the Status column does……while other fields like Order Type only list generic operators and prompt you for a filter value?What determines this distinction? Is this something that is editable such that we could make the Order Type field filterable in the same way as the Status field is? Thanks! Jon HunsickerJones School Supply

Does anyone know of a way to handle the new CO Retail Delivery Fee ($.27 beginning July 1, 2022) either with Avatax or without? Avalara had sent out communications regarding this which stated to perform the following: Merchants subject to this fee will need to add a $0 line item to their orders with the OF400000 tax code. I’m unsure as to how this would be done in Acumatica. Perhaps someone from Acumatica may know if there will be something released in a new build perhaps? 

How do we give someone access to SHARE COLUMN CONFIGURATIONS? I can only get it to run when I give someone admin rights, but these are managers for specific segments, not admins. Where do I enable SHARE COLUMN CONFIGURATIONS for these users? I swear I’m just blind, it has to be somewhere in Access Rights, but I’m not seeing it under hidden, system management, configuration, etc. Thank you in advance to whoever has the eagle eyes to find this setting!

Hi all,Does anyone know of a way to create a “timed” promotion for inventory items that we could customize by customer price lists and/or region?Thanks!Joseph

Having an issue trying to cost Inventory to Projects. Here is our workflow:We create a Service Order and associate it to a Project. We then requisition items by either creating POs within the Service Order, Appointment, or Project. I can confirm that when the items on these POs are received, they are going into Project Stock and not Free Stock. However, when attempting to Run Billing on the Appointment we are receiving the below error. It is as though the Service Order/Appointment is trying to create an Inventory Issue from Free Stock. Is there some setting I am missing to make the Service Orders create an Inventory Issue using Project Stock?I do not want to “Allow Issue from Free Stock” as the material I am trying to bill is in Project Stock

I’ve been playing with creating a new state in our sales order workflow.  The goal is to have a “Staged for Setup” workflow on certain order types that would take place between Open/Backorder and Shipping.I was able to create the state easily enough, and the transitions into the state.  My problem comes up with getting out of that state.  While I have a transition out of “Staged for Setup” for “Create Shipment->Shipping”, the “Create Shipment” action is disabled when I’m in this new state.  I did add the Create Shipment action to the Actions tab of the new state but it is still disabled.Is there something I’m missing for getting the actions that I want to be able to take enabled in this new state?

We have setup a Pending Approval Notification in Purchase Orders Preferences that whenever a purchase order goes for approval, the approver gets an email that there is a PO that needs to be approved.  There is also Mailing & Printing to notify that the PO has been created. Is there a way to notify the requestor that the PO has been approved without creating a business event or another email template? Probably an auto-generated email that PO has been approved. Thanks so much for your time. 

Currently, in Sales Order Preferences, there is only one default Shipment Numbering Sequence configured (e.g., SH####).However, the business requirement is to have different shipment numbering sequences depending on the Order Type.For example: Standard Orders → SH#### RW Order Type → SL#### Is it possible to configure multiple shipment numbering sequences based on Order Type? If not available natively, is there a workaround (e.g., customization, automation, business event)?

Hi All,As per our requirement I have created a new COA 20040 - while creating the same selected use default sub account check box and saved.  At the same time while creating Non Stock Items selected this sales account and updating  default sub account.  it is not allowing me to save and showing an error as below 'Sales Sub.' cannot be found in the system. Please verify whether you have proper access rights to this object.  I have verified all access rights and provided necessary accounts.  Stil showing same error.  Please help me how to fix this issue.  

It would be nice to create the Prepayment as a “request” to send to the customer. But the Sales Order status remains as Awaiting Prepayment until the Prepayment is Released. While the Prepayment is still Balanced, that would indicate that the payment is not yet received.  A workaround is to create the Prepayment in AR Payments and don’t link to the Sales order until after payment is received. But this requires more effort on the part of AR team and making sure they link to the correct Sales Order.Is there any way to control this?  To leave the Sale Order Awaiting Prepayment until the Prepayment linked to the Sales Order is Released?

Hi,Building an integration with Shopify for a client. I am using custom fields to store the order ID keys and there is a PXCheckUnique in place on this field to prevent duplication. #region UsrMAXXShopifyOrderID [PXDBString(30)] [PXCheckUnique( Where = typeof(Where<SOOrderExt.usrMAXXShopifyOrderID, Equal<Current<SOOrderExt.usrMAXXShopifyOrderID>>>))] [PXUIField(DisplayName = "Shopify Order ID", Enabled = false)] public string UsrMAXXShopifyOrderID { get; set; } public abstract class usrMAXXShopifyOrderID : PX.Data.BQL.BqlString.Field<usrMAXXShopifyOrderID> { } #endregionThis validation works as expected in the UIHowever, if an identical request is made then in the response all Usr fields that are on the SOOrder object are null and the order is created without any of these fields created. (There is a Usr field on the SOLine that is still populated)I have done integrations for other clients

Acumatica has been consistently releasing new versions (R1 and R2) every six months, bringing valuable enhancements and new features. The pace of innovation is appreciated, and many of the new capabilities are genuinely useful.However, from an implementation and consulting perspective, we are increasingly facing challenges during version upgrades.In several upgrade scenarios, we have observed: Existing functionality that previously worked without issue begins to fail or behave differently. Customizations and reports requiring unexpected rework. Performance inconsistencies post-upgrade. Support responses indicating the issue is a “known issue” and will be addressed in a future release. While we understand that no system upgrade is perfect, it becomes difficult to explain to customers why stable functionality in the previous version is impacted after moving to a newer release — especially when the resolution is deferred to the next version.Frequent releases are beneficial for innov

Hi,I wanted to see if there were separate rules for INSiteStatus vs. INLocationStatus’ QtyAvail fields?INSiteStatus returns a value for QtyAvail that matches the INventory Allocation summary in that it deducts ON Issue, Allocated and BAckordered - which are defined in our default calculation rules.For INLocationStatus, it is only deducting the on issue amount but not allocated / backordered. is this an incorrect behavior that we need to correct or done on purpose?ThanksJoseph

I’m trying to pull one character out of the PMProject.ContractCD field in Report Designer.  Using this expression...=Substring(CStr([PMProject.ContractCD]), 5, 1)...a “0” is always shown no matter what number is in the numeric 8 position field.  This expression DOES work in a GI, however, and pulls the correct digit.  How can I get this to work in Report Designer?   

Creating a construction schedule - calendar view or Gant view displaying each project and the duration. This could be a separate screen or a widget option within a dashboard. Having the calendar view would our company to see gaps in work and the scheduling of project teams (site supers, project managers and admin, and subcontractors). We currently need to use a third party resource to accomplish this task.

I have this GI that is looking at SO Lines. I am wanting to restrict which SO Line is showed based on the site ID. I heard (correct me if I am wrong) that if I can filter via the relations table, the GI can run faster (vs using the conditions tab or creating filters in the user facing GI). But I can’t seem to make it work. I’ve tried every variation I know (hence lines 2 and 3 are different in the child field. If creating this filter in the conditions tab will the direction I should go, then I don’t even need to link the SOLine and INSite tables.

Hello All,We are implementing Acumatica and are debating whether to use AWS or SharePoint to store document.  In our case, we would like to give access to a Contract Manufacturer only to specific subset of design documents.  Has anyone implemented solution capable of controlled access, upload nottifications, and revision control?

Hello Community,Could you help me with code that allows me to create a discount code and then apply it to a sales order?I am creating the discount code, and it is being created correctly — all the data is saved properly in both the header and the details. However, when I try to apply it to a sales order, the discount code is not applied: the sequence ID is not generated automatically, and when I set the sequence ID manually, the type is not set. By contrast, if I create the same discount manually and apply it to a sales order, all the fields are saved correctly.  

Hi everyone,I’m working on an import scenario for the Shipments screen (SO302000) to upload serial numbers on the Line Details screen.Right now, my scenario finds the shipment and uploads the serial numbers — but all serial numbers are ending up on the first shipment line, regardless of which item they belong to.What is the proper way to configure this import scenario,   

Just checking for a little advice.First, I’d love if this were possible with in-box or Generic Inquiry type solutions.Barring that I’m questioning how to modify the available columns in this selector box (or any given selector box really).“Select Revision” BoxIdeally I could click the gear icon on the “Select Revision” pop-up. But it doesn’t show any columns that aren’t already shown.If I have a UDF or another field that isn’t already shown, I’d like to be able to add them by default.Is there any way to do this in-box?If not, does this post represent the best path forward, and where is a good place to start in terms of identifying the screen/business logic to modify? 

Hi All,Acumatica's Production Cycle for a manufactured product consists of 2 major steps: 1) produce volume first and then 2) subsequently, pack the volume into the required SKU.In such a scenario, is there a way to ensure that there is full availability of all materials required for producing a specific volume of a product, prior to confirming a Production Order? If yes, how and where can this be implemented/checked? In other words, a Production Order should not be allowed to proceed further (any subsequent steps) if there is either no or not enough material as required to produce a specific volume of the manufactured product.The same applies to the 2nd part above i.e. to again ensure that all packaging material required is available in full quantity during a request for Packaging Materials. Since this is a separate TR request (Inter Warehouse Transfer), how to ensure that this TR request is tied to the Production Order from step 1 above? The reason being, in our case we use some comm

Hello Community,I want these changes on the original screens. For my custom screens, this worked when I added actionsConfig: { exportToExcel: { hidden: true } } in the @gridConfig of the .ts file. 

Hi all,I’m currently trying to receive the owner data of a shipment using the REST API.The response of GET /entity/Default/24.200.001/Shipment/<ShipmentNbr> contains the contact ID:... "OverrideFreightPrice": { "value": false }, "Owner": { "value": "56" }, "PackageCount": { "value": 4 }...However, I can’t request more information about the contact.The owner of a shipment is an employee. But the REST endpoint /entity/Default/24.200.001/Employee does not contain the ContactID.Is there any other endpoint that can be used?Thanks in advance!

Is there a way to add the date the invoice was paid in a GI with the invoice number and the date the invoice was generated? I am trying to show in the system the average date an invoice it paid in correlation to the customers terms. Are the customers paying late or on time?