Solved

Hi all - I’ve run into a situation I am hoping someone can provide insight / a solution for. We had a production order (RO A) for quantity 4. Welding completed OP ID 10 for quantity 10 (they built 6 over). Assembly processed RO OP ID 20 and 30 for quantity 4 and then RO A was closed. The cost of the 6 extra welded parts were rolled into that of the 4 completed parts. Is there a way to reopen a production order to complete OP ID 20 and 30 for the remaining 6?Any advice is appreciated - thanks! 

Hello All, I am in the process of integrating smartsheets and I’m running into user authorization issue. When I try to load smartsheet templates, I receive a message stating “you are not authorized to perform this task”. I am an admin-level user. Does anyone know what user role(s) need to be modified? Thanks in advance. 

Hello!Is there any possible way to restrict some of the document types for users? For example, we need to restrict the ‘Credit Memo’ document type for one user.Thank You,Regards Amanda 

Hi everyone,is there anyone who can tell me where can I find the B2B Portal documentation?

Hello,I work for an Acumatica VAR and currently studying for Shopify installation. However, when trying to implement the connector it is asking for a public address and I’ve only got a local install, any workaround for that ? Thanks

 Hello:In many screens we can upload files but the size is 1 GB and now I know for Acumatica that can be increased to 2 GB, with this articule:Next But we need in the screen of opportunities for line upload 2 GB, ¿is it possible with the articule top?Thank you     

How would I go about fixing this?  

Hi everyone. Quick one please. Can Power BI reports be done across multiple tenants 

Hello,I’m trying to resolve the following issue: custom column added to the grid contains no data.Here are the details.I am trying to customize the Run Service Contract Billing (FS501300) form to add Organization ID column into its Contracts grid.To do that I extended the ContractPeriodToPost DAC for the grid based on the following article: https://blog.zaletskyy.com/post/2020/03/09/post100 .My extension is as following.using PX.Data;using PX.Data.BQL;using PX.Objects.GL;namespace PX.Objects.FS{    public class ContractPeriodToPostExt : PXCacheExtension<ContractPeriodToPost>    {        public static bool IsActive() => true;        #region UsrCompanyID        [PXInt]        [PXUIField(DisplayName = "Organization ID")]        [PXDBScalar(typeof(Search<Branch.organizationID, Where<Branch.branchID, Equal<ContractPeriodToPost.branchID>>>))]        public virtual int? UsrCompanyID { get; set; }        public abstract class usrCompanyID : BqlInt.Field<usrCompany

I'm building an integration that needs to extract data from an Acumatica record and build a json string. My process for doing this is using an export scenario to define what data gets pulled from the record. Is there any way that I can leverage the logic in SYMappingUtils/SYImportProcessor to pull data? Ideally I want to pass the record and the mapping to a method, and it returns the mapped data/formula evaluations from that record. Below is how I've been able to get a portion of the data, but it doesn't work for most PXSelector fields. It pulls the integer key value and doesn't return the CD value like the export scenario does. Base.Views[objectName].Cache.GetValue(Base.Views[objectName].Cache.Current, fieldName);

