Solved

Hello Acumatica community! :)Prior to Acumatica, we used Timberscan with Sage300 and could report out of Timberscan with various parameters to get a summary of invoices with all relevant attachments as one file - a pdf.  I have a need to do this in Acumatica and cannot figure out how.  Do any of you have suggestions? Thanks for you time.Kay HoweJackson, OH   

Hi everyone, One of our clients upgraded within our implementation process to 2022R2.They will be a heavy user of the Manufacturing suite.We imported some sample Bill of Materials for Training purposes and realized that the Order on the Visual BOM follows some other logic than the Engineering Workbench. The Engineering Workbench shows the 1:1 replica of the BOM in terms of Operations and Materials.The Visual BOM seems to take the BOM ID from the nested BOM into consideration. It mixes the order of Materials up completely. Is anybody aware of the Logic behind it?The User is trained to consider the order of Materials when creating the BOM. It is easy to change through the Engineering Workbench, but once again the Visual BOM seems to have a different Ordering Sequence for that.Did anybody experience similar things before or knows why the two screens use different Ordering sequences? Thank you!

We are trying to find a report that breaks out the Labor and Overhead from our unit cost in the lower level of our BOMs. This is something we had in our previous system and was used for multiple entries and analysis in Finance. Here is Acumatica’s version. There is columns for Material, Labor and Overhead. Is there a way to show these on the lower levels of the BOMs.  Here is the report from our old system where is breaks out the labor and overhead for lower level assemblies. Thank you 

Hello everyone! I have a custom field on Shipments Screen telling me the status of the order in a different system, the code is given below:declaring UsrRWSStatusthe shipments screen for a visual representationNow I have a service which will update its status to Pick Created , with the following request:POSTMAN PUT requestBut I get this error in response,"String or binary data would be truncated in table 'AcumaticaDB.dbo.SOShipment', column 'UsrRWSStatus'. Truncated value: 'P'.\r\nThe statement has been terminated.", this as the exception message, I am confused here, am I sending the request correctly, or do I have to change something else in my customization of the DAC? If any more context is required please let me know. Cheers,Jdeol

Hi, I have developed a new screen, In this screen I need to load all the locations of related customer as drop down list in the location filed to allow select and add to the field.To accomplish this, I used PXSelector attribute like below in the DAC but it is not working as expected.  #region LocationID        [PXDBString(30, IsUnicode = true, InputMask = "")]        [PXUIField(DisplayName = "Location",Enabled =false)]        //[PXSelector(typeof(Search<Location.descr, Where<Location.bAccountID, Equal<Current<APProforma.customerID>>>>))]        [PXSelector(typeof(Search2<Location.descr,InnerJoin<Customer,On<Location.locationCD, Equal<Customer.defLocationID>>>>))]        public virtual string LocationID { get; set; }    public abstract class locationID : PX.Data.BQL.BqlString.Field<locationID> { }    #endregion Can someone help me on this?thank you. 

Hello Everyone, On appointments screen, the system picks location of when the user using the mobile device logged in the system instead of the exact location and time when the appointment was started. The system always picks the first location recorded on the location Tracking history GI as shown below. The system should not be picking the location of the first time the user logged in the system. what could be causing this issue, why does it pick the first row always for the start and End location.Kindly assist.Any kind of response will be highly appreciated.

Hello,    Recently, our users typed qty=0 lines on invoice (which should have qty). So we less charged our customers due to human error.     I know we can probably put codes like below in customization to prevent this mistake.cache.RaiseExceptionHandling<ARTran.baseQty>(aRTran, aRTran.BaseQty, new PXSetPropertyException("Qty can not be 0.", PXErrorLevel.Error));    I am just wondering if there is a way to prevent qty=0 line on Invoice entry without coding.

Hello Community,In the Bill of Material screen, I have created a new tab i.e. TEST same as the OUTSIDE PROCESS. OUTSIDE PROCESS form is refreshing according to the selection of the record in the Operations grid but my TEST tab not refreshing.Tried belowCreated Tab same OUTSIDE PROCESS tab (Native Acumatica tab) Added AutoCallBack commands  Refreshed the grid in the RowSelecting event as well but not working.Any suggestions, highly appreciated.  

