Solved

Hi All,Currently we can GRN any amount at the purchase request other the quantity specified in the PO. It only displays a warning that we are GRNing a quantity higher than PO quantity. We need to restrict this to a percentage of 10% of PO at the receipts.Is there a way to do this (Using current settings) without going for a customization.Your valuable ideas are highly appreciated…Thanks in advance.  

I want to use the Default/Shipment API to create a shipment for a sales order line that isn’t due to ship yet. In the UI, this produces a warning on the SO line saying “Scheduled Shipment Date greater than Shipment Date”. See this topic for a description of the behavior:When this request is sent via API instead, the warning prevents the Shipment from being created. Is there a way to overcome this warning and save the Shipment anyway like you can in the UI?

Hi everyone, how come in the actual Sales Order we can put the status to WO Pending when removed from Hold but it doesn’t seem to show in any filters or parameters?  

On the Request form RQ301000, we would like to limit the number of characters in the RQRequestLine description field.  The default limit is 256.  Is there a relatively simple way to limit to 100 characters?

Hello , I am getting stuck in the business event which can auto create purchase receipt here is my business event and import scenario. Is i am missing out something? 

We received money from customer in advance and unused money needs to pay back to customer at the year end, how to record prepayment and then how to apply prepayment to invoices?

Hello,Not a C# developer, and very new to acumatica.Using the below code I was able to figure out how to add the CustomerOrderNbr and ShipmentNbr to the package ex custom reference nbr 1 & 2. The label is generated using the UPS Rest carrier.My issue is the the very lengthy prefix as seen in my attached image. How do I remove the custom reference prefixes “Reference No.1” and “Reference No.2”Also below is my code. Please let me know if I need to add anything like cache updating. Currently the code works but other examples included some cache update code I did not understand.  protected void SOPackageDetailEx_RowPersisting(PXCache cache, PXRowPersistingEventArgs e, PXRowPersisting InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (SOPackageDetailEx)e.Row; SOOrderShipment shipment = PXSelect<SOOrderShipment, Where<SOOrderShipment.shipmentNbr, Equal<Required<SOPackageDetailEx.shipmentNbr>>>>.Se

I’ve read through a bunch of posts here and on Stack Overflow but haven’t found an answer that works.  I want to extend Customer with a form on a custom tab using a set of fields from a custom table, rather than the user field approach which will add fields to the BAccount table and thus the other entities that share that definition.  I created a custom table then a customization project with the DAC schema definition, extended screen AR.30.30.00 with a new tab, added a form to the tab, and then bound my view for the custom DAC to the form.  Now for starters, I want to make the tab conditionally visible on customer class ID using the RowSelected event.  Based on the T210 training, I assume I need to get a reference to the extension then set the tab to visible if it’s set to not visible generally.  I can’t seem to get the syntax correct for the extension variable.  I either get the CS0120 (Object reference required...) error or the CS0311 (Type...can’t be used as type ‘TNode’...) error

After inserting an image into a column, the gap between the column and the grid increased. Can I manually change the gap between them?   

Is there a way to do an excel upload of the exact SKU list of inventory IDs we wish to have counted? (that do not share the same ABC code, class, or otherwise – Just a literal list of which ids we wish to have counted)I have read around and seen articles on importing the sheets of the inventory count totals, how to set up inventory counts by code or class or warehouse – However, this is about uploading the actual list of requested specific SKUs to count. 

