Solved

Is it possible to configure Acumatica lot/serial classes to track both lot and serial number on an item? 

Need to filter out vendor codes from BAccount DAC. Now it is loading all the BAccounts.#region VendorID               [PXUIField(DisplayName = "Vendor", Required = true)]        [PXDBDefault(typeof(BAccount.bAccountID))]        [PXSelector(typeof(Search<BAccount.bAccountID>),                    typeof(BAccount.acctCD),                    typeof(BAccount.acctName),        SubstituteKey = typeof(BAccount.acctCD),        DescriptionField = typeof(BAccount.acctName))]        public virtual int? BAccountID { get; set; }        public abstract class bAccountID : PX.Data.BQL.BqlInt.Field<bAccountID> { }        #endregion

I am getting a syntax error with this formula and can’t quite figure it out.=IIF ((DateDiff(interval, [ARInvoice.DueDate], Today()) >=30 and (DateDiff(interval, [ARInvoice.DueDate], Today())<60, [ARInvoice.CuryDocBal],0)I am trying to create columns of data depending on the “aging” of the invoice balance in a GI so that we can export to Excel for submission to our Auditors.  The value should either be zero or the invoice balance.I have this similar formula that works fine for current invoices:  =IIF ([ARInvoice.DueDate] >= Today(),[ARInvoice.CuryDocBal],0) Thanks!

When processing non stock item the following error has occured Error:String was not recognized as a valid DateTim 

Hi Guys ‘I am not able to create a data view of extension DAC in Extension Graph  public PXSelect<SSSLocationExt> Locationtest;Getting this error  CS0311 Thanks

When I release purchase receipt with auto create bill check box, the discount amount in purchase and bill display difference value where currency not USD  

Hi Acumatica,Just want to ask on how to add the values in Posting Class > Combine Inventory/Accrual Sub-Account From: Thank you!

Hi everyone. I would like to know your opinion regarding the availability calculation rule and the pros and cons of unselecting the “Deduct Qty.” checkboxes. Thank you in advance.

Hi All, Is it possible to have a unique Default Order Type based on which branch or company you are logged into? We have 2 separate companies in our instance. Company A uses Quotes, or QT order type, for 99% of their orders. Meanwhile, Company B uses Sales Orders with Allocation, or SA order type, for a majority of their orders. Changing the sales default sales order setting affects the default for both companies: Is there a unique setting per company or branch that can be used to configure this instead?

We are trying to set up our Authorize.net sandbox account as a processing center on our Acumatica sandbox tenant, however we’re getting the below error message. I created a brand new Signature Key and Transaction Key and still when I try to test credentials I get this error.Any ideas how to get around this? I’ve played around with TESTMODE and VALIDATION parameters and that hasn’t helped. 

Simple question, can you prevent deletion/cancellation of a Sales Order if it is linked to a Production Order?  Can it be based on the status of the RO (released, started, completed)?  I have found this is a recent feature for linked POs, but am wondering why it wasn’t implemented for ROs as well, or if I am just missing something. 

Hello everyone, I’ve been wondering whether there is a way to retrieve documents through the API. Apparently there is no obvious way within the Default endpoint.For context: I am trying to listen to document creations to send a Push Notification to our service so I can download the document created.Thanks in advance!

Hello,I have a new development instance of Acumatica. On an old instance (that I deleted to prepare for an upgrade), I had a Visual Studio solution for an extension library. Now I need to edit code in the customization. I copied the solution to the location that it was in on the old instance( AcumaticaERP\Instance Name\App_Data\Projects\). However, when I build the solution it does not change anything and I do not get the “Files have been modified” message when I try to publish.Does anyone know what the problem is? Do I have to change a file on the server?Please advise.

Has anybody else integrated Acumatica with Paymode-X. I know that there are others doing electronic AP payments with Acumatica but we are looking to use a specific vendor. (AvidXchange) was one listed.https://sourceforge.net/software/compare/AvidXchange-vs-Bottomline-Paymode-X/ I see that Paymode-X does integration with a few other ERPs.  Sage, NetSuite but says it has a open API intergration with any ERP. Just wanted to see if others have used it and solicit and feedback.  

I’m looking for thoughts on how to handle the following scenario:We have components that we manufacture inhouse, but also outsource.  In house, we do standard production orders against a BOM, which generates our standard cost. But, we also outsource these items.  Currently, we outsource these components 95% of the time.  Because we have BOM for these parts, out standard cost generates whenever we Cost Roll our BOM, but I really need our cost to reflect the PO cost of these items, or a avg of the 2, since we are 95% outsourced.  I’d prefer to keep the BOM active for our flexibility.

Hi all,I need salespeople to Approve their order after viewing the printed report version.  Is it possible to pass an Action via URL so I could create an “Approve” link in the report, much like you can do with a Parameter?Much appreciated!

We are in the process of converting from Macola/Synergy to Acumatica. All of our box labels and item UPC code labels have been done with Nice Labels using Zebra printers. Is there a more efficient way of converting the Nice Labels to a format that Acumatica can use or will we have to design them similar to the way Acumatica report is done, RBAR (Row by Agonizing Row). I know that there are companies out there can can convert the Nice Labels to Acumatica format such as ASGARD), but if possible, we would like to do it inhouse.

Need to know how to add Current Date as default value to [PXDefault()]?

Good dayI have a customization that I am working on in Acumatica and was wondering if anyone might help me or cab just to tell me if something like this is possibleOn the employee timecard screen I am trying to add a label in a row just beneath the days to so that day's current date. Can be a label or any field but just to display the date of the current day that they are entering.And then with that I would like to add at the bottom either as a column or a label to display the total of hours that has been added to the specific day as the user enters them.Does any of that sound possible?Please see my screen shot  

Hi I need help to to do customization on this specific screen but seems that there is error when I try to access it Screen: SP402000 

Hi all, I just wrote a row style -- =Iif ([SOOrder.CustomerRefNbr] = 'PRO FORMA' and [SOOrder.Status] = 'R','red20', 'default') If it’s a PRO FORMA on CREDIT HOLD, highlight the row red. So far so good. I would like to modify this so it’s only on credit hold pro formas that are greater than a week old. So I did something like this:=Iif ([SOOrder.CustomerRefNbr] = 'PRO FORMA' and [SOOrder.Status] = 'R' and [SOOrder.OrderDate]< @Today -7,'red20', 'default') That unfortunately gives an error. Is there a way to do dates in expressions? I see the DateDiff function but I have no idea how to work the syntax on that. Thanks!

Hi,As said in the title, How to do IF string contain Substring?Example here : IF [ARInvoice.CustomerID_Customer_acctName] CONTAINS ‘IGA’ I saw in the help that we have this operator :HELP ‘IN’ operatorI tried it in a GI :I think it’s done the good way but i got an error : Syntax error: The items following the IN keyword must be separated by commas and be enclosed in parentheses.Is it me or the help have mistake?Thanks

Title says it. Just wondering if anyone in construction who has used Acumatica is willing to chat with me in the next couple of days about your company’s experience. Thank you!

Each month we do an allocation entry where we allocate all of the expenses in our corporate branch to our other branches based off a fixed weighting. The problem is, rather than all of the accounts in our corporate branch being $0 after the allocation, we want the total to be posted to an offset/contra account that would making the overall balance in the corporate branch be $0.Ideally it would look something like this: 

Hi Experts,Is it possible to change the header labels at the grid level?I would like to modify the Employee Timecard screen to include a label or field just below each day of the week to display the current date for that day. Is this achievable?Employee Time CardThank you in advance!Regards,Sagar