Solved

Hi we are stuck and 2months behind in our implementation of Acumatica.   Our BOMs often consist of standard components and custom Make to Order components.  From the sales order it seems Acumatica generates the production order for the parent but uses MRP to generate the children.  The children production tickets then don’t contain information about the sales order or customer making it confusing for our shop production team (they don’t know what order the custom components are for).  We can’t use Auto Create Linked Orders or else it will disregard on hand inventory for standard components.  Hoping you can shed some light how you manage production tickets for sub assemblies?  

Hello,  Our company is a 2020R2 users. In the course of our financial workflow, we would like to create AP Checks and Payments (AP.30.20.00) first and then link them to open AP Bills and Adjustments (AP.30.10.00) later.  This would be done because i would like to match AP Checks to bank transactions as soon as possible, and then book the proper AP bill. I played with it in our system, but it seems that Acumatica’s workflow is only to create AP bill first, then create a full or partial AP Check and Payment. The “Receivables” module allows for AR Checks and Payments to be created separately from AR Invoices, but not the “Payables” mode.   Is there a reason why i cannot create AP Check separately as unlinked from AP Bills? Thanks,Kirill

i need help for this bug action prepare invoice in Shipment Screen (SO302000)in Shipment Screen, Project Field and Project Task Field is customize.this is source code for Project and project task protected void SOShipment_RowPersisting(PXCache cache, PXRowPersistingEventArgs e, PXRowPersisting InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (SOShipment)e.Row; if (row == null) return; //if((e.Operation & PXDBOperation.Command )== PXDBOperation.Insert) //{ var rowExt = PXCache<SOShipment>.GetExtension<SOShipmentExt>(row); SOOrderShipment shipOrder = PXSelect<SOOrderShipment, Where<SOOrderShipment.shipmentNbr, Equal<Required<SOOrderShipment.shipmentNbr>>>> .Select(this.Base, row.ShipmentNbr); if(shipOrder != null ){ SOOrder order = PXSelect<SOOrder, Where<SOOrder.orderNbr, Equal&l

We’re using file synchronization to send payment batch files to an external site. File Synchronization only works on a per file basis so we have set up one file that our export scenario will populate.Because we need every version of this file to be sent to the external site, I need to make sure that every revision of the file is synchronized.My thought was to override the Export button on Batch Payments (AP305000) to call the Process All Files action, using the Export File operation, on the File Synchronization screen.  The challenge is that I can’t see to find the name of the graph to instantiate to access that business object.Here is where I’m at:using System;using System.Collections;using System.Collections.Generic;using System.Linq;using PX.Api;using PX.Data;using PX.Data.WorkflowAPI;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CM;using PX.Objects.Common.Extensions;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.AP.MigrationMode;using PX.Obj

Hi Good night i have a query that works, but i need to aggregate groupBy and orderBy clauses. i saw some examples of the pdf guide but not working.I need group by :BAccount.bAccountId BAcount.acctName V_CEVendors.idEstimateEstimate V_CEVendors.vChecked  V_CEVendors.totalThis is my code that works. (without group by or OrderBy). [PXSelector(typeof(Search2<BAccount.bAccountID, LeftJoin<V_CEVendors, On<BAccount.bAccountID, Equal<V_CEVendors.vendor_Id>>>, Where<V_CEVendors.estimateNbr.IsEqual<CEEstimate.estimateNbr.FromCurrent>. And<V_CEVendors.idEstimateEstimate.IsEqual<CEEstimateEstimate.id.FromCurrent>.And<BAccount.type.IsEqual<SQLConstant.ONLYVENDORC>.And<BAccount.deletedDatabaseRecord.IsEqual<SQLConstant.DELETEDRECORDBOOLC>>>>. Or<V_CEVendors.idEstimateEstimate.IsNull.And<BAccount.type.IsEqual<SQLConstant.ONLYVENDORC>.And<BAccount.deletedDatabaseRecord.IsEqual<SQLConstant.DELET

Hi, is there any way to see the complete inbuiltlist of reports within Acumatica, without searching through workspaces or sitemaps?

I am creating a from in report designer in which the font is not a standard (i.e. not found in the list of fonts in report designer). I have installed the font on my computer and created the report template with this font.When the report is run on Acumatica, though, the font is incorrect and the spacing is out. Is there a way to get around this? Or alternatively, how do I find what fonts are available on the server?Many thanks.Sue

This file, and it’s related indexes are taking up half of our database. The current file size of the database (.mdf file) is 135GB and we’ve only had it installed for three weeks.At this rate we will have a 1TB db in ten months. Any idea what’s going on with this?

Is it possible to add the Unit Description to the title of the the ARM report?We have 5 units and I would like to put their name in the title of the report.  So that when I printed them all off I could tell which one belonged where.

I have a custom processing screen that sets some custom fields (for stale dated checks, they get  a lot of these due to small amount refunds that never get cashed).  My client wants these to be voided automatically at the same time which means in code it needs to call the void action on the APPaymentEntry graph, remove the hold flag and call the release action.  Not having much luck pulling all of this together.  We had an import scenario to do the void after setting the stale dated info but they want it to be all in one step.Here is the main processing loop.  Most of these will be Quick Checks (but not all) Correction, these will only be quick checks        public static void Process(List<APPayment> payments)        {                     var globalError = false;            var graph = CreateInstance<APPaymentEntry>();            var checkNumber = string.Empty;            DateTime? currBusinessDate = graph.Accessinfo.BusinessDate;            Guid currUser = graph.Accessinfo

Looking for a training guide or course for the new feature of WorkFlow.  Need to start at basic training.  Partner university does not have any courses on this.  I started to see that you need to removed all automation steps on a screen.  This seems scary. Any ideas.

We have dropship customers that require us to remove (overwrite with "X") the customer's contact (ARContact, SOContact) and address (ARAddress, SOAddress) information every few months. The address and contact are overdriven on sales orders and invoices. Acumatica's privacy tools seem to go too far, restricting the customer's account as well.Does anyone have a solution for this?

Hi All, Is there a way in Acumatica to bulk update a particular field in all the Business Accounts/Customers/Vendors? If yes, can we perform bulk updates on the records filtered by a certain criteria?For example: Change the Owner field for all Business Accounts in Colorado State with Status “Active”. Any help will be greatly appreciated.Best Regards,Amruta

Hi Experts,II’m trying to test Acumatica’s OAuth Authorization flow using Postman. I already created a Client in the Connected Applications screen, and set the flow to Authorization Code. Also I got the access token after I called the authorize api.I can call the OData service successfully as below.But when I call the web service to get sales orders with the access token, I always get a message “You are not logged in.” Here is the screenshot.Do we still need to call LogIn api again when we call the web service with access token?Thanks in advance!

Hi! How do I set up our ShipEngine Integration to pay Flat Rate?We have it all synced up to ship USPS Priority but how do I tell the system within the Box ID that this is a flat Rate envelope?

Some stock items do not sync over to BigCommerce, most of them do but for every 50-100 items that do sync over there is 4-5 items that do not. Most of the items, if I change the price, category, description it will re-sync itself and usually the ones that don’t I can force the re-sync and it will work. But occasionally a stock item won’t sync no matter what I change or how many times I resync everything, even if I force the re-sync it won’t pick up the changes on that specific stock item. I have set stock items the synced successfully and stock items that will not sync, side by side and both of them have the same settings. does anybody know what could be causing this issue? Thank You….

I have a report who was exporting just fine to Excel and PDF. However after rolling out a large swathe of customizations changes between myself and my VAR, the report does NOTHING when I click export to PDF or export to Excel. Anyone know what might cause this or how to fix it?

We have created a Sandbox instance with tenant, companies, calendar and financial periods configured and to ensure safety we take snapshots periodically to rollback changes if a mistake is made while configuring the system.Is there any method to revert the instance back to the original state, that is the system when you first create an instance? (no configurations) 

I have created a line level field in AP303000 form and I need to have Attribute ID selector namespace MidayaCustomizations{ public class APTranExt : PXCacheExtension<PX.Objects.AP.APTran> { #region UsrAttributeSelection [PXDBString(250)] [PXUIField(DisplayName = "Attribute ID")] [PXSelector(typeof(Search<CSAttributeDetail.attributeID,Where<CSAttributeDetail.attributeID, Equal<CSAttribute.attributeID>>>), typeof(CSAttributeDetail.attributeID))] public virtual string UsrAttributeSelection { get; set; } public abstract class usrAttributeSelection : PX.Data.BQL.BqlString.Field<usrAttributeSelection> { } #endregion #region UsrAttributeValues [PXDBString(250)] [PXUIField(DisplayName = "Attribute Values")] public virtual string UsrAttributeValues { get; set; } public abstract class usrAttributeValues : PX.Data.BQL.BqlString.Field<usrAttributeValues> { }

Hello, when opening the Sales Prices screen,  Inventory Items are not loading.  I have selected Price Type = “All Prices”.  I have looked in Sales Order preferences and couldn’t see anything relevant.Is there a parameter I’m missing to use prior to all the Items loading in the Sales Prices screen ?Laura

In Stock items - Description tab, is an option to have a default value for the style ? By default, the default value is ”Paragraph”, but I want to be ”Preformatted” for each new item.Thank you!

Is there a way to add the customer location into the global search.  As a field service company, the only thing we care about is the customer location because that is what all of our work is attached to.  Currently the global search doesn’t search for anything having to do with the customer location.

We have been sending emails regularly and this is the first time we receive this message.  These are not spam emails, its information we provide to our customers which they provided their emails.  How can I remove this error/flag? 550 5.7.1 Message detected as spam. [1626014335-920365].

Can an attribute field be mapped to a GI and auto updated with the GI field changes?  We want to use “calculating columns” in a GI and then have the calculated amount auto-updated to an attribute field.  Is this possible? 

Is there any possibility to have one instance (one URL) that has two different tenants which have separate databases.Requirements include,1) Ability of having different databases for different tenants2) We have created one sandbox with two tenants. In this license we can have 100 concurrent users. We need to create an additional instance in this same sandbox environment for development work.Attached below is the structure of the configured sandbox,  If there are any workarounds to this issue, or if you could give an explanation on how data is kept separate and identified in two different tenants that would be greatly appreciated.