Hi,When we do group consolidation, can we perform unrealized profit eliminations, goods in transit entries, and intercompany eliminations in Acumatica?Thanks,Dulanjana 

Hi all,I have already  added  parameter filter date but it does not work. I filter the creation date of that GL based on field Batch.CreateDateTime as below.Pls advise me if I misunderstand sth.Thanks in advanced.

Hi,     I am using Visual Studio 2019 for all my customization development. After upgrading to 22 r2 I am facing issues in creating a new custom page or opening the existing page in design mode. I am using the template provided by Acumatica 22 R1It throws the following error  Pls, let me know how to fix it.Regards,R.Muralidharan

Hi Team,I just want to ask if there is a control or set up for the minutes of automatic logout in Acumatica when it is not used? or should you give me an article about the behavior of the system regarding the automatica log out even the acumatica is still in used.? Thank you!

I’m trying to set up a BOM with two subcontract operations for different vendors. I’ve created separate non-stock subcon items with the relevant vendor and added the two operations to the BOM. Each operation has the non-stock item on the material line. I’ve added two Work Centres with Outside Process checked.Material type=Subcon, Subcon Source=PurchasingMy problem is that when i go to the Outside processing tab, I can select the Vendor for Operation 1, but this also defines the same Vendor for Operation 2. If I amend Operation 2, it then changes Operation 1.Not sure if I’ve set up incorrectly or if there’s some restriction on selecting multiple subcontract vendors on a BOM. If the latter is the case I could try using a phantom sub-assembly.

We are using Item Replenishment now.  And it works great.  We want to add Item CLASS replenishment.  We need help with understanding how Item CLASS replenishment works.  For example,(1)  in the Item CLASS settings tab, we do not see any MIN / MAX settings.  Where are these MIN / MAX setting set? (2) how does Acumatica know which item in the Item CLASS to reorder?  Does the system look to the ITEM replenishment to get the MIN / MAX amount to create the Item CLASS replenishment?  Thank you fo your help. 

How do I set one of my companies as a default? I don’t like toggling every time I log in.

Is it possible to pull existing customer profile IDs from Authorize.net into Acumatica? We have a large database of customer information already held on Authorize.net that we'd like to import into Acumatica, and we'd like to retain their existing profile IDs for continuity. Has anyone else done this before, and if so, what steps did you take to ensure a smooth transition?

#region UsrAccount[Account(DisplayName = "Account", BqlField = typeof(INTranExt.usrAccount), Visibility = PXUIVisibility.Visible, Filterable = false, DescriptionField = typeof(Account.description), Required = false, AvoidControlAccounts = true)]public virtual int? UsrAccount { get; set; }public abstract class usrAccount : PX.Data.BQL.BqlInt.Field<usrAccount> { }#endregionI have created a custom field with Account attribute.Account attribute has this default warning in place. I have added FieldVerifying on the my custom field. But this warning seems to override my error message. How can I show my error over this default warning I am not able to figure this out.Can anyone share some suggestions.Thanks.