In SO Process Orders, I am trying to change the sort sequence for SO’s displayed. The default is by Order number, but I want it sorted by RequestDate instead, when the list is initially displayed. I created a SOCreateShipment extension, and extended the BuildCommandCreateShipment() method:  public class SOCreateShipment_Extension : PXGraphExtension<SOCreateShipment>  {    #region Event Handlers    public delegate PXSelectBase<SOOrder> BuildCommandCreateShipmentDelegate(SOOrderFilter filter);    [PXOverride]    public PXSelectBase<SOOrder> BuildCommandCreateShipment(SOOrderFilter filter, BuildCommandCreateShipmentDelegate baseMethod)    {      PXTrace.WriteInformation("BuildCommandCreateShipment() started from extension");      // Add Order By Request Date to default view      PXSelectBase<SOOrder> extFilter = baseMethod(filter);      extFilter.OrderByNew<OrderBy<Asc<SOOrder.requestDate>>>();      string errmsg = "extFilter value is: " + extFilt

I have created an extension of SOCreateShipment, where I redefined the ‘Orders’ Data View. I now want to debug the flow for loading rows into the grid of orders. I am able to define breakpoints in the Extension, and Visual Studio breaks at the requested statements. While debugging, I also opened the base source code for SOCreateShipment, at:C:\Acumatica\MyWebApplication\App_Data\CodeRepository\PX.Objects\SO\SOCreateShipment.csand added needed breakpoints. When I open the website, attach to process, then run the application, it breaks at the statements defined in the Extension, but not the statements in the base code. I reviewed the steps in the Customization Guide, and Acumatica website, but I don’t see clear steps on how to debug the base code. Can you point me to the proper steps?

Hi All, .i am basically from integration background.. i've just installed the local instance of acumatica ERP.. i wanted to create an employee in acumatica via postman by using the rest apis..… i have read the documentation but didnt understand how can i get those Endpoint URLs.. please help me out.. Thank you  

Hello Team, We are trying to setup one Bank Rule that will cover restaurants (McDonald’s, Subway, Burger King etc).However, we have been testing it, and it looks like we cannot add more than one single word when either implementing a Wildcard or a Match Case. On my screenshot below, I am trying to create a rule that will cover both Netflix and McDonald’s. The wildcard works for Netflix, as the transaction gets matched. However, the moment I add  “ , McDo* ” the rule breaks and does not end up matching Netflix at all.  Has anyone tried implementing this kind of rule? Does anyone know if it is possible? Just trying to get it to work like QuickBooks as they offer a “keyword” section for their rules. Thanks!

Can anyone tell me how individual production orders can be prioritised (reordered) in planned production orders?I.e. Sales would like to produce individual production orders earlier than planned or place new orders with high priority before other production orders. Is this possible? If so, how?

Hi All. Do you have any idea how to disable control account in Receivable Module? Our current version is 2020 R2. 

Hi! I made some error upon creating cash account. I have made the Accounts Receivable as cash account. Is there any workaround for this? System says that I can no longer delete the cash account and change it, as there is already GL transactions made prior to creation of Cash account. Highlighted in yellow is the wrong account entered. 

Hi Everyone,Good afternoon,I am having an issue regarding Sales Order Forms in Acumatica. It duplicates all the entries upon running the Sales Order Forms.Please see attached photo for your reference: Sales Order Screen :Upon Clicking of Print Sales Order : It duplicates the line item of the Sales Order Forms; Upon checking of Order Types Maintenance :Here’s the Result :But while searching on the screen of order types it gives me duplicate (Same Order Type) Maybe, this is the cause of the issue in sales order forms.May we ask on how to eliminate the duplicate order types even if it not available in Order Types Maintenance ? or Is there’s a way to correct the Sales Order Form in Report Designer? Thank you !!

I’m puzzled over this - hopefully it’s something silly that I’m missing.I have an Action button on SOOrderEntry.  The goal is to look through the detail lines on the order, create a record in another graph, update some fields on SOLine and save the order.Each time I call Actions.PressSave from within the CreateJobs method I get the error “The record cannot be saved.” I thought I was doing something wrong so I stripped out all of the code. I’ve tried it on two different Acumatica installations.public static bool IsActive(){ return true;}public PXAction<SOOrder> TestAction;[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Create Test", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = true)]protected virtual IEnumerable testAction(PXAdapter adapter){ Base.Actions.PressSave(); var graphCopy = Base; PXLongOperation.StartOperation(graphCopy, delegate () { CreateJobs(graphCopy); }); return adapter.Get();}private static void CreateJobs(

in the image under the internal tab there is nothing. For the other entities pages it works just fine but for shipments it doesn’t. Anyone know why this is and how I could fix it?

Here is the scenario I am trying to accomplish:When an AP invoice is released using the APRelease - ReleaseInvoice process, I want to check each line of the APTran table for the given invoice.  If the line item has an AllocationIDUsed code in the UsrAllocationIDUsed field, I want to delete that line and create new ones based on the setup of the custom allocation ID setup.The APTran table is not part of the signature of the ReleaseInvoice process so I don’t have access to it via a cache.My approach is to pass the “doc” into a function and do the allocation there.In order to make updates to the APTran table, I need a graph (I think).In my AllocateLine function, do I create a generic graph for each call to the function?  I am pretty sure I can accomplish my goal doing it that way, but I think I might have a performance issue if the invoice has 100 APTran lines and every one of them is allocated.  Yes...my customer releases HUNDREDS of AP Invoices every day and each invoice might have 50 t

Hello,I need to write a report (or GI) that allows me to report if there are more than 1 sales order in Acumatica with the same “Customer Order Nbr.”I have done similar things a million times in other report writers, but I do not know of a method to accomplish this with Acumatica’s report writer.So I need to run through the SO’s and report Acumatica sales orders and their associated “Customer Order Nbr”, but only if multiple sales orders have the same “Customer Order Nbr.”.  I’ve used functions like running totals that reset on the change of a field value etc… using other reporting tools, but I don’t know how to accomplish this here.Any great ideas on Friday afternoon in AcumaticaLand!!!???Thanks!!!!

Why does the RC function in sales orders have a create shipment button if it's just a credit?

1. Can Import By Scenario create Quick Checks and/or Bills?2. If so, can Import By Scenario import a file/picture for each QC or Bill?

Hi,We are going to have clients log into to Acumatica. In Report Inventory Valuation - IN615500 for sales team just wanna see their own stock without any information Total Cost of the items.Fyi, Report Inventory Valuation with total cost field will use to others user/user roles such as admin, purchase teams.Is it possible setting restriction total cost on these report by specific user/roles?Note : Client perhaps not any customization report for this implementation phase 1.