Discussion Forums

We are a manufacturing company with a heavy drop shipping business. While we have materials that come into our building that are purchased, received, and paid via the AP process, we are struggling with a streamlined process for drop ship POs. Currently, our purchasing department enters the PO and once the Accounting team receives the invoice, we enter the PO Receipt and creates the AP bill manually. We cannot auto-create the PO Receipt once the PO is printed/emailed to the vendor because we need the “proof” it has been sent to our customer. How are other Acumatica customers handling a similar process? Ideas?

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.

Hi! I have a GI created where it shows all items on landed cost transactions. I am grouping by inventoryID because I only want to see one line per item. With this, if the item shows on more than one landed cost, I want to sum up the allocation amt field, and I do not want to sum up the qty and ext cost field. Right now, when I group by inventory, qty and cost field automatically sums up too. Is there a way to prevent these two fields from summing when I group by the item?For example:this item is on three different landed cost with different LC allocated amtwhen I group by inventory, I only want LC Allocated Amt to sum, I do not want the qty and cost fields to sumIn my result grip, I only have SUM in aggregate function for Allocated Amt Any suggestions are appreciated! Thanks!!

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!

Our organization just upgraded to 24R2 and we are seeing new functionality that did not exist in the prior version.We have a shipment with a single line item, but two packages.  When we pack into the Contents, the package that we specify isn’t being used.  It seems like it is adding to the package with the highest PackageLineNbr.For example, we have the following: { "id": "74db342b-bf4e-ef11-93aa-00155d1eec41", "rowNumber": 1, "note": { "value": "" }, "Packages": [ { "id": "262d42ac-c04e-ef11-93aa-00155d1eec41", "rowNumber": 1, "note": { "value": "" }, "Contents": [], "LineNbr": { "value": 1 }, "custom": {}, "_links": { "files:put": "/AcumaticaERP/entity/Packing/22.200.001/files/PX.Objects.SO.SOShipmentEntry/Packages/262d42ac-c04e-ef11-93aa-00155d1eec41/{filename}" } }, { "id": "7

Dear Connections, I'm creating requisition with the item code "RR-01010" and an ordered quantity of 100. While doing vendor bidding, I select two suppliers, each with a quantity of 50. Finally, the purchase order is created. I can see that two POs have been generated. However, the problem was that the vendor price not taking on that PO.  Each vendor I set the different price.  While creating the direct PO, the vendor price was accurately taken but not from the requisition. Please advise on this query. Thanks Ram 

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 All,I’m trying to get more granular detail behind the discounts that we’re running through the system.The idea is that I should be able to report on discounts by Customer, Warehouse, InventoryID, DiscountCode (Line Level) , DiscountCode(Group Level). We are currently running multiple concurrent group level discounts with quite specific conditions so there are some instances where a single SO line has 3 group level discounts applied to it. Is there a table/ query that would allow me to see which lines on the SO a single group level discount code/ discount sequence has been a applied. Ideal Outcome:  Thanks in advance

I need to handle a new status on ARIncoice for legacy reasons and added therefore a custom field called cegEStatus in a DAC extension of ARInvoice.  [PXCopyPasteHiddenFields(typeof(cegEStatus))] public class ARInvoiceEIExtBase : PXCacheExtension<ARInvoice> {     #region CegEStatus     [PXDBString(50, IsUnicode = true)]     [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]     [PXUIField(DisplayName = "Electronic Status", IsReadOnly = true)]     [EiStatuses.List]     public virtual string CegEStatus { get; set; }     public abstract class cegEStatus : BqlString.Field<cegEStatus> { }     #endregion } This field was also added to AR301000.A new DAC has then been created to store the values assigned to the status of a given ARInvoice over time.    public class EiInvoiceRegisteredStatus : IBqlTable    {        public static bool IsActive() => PXAccess.FeatureInstalled<FeaturesSetExt.cegEInvoicingOutgoing>() || PXAccess.FeatureInstalled<FeaturesSetExt.cegEInvoi

are there any ways to reverse and apply memo multiple released invoices at once using Import by Scenario. Thank you.

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!

Hello @everyone,I would like to create a customization where I link sales orders of different types together and have this relationship accessible by displaying the related/linked order.I have created a custom order type PL which will be linked to the order type SO such that 1 SO order can be linked to more than 1 PL order.I have created 2 custom fields: a checkbox will appear to indicate that a SO order is available for linking and a selector field for PL orders to select the SO order to link to.I have also created a custom tab which will appear only if the order type is SO to display all PL orders linked to that specific SO order.This issue I have is a behaviour I have noticed where after I have linked the orders and selected the SO order that has a link, some parts of the screen show the most recently linked PL order  while other parts show information on the SO order. When I refresh the screen, that PL order will be in focus. I have attached screenshot of this behaviour.  I have al

Hi,I need to create a sales order invoice report below like that.Payment Reference and Advanced Payment Reference need to get from same field in ARPayment table.When Sales Order Invoice has Payment type I need to get ExtRefNbr field into payment Refernce column and When Sales Order Invoice has Prepayment type I need to get ExtRefNbr field into Advance payment Reference column How Can I get data from Report Builder.

I am try to get the customer portal site to not automatically check this box, so that anyone who comes into the cases page sees all the cases, and not just their own. I assume it is something I have to change in the Customization Project Editor, but I’m not sure where the specific change needs to be. How can I automatically uncheck this box?