Hi everyone, I am very new to Acumatica. I am trying to do the import scenario (Quick Check), does anyone know what’s the error?  Category Trace Message Error: 8 items have not been processed successfully. View name: Document. Stack Trace at PX.Api.SyMappingUtils.ImportData(SYProcess graph, SYMappingActive mapping, SYImportOperation operation, SYMappingActive updated) at PX.Api.SyMappingUtils.ProcessMapping(SYProcess graph, SYMappingActive mapping, SYImportOperation operation) at PX.Api.SYImportProcessSingle.<>c__DisplayClass67_0.<PerformOperation>b__0() at PX.Concurrency.CancellationIgnorantExtensions.RunWithCancellationViaThreadAbort(Action method, CancellationToken cancellationToken) at PX.Concurrency.CancellationIgnorantExtensions.<>c__DisplayClass1_0.<ToCancellationViaThreadAbort>b__0(CancellationToken cancellationToken) at PX.Concurrency.Internal.PXLongOperationPars.PopAndRunDelegate(CancellationToken cancellation

When will the new integration, announced with 2020 R2, be available?If it already is, where do we find related documentation?

Hi,I’m new to acumatica. I customized a new screen with formtab template. Inside my tab I customized a grid. This time I want to add  “Add order” button which is used to pop-up a new window (smart Panel) including all the purchase orders which are available in the POOrder DAC and select and insert into the grid when click on each order. below screenshots for the reference. the gridI have created the smart panel so far. But I need to add the values of smart panel into the grid. Can someone suggest me the way to do this or provide me any guidence resource.thank You.

Hi,I’m new to acumatica. I have a customized screen. There is a button with an action which opens a pop-up window. In this pop-up window I have loaded data from both POOrder DAC and POLine DAC. To load data , I created a view using SelectFrom attribute .But when I try to add data from the pop-up window to the grid of my customized form, I’m getting below error. 'Unable to cast object of type 'PX.Objects.PO.POOrder' to type 'PX.Data.PXResult`2[PX.Objects.PO.POOrder,PX.Objects.PO.POLine]'. Can someone help me to solve this issue please?Thank you.see the below code for reference.namespace GRIProformaInvoice.Extension{ public class APProformaEntry_Extension : PXGraphExtension<APProformaEntry> { public SelectFrom<POOrder>.InnerJoin<POLine>. On<POLine.orderNbr.IsEqual<POOrder.orderNbr>>.View POrdersView; public PXAction<APProforma> MyAction; [PXUIField(DisplayName = "Add Purchase", MapEnableRights = PXCacheRights.Selec

Hi, I have a newly created screen including a form and grid. I have modified a button to pop-up a window which consists data of POOrder and POLine tables. To load data from these two tables, I have defined a view like below.public SelectFrom<POLine>          .InnerJoin<POOrder>.On<POLine.orderNbr.IsEqual<POOrder.orderNbr>            .And<POLine.orderType.IsEqual<POOrder.orderType>>>          .View POrdersView;I want to add some values from this smart panel to my custom grid in the screen. After adding the values to the grid, when I try to save to the database, I’m getting below error. There is no field called ‘OrderDate’ in my DAC for the grid, but both POOrder and POline have ‘OrderDate’. Even I don’t try to update records in these two tables, How can I get this error? Does someone have an idea on how to solve this?thank you

Hi,I’m customizing a new screen, In my screen I have a grid with some fields taken from my customized DAC. I modified some fields with Enabled=false property because I don’t need to allow edit those fields from the UI. below example for the reference.#region Ponbr        [PXDBString(15, IsUnicode = true, InputMask = "")]        [PXUIField(DisplayName = "Sales Order Number", Enabled = false)]                public virtual string Ponbr { get; set; }        public abstract class ponbr : PX.Data.BQL.BqlString.Field<ponbr> { }        #endregion        #region POLineNbr        [PXDBInt()]    [PXUIField(DisplayName = "Sales Order Line Number", Enabled = false)]    public virtual int? POLineNbr { get; set; }    public abstract class pOLineNbr : PX.Data.BQL.BqlInt.Field<pOLineNbr> { }    #endregion But after adding them, I’m unable to change the width of these columns in the grid as required. Before modifying them , I had changed the width property in layout properties of these fiel

I am trying to build a GI using the INItemSite table to display the InventoryID and the MinQty designated for each warehouse. I’m trying to use the following formula to limit to the MinQty from a specific warehouse and will duplicate several times for each warehouse (grouping the results by InventoryID):=IIf([INItemSite.SiteID]='Warehouse-01',[INItemSite.MinQty],0)However, when I try to view the results I receive the following error message:Conversion failed when converting the varchar value 'Warehouse-01' to data type int. Anyone have any suggestions around this? I would imagine this error means the INItemSite.SiteID field does not actually contain the text data but is actually a numeric value assigned to that SiteID, but I can’t figure out how to fix this GI. Seems fairly straightforward.

Hello,I am trying to update 8000 stock item’s posting class and item class.I am getting this error message. Please confirm if you want to update current Item settings with the Inventory Class defaults. Original settings will be preserved otherwise.Based on the error message I think I need to add an action after the inventory ID.Screen shot of <Actions: >