Solved

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

When trying to add Data scripts getting an error - Stated -  Error Code - 406 while clicking on OK after adding Scripts 

Hi everyone Is there a way to include configurable components to subcontract shipment?This item we are trying to set up has fixed materials and configurable components. Once partially assembled, all parts are to be shipped to client site for installation by a subcontractor. The fixed components are can set up as subcontract - ship to vendor as outside process. But there is no way to set up the configurable components to subcontract - vendor shipment. Everytime a production order is created with configuration, we have to manually update the configurable materials, for them to be included in vendor shipment and show up the packing list. Is there a better way to do this?Thanks in advance. 

Does anyone know how to build a Generic Inquiry to show the inventory that is currently in process on a production order.  like Storage Details by Location but for inventory that all the operation on the bill of material has been completed yet.   we are new to Acumatica and need this when confirming our on hand inventory counts.   

Can a debit adjustment in AP be applied in any way when the amount owing to the vendor is zero (0)?The credit for the bill in questions has already been settled.

i have a Generic Inquiry that i have been using for a few months now and all of a sudden the Value for the Default Receipt to is showing up as a number.  I also have a problem with my filters using this same field so i think i may be related.  how do i get it to show the actual field value.    thank you in advance.   Below is the Stock Item  and below is a screen shot for the Results Grid.     

Hi There,I’m in Acumatica R2 2023 version and tried to deactivate one of the old cost code which is not applicable anymore. I’m not able to uncheck the active box. Please advise the steps to inactivate a cost code. Thank you.  

I have the SiteID, SiteCD (Warehouse ID), BAccountID.   How do I grab the address information, using C#, from the Address table on the Warehouse (IN204000) page?

Looking for some assistance in the correct API method to  create a POST for a Production Order Move Entry.

HiHow can I pass Class Item description of the inventory id and the sum of  projectreveneue budget.Amount based on the project and customer id in a sub report that is needs to be passed in the group footer of the main report which contains the project revenue budget details based on project id and customer id.I struggle to apply the variable declared in the detailed section of subreport to use it in main report to display     Item Class description     Sum ($ Subreport_amount)Thanks

Hello, We recently changed the Inventory Account on a Stock Item, but the change is not reflected when we run the inventory valuation report (it still shows the old account it had before).Any ideas on why this is happening?Thanks, Ruben.

Hello all! I am trying to import vendor payment instructions for EFT (Canadian ACH) and when I run my import scenario, the error I am getting states that “Error: Provided value does not pass validation rules defined for this field.”What I am trying to update: My import scenario :  Why is this happening and does anyone know how I can fix this? Thank you!

Hi! I am trying to import a list of prices using the import from file function on the Sales Price Worksheet screen. I received a timed out error but the screen still shows that it is executing. I checked in System Monitoring, and it says task finished, and there is no running process or request, but the Sales Prices Worksheet screen seems to suggest that it is not done yet. Can someone help clarify for me what this means? Should I cancel this or refresh the browser? Thanks!

We’ve had a push notification which has been working for quite some time, and then a couple of months ago, it simply stopped firing/triggering push notifications.After some investigation, it appears that when you make use of a custom field in the conditions tab of the GI that’s being monitored, it simply doesn’t trigger. To test my theory, I set up a super basic GI and managed to get push notifications to go through to https://webhook.site/. However, as soon as I add a custom field into the condition tab of the same GI, the push notifications no longer trigger.  Based on this test, it looks like custom fields are no longer supported. We recently upgraded to the version 23.112.0032. Is anyone else aware of this change, and what options do I have to trigger push notifications based on a custom field on the SOOrder changing?

How do we Override email for Customer statements? When I select Recipients→ Override Recipients, the account default email still appeasrts in the Recipients section. In the image below, we only want the Statement to be sent to the Contact email and not the Billing email. The Billing email will not delete or allow us to overwrite it.   

Hi, is there any way/workaround to put in SO for customers on Credit Hold? We want to put in the orders as status “Credit Hold”, so our Shipping Dept. will know not to ship items until customers balance is cleared. If we won’t put in orders for customers on Credit Hold we’ll for sure not get their order, rather to put in their order as on Credit Hold and then collect their balance?! 

I’m trying to get the Warehouse name from Details in the SOShipment.  I was able to get the integer ID using this:SOShipLine firstLine = Base.Transactions.SelectSingle(); The firstLine.SiteID has the ID but how do I get the SiteCD (name)?

I have been asked to set the default sort for the Inventory Transaction History screen to sort by Descending Date order.  I found the following which does the job.  The only problem is it breaks the hyperlinks for Reference Nbr.  Clicking on Reference Nbr used to open the relevant Adjustment or Receipt but after adding this code they don’t work.  They still look like hyperlinks and accept the click but no page pops up.  Does anybody have any ideas why this happens and if there is a work around? Or if this is the wrong way to do this and there is a better way please let me know. namespace PX.Objects.IN{ public class InventoryTranHistEnq_Extension : PXGraphExtension<InventoryTranHistEnq> { #region Event Handlers public override void Initialize() { Base.ResultRecords.OrderByNew<OrderBy<Desc<InventoryTranHistEnqResult.tranDate>>>(); } #endregion }} Thanks for any help or advice, Phil

I had 3 error messages, and it cannot create invoice as below:1.The sales order line has no active link to a line of a purchase order.2.Lines with zero-unit cost and lines that are marked for dropship are not included in the calculation of margin for sales orders.3.Order SO 000077.Thanks so much for your help and sharing.

I tried this but I just get “Object reference not set to an instance of an object”:public PXSelectReadonly<SOOrder, Where<SOOrder.orderNbr, Equal<Required<SOOrder.orderNbr>>>> findOrder;        [PXOverride]        public void PostPersist(Action baseMethod)        {            baseMethod();SOOrder order = this.findOrder.SelectSingle((object)this.Base.OrderList.Current.OrderNbr);}

i want to add a doctype here in my Book but its not displaying whats wrong with my relationship  

 Hi, I’ve tried to adapt the instructions shown in this example for controlling access to releasing Journal Transaction to AP Bills & Adjustments, but I’m not having any success.How to set up Release button for certain users only? | Community  When I look at the user’s access none of their other roles are changing these values, but the user still has access to the Release button on the Bills & Adjustment screen.Am I missing another element that needs to be revoked?Thank you!