Hi I have a UDF (APRegisterExt.usrMAINMAINAPKynectionRefNo) which I need to this field’s value under the Supplier Details UDF (APDocumentResultExt.usrMAAPSDKynectionRefNo)   I have added the logic below but receive the following error:\App_Code\Caches\APDocumentEnq.cs(31): error CS0246: The type or namespace name 'APDocumentResult' could not be found (are you missing a using directive or an assembly reference?) public class APDocumentEnq_Extension : PXGraphExtension<PX.Objects.AP.APDocumentEnq> { #region Event Handlers protected void APDocumentResult_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (APDocumentResult)e.Row; if (row == null) return; var docResultExt = cache.GetExtension<APDocumentResultExt>(row); var apDoc = PXSelect<APRegister, Where<APRegister.refNbr, Equal<Required<APRegister.refNbr>>, And<APRegister.docType, Equal<Required<

I am receiving the error below when I try to process a refund from Shopify into Acumatica:SalesOrder.Details[0].WarehouseID: 'Warehouse' cannot be empty.Inserting  'Sales Order Line' record raised at least one error. Please review the errors.

Im trying to think of a creative way to get around an issue we currently have, we’re implementing having sales order confirmations as we load a customers order, but a range of products that we make show up on Back Order.To take a step back, its mainly things we have to either make or decant. For example, 5L of alcohol. We store it in 1000lt tanks, decant as needed. This is a specific for a lot of stains for pathology use. Internally we send a copy of this to the warehouse or lab to be made, then kit assembly to build the item > create shipment ready for a picking slip.There could be a delay here though, sometimes a few hours, sometimes a day or two.Very rarely do they actually goto back order by the time the sales order is invoiced. Majority of the items where it would happen are critical to the order the customer is placing, I don’t want them thinking there is a delay with these products. But I don’t want to confuse all customers with a disclaimer in the body of the email sending t

Hello All,I have a client that has two companies in one tenant with a fiscal calendar and the other on a calendar year. I can’t figure out how to use the other both calendars in fixed assets. Can it be done? Thanks

.

Hello all,I have been trying to setup approval maps for various projects that have different project managers. So I want these project managers to approve Invoices.How can I achieve this?

I need to get some SOOrder extension values that I don’t have in my POReceipt.  Is there a way to code this in C# in my POReceiptEntry graph extension?

There’s not a whole lot of information on adding the Add Items dialog/action to other screens. I see that the interface has been generalized to make it easy to implement the functionality across different screens. Just wondering if someone’s implemented it on another screen and has some advice or code they’re willing to share.

Hi All,I have a customer that want to have their statements send to a specific email address. When I send the customer statement it send it to the Account Email? What am I doing wrong?  ThxDries

This is our 3 months on this system so still a lot to learn. We're using internal approval workflows in Acumatica. My question is: is it possible to modify specific document attributes after an initial level of approval has been granted without triggering the entire approval process again?For instance, if a Project quote is approved by a manager, can we update the attributes without requiring re-approval by the manager or subsequent approvers?Additional Information:Acumatica version Acumatica 2023 R2 Build 23.211.0017 Looking at Project quotes attributes and updating the yellow highlighted fields.   Hope my question is making sense and that someone can be able to assist me.

When in a separate window or list, how can I scroll instead of using the Next or Previous pages buttons?

Hello all,I have been working on Rate tables for Project module and have defined some rates for lets say Project A & Project B for Employee 1 & 2.The rates setup are as :Start Date: 01/01/2024; End Date: 12/31/2024; Rate: 10$; Project ID: Project A & B; Employee ID: 1 Start Date 01/01/2024; End Date: 12/31/2024; Rate: 20$; Project ID: Project B; Employee ID: 2Now I am looking to import new rates for the year 2025. So the scenario would be:Start Date: 01/01/2025; End Date: 12/31/2025; Rate 15$; Project ID: A ; Employee ID: 1 Start Date: 01/01/2025; End Date: 12/31/2025;; Rate: 25$; Project ID: B; Employee ID: 1.Eventually when I am trying to create a new rate code for the 2025 scenario, Acumatica displays an error stating the Rate Code, Project ID & Employee ID has already been used. Now if I go ahead to delete the 2024 Rate Code and try to create for 2025, it doesnt trigger any error. How can I insert both 2024 & 2025 rates with different rate codes? 

Hi,I tried to create an import scenario for the Sales Order Bulk update. Here in the Sales Orders there are some items that price need to be taken from the Sales prices setup system and there are some items that price need to be taken from the Excel. When uploading Sales Orders through the import scenario I tried to write the Logic in the import scenario as =IsNull( [Unit Price],[Transactions.CuryUnitPrice]), But the system does not take the price when creating the Sales Order if the unit price is not avaialble in the excel file. How can I solve this?Thanks in advance. 

I have a POOrder object which contains both the ShipContactID and ShipAddressID.  How do I obtain POShipContact and POShipAddress using either BQL or PXSelect?

Hello :)I’m trying to override the ReleaseClaimDetails method under the EPReleaseProcess graph using the code below. public delegate List<APRegister> ReleaseClaimDetailsDelegate<TAPDocument, TInvoiceMapping, TGraph, TAPDocumentGraphExtension>(ExpenseClaimEntry expenseClaimGraph, EPExpenseClaim claim, IEnumerable<EPExpenseClaimDetails> receipts,string receiptGroupPaidWithType, string transactionType)where TGraph : PXGraph, new()where TAPDocument : InvoiceBase, new()where TInvoiceMapping : IBqlMappingwhere TAPDocumentGraphExtension : InvoiceBaseGraphExtension<TGraph, TAPDocument, TInvoiceMapping>;[PXOverride]public List<APRegister> ReleaseClaimDetails<TAPDocument, TInvoiceMapping, TGraph, TAPDocumentGraphExtension>    (ExpenseClaimEntry expenseClaimGraph, EPExpenseClaim claim, IEnumerable<EPExpenseClaimDetails> receipts,    string receiptGroupPaidWithType, string transactionType,    ReleaseClaimDetailsDelegate<TAPDocument, TInvoiceMapping, TGr