Solved

Hello,I am trying to put a negative quantity in a subcontract line item, but it errors out.Anyone have a work around for this that doesn’t require a debit adjustments.  I am trying to keep all the details on one invoice. We create the invoice for subcontractors and tie them off to each pay applications.  If we create multiple invoices it creates confusion. I found I can put a negative dollar value which makes the $ side work, but i don’t think it will work on the total qty side. Thanks,Jeremy  

Dear all,I am using Acumatica 24R2 and encountering an issue when creating an SO Invoice from a Shipment, as described below:I have a shipment with 2 lines (2 items) and would like to generate 2 SO Invoices from this shipment—one invoice containing 1 lines and the other containing 1 remain lines.However, whencreate the invoice, the system displays an error message: "Sales Order/Shipment cannot be invoiced partially."Could you please assist me in resolving this issue?Thank you very much for your help!   

When our company was moving into ACU supposedly we were told that Acumatica could use per-determined rules to disperse specific expenses into each of our branches.For example:Any marketing expenses will be dispersed via the followingBranch A 29%Branch B 30%Branch C 41%I could not find a way to do this so I am assuming I may need to do this manually?

What is the best way to record and track employee time off so that it not only flows through payroll but also onto the appointment/scheduling board?  Any options other than creating an appointment or work order and scheduling everyone through that?

 H Everyone.i setup a consolidation tenant to consolidate 5 tenants. I was able to synchronize with 4 tenants. The 5th one throws this error. This occurs when I try to synchronize this tenant LIST OF TENANTSERROR WHEN I SYNCHRONIZE  

Hello All, Anyone have the basics for an Import Scenario to do a mass update to the Cash Account on the Default Vendor Location Record they would mind sharing?  Thanks in Advance.

I’ve seen a few posts & blogs about this topic but still can’t seem to get the syntax correct.  I have a DAC extension table against the Customer DAC named “ZZCustomerExt”.  The Selector/Restrictor attributes for the custom fields work fine in a custom tab on the Customer screen.  I added the same field to an SOOrder DAC extension table (value copies but is changeable), but the syntax isn’t correct for my join.  How do I reference the Customer DAC extension table correctly in order to restrict by another field in that DAC extension (contractCode)?  [PXDBInt()] [PXUIField(DisplayName = "Commission Parent")] [PXSelector(typeof(Search2<Customer.bAccountID, InnerJoin<ZZCustomerExt, On<ZZCustomerExt.bAccountID, Equal<Customer.bAccountID>>>>), typeof(Customer.bAccountID), typeof(Customer.acctName), SubstituteKey = typeof(Customer.acctCD), DescriptionField = typeof(Customer.acctName))] [PXRestrictor(typeof(Where<Exists<

Hello - Is there a way get the Ext Price field on the AR Invoice screen to calculate to 4 decimals? So rather than rounding, it takes the exact value of Quantity x Unit Price? See below..  

Hi, We have a form that has an embedded image in it. I need to use this image on a different form. Is there a way to download this image. The image is a jpeg. I only see the ability to add a new image or delete an image. 

I am having one heck of a time configuring a clearing accounts to use them for bank deposits. I’m using the guide from here: https://fedcoseeds.acumatica.com/(W(29))/Help?CompanyID=Test+March+2nd&ScreenId=ShowWiki&pageid=323644f1-ea34-4377-92bc-c1fcb4a86d05 But I must be misunderstanding something. I created the clearing account: I did not put any entry types.I made sure the clearing account could be use in the Payment Methods  I created a test sales order, made a prepayment using the clearing accountI go to the bank deposit screen and enter the following:  But when I click “Add Payment” I cannot get the clearing account to appear as an option: I’m sure I’m just missing a small connecting piece.Thanks!

I’m trying to upload my customer information list and I keep getting an error in my import by scenario. I just want a way where Acumatica doesn’t pay attention to the way the postal code is written and have it upload the format that I have it as.This is just one example but I have many other countries as well

Hi Acumatica Community,With my customer master import scenario, my Canadian customer imports are failing as follows: Error: Field: Postal Code, Value: K1M 2C9, Error: The entered code doesn't match the required expression. My American customer imports work fine.On the countries screen, CS204000, I have this input mask and regular expression for the Canadians: -------------------------------------------------------mask: >L#L #L#Regular Expression: ^[A-Z]\d[A-Z]\s?\d[A-Z]\d$ Here is the help entry for Canadian Mask and regex:  Here is the help wiki for Masks, To Configure an Input Mask and a Display Mask for a Field-------------------------------------------------------FWIW, https://regex101.com/ tells me I have a match:   

I know more than the basics in Acumatica but this one I’m wondering if a) is this possible? and/or b) should it even be attempted?I need to create a generic inquiry that would show on hand qty for all configured items, with their configurations listed.Help?

I have a customer evaluating DRP, they use an outsourced manufacturer and own all of their inventory, The Manufacturer only provides the labor for the assembly to create the KITS.   The KITS are made to order using stock items. We were hoping that DRP would provide the demand for the KIT assembly based on Sales demand, not seeing that it does that.  Also based on the functionality the planning only works with either a value for safety stock or a value for reorder point.  Neither of these are actually based on SO demand.  It would work if they wanted to have these completed KITS on hand but they do not wish to have any on hand, all KITS are made to order based on SO demand. Has anyone had a similar use case?  

Zero Balances Report in Journal TransactionIs it possible in the GL listing to exclude accounts with zero balances when running the report?like put a parameter that will suppress zero balance

Hello Acumatica Developer Community,I'm currently working on implementing an integration with Acumatica and have a question about the best approach for handling multi-tenant authentication. Authentication ChallengeFor OAuth authentication, we need to store and manage client ID and client secret credentials. Since Acumatica supports multiple tenants, I'm wondering about the best practice for handling authentication in this context.For multi-tenant support, we need to determine if Acumatica requires separate client credentials per tenant: Does each tenant instance require unique client ID/secret pairs in Acumatica, or can a single set of credentials work across multiple tenant instances with the same base domain? Thank you!

I have added Terms to the AR Aging period sensitive report in Report Designer.  However, it is only pulling the Terms for customers that have only invoices and debit memos, not payments and credit memos.  I believe I need to pull the terms id from the Customer Master, but have not been successful with using the Add Schema fields to find how what needs to be linked to pull in the Customer Master Terms id.Does anyone have an example of how they have accomplished this?Thank you,Beth

HI All, As per best practices  and its Normal and Simple  Process   as per my Knowledge across during the years the following is the Transaction entries which will clear the Purchase Receipt and return Purchase receipt Inventory Account  Dr.Purchase Accrual Account Cr. Return Before Invoice / Bill Created Purchase Accrual Account Dr.Inventory Account  CrBy this  both the account get cleared  and reconciled as well. if its Partial return Yes the balance remain  and  which can be cleared by Bill as its not retuned  As per the Functionality of Acumatica we need to create a AP Bill and a Debit adjustment for any return ?? though both PR and return has been Processed both Transaction remain uncleared in the accrual Account why this is required  and the logic behind this Functionality ?   

Hi Everyone,I have recentlyt taken over as the Finance Manager of an organisation that uses Myob Advanced. Unfortunately, the organisation has undergone a massive downsizing and MYOB Advanced’s functionalities are not needed and to be honest cannot be justified from a cost perspective.I’d appreciate any advice on how to move from MYOB Advanced to MYOB Accountright. Thanks

I’ve found 35 topics tagged with ‘Import and Export Scenarios’ that have the word attribute in them, but haven’t found one that lets you import an actual attribute, not a attribute value on another screen.  Is this possible?  This does not work for me, but I’m not sure why.The attribute’s ID is ‘LOCAL’.  It is of type text.The data looks like this with fake values for demonstration:AttributeID     Value     ValueIDLOCAL           cat          1LOCAL           dog         2LOCAL           mouse    3 Any help or examples would be appreciated.Thank you!

I am trying to replace the Owner ID in a generic Inquiry into the project managers Initials.  I created the formula below: =IIf([PMProject.ownerID]='Joel Darby','JD',(IIf([PMProject.ownerID]='Daniel Bandanza','DZ',(IIf([PMProject.ownerID]='Michael McLaughlin','MM',(IIF([PMProject.ownerID]='David Dunn','DD',(IIf([PMProject.ownerID]='Josh Lavallee','JL',(IIf([PMProject.ownerID]='Daniel Mahr','DM',null)))))))))))I am getting the Error message Conversion failed when converting the varchar value 'Joel Darby' to data type int. when using PMProject.OwnerID in a generic Inquiry formula.  When I just pull the data field It shows up as the full name but the DAC is telling me it’s type int which I am assuming is why I am getting the error message so is it maybe pulling the PKID?  I can’t find anywhere else where I can pull that info as varchar.

My team is looking to see Released Date AND Time, currently, I can only see it doing one or the other and I am not sure how to add the same column a second time for the second option, or to configure the field to be a DateTime field.  True = Time, False/Blank = Date. I have not done much with custom projects, but I figured this would have been an easier modification I could do for them.

Hi everyone, Can someone pass me a code snippet on how to get data from a specified generic inquiry programmatically? (i.e. SELECT * FROM MyGI and return the data rows that I can then manipulate) If you happen to know how to select a GI respecting a shared filter as well, that would be extremely helpful as well.  Thank you-Kyle

I have the setting in Sales Order Preferences called ‘Add Zero Lines for Items Not in Stock’ checked, as well as ‘Create Zero Shipments’:When I create a Sales Order with ‘Back Order Allowed’ checked, and each line also has ‘Back Order Allowed’ as the Shipping Rule, I can get a 0 line on the shipment:However, if the line has ‘Mark for PO’ checked and/or has a linked PO, it is not offered for the shipment:The same occurs if it has ‘Mark for Production’ checked. It doesn’t make sense to me that this option would not work when products are coming from other places than stock. Am I misunderstanding how this option is supposed to work? Has anyone else seen this behavior?Thank you for reading. 

Hello Community,I am building a custom processing screen in Acumatica and facing an issue where the processing dialog (popup) is not showing when I click "Process" or "Process All."Can someone help me figure out what I’m missing? Below is the code I am using. public class BusinessAccountMaintTSExt : PXGraph<BusinessAccountMaintTSExt> { // Use PXFilter for ProcessFilter public PXFilter<ProcessFilter> Filter; public PXProcessingJoin<BAccount, LeftJoin<Customer, On<Customer.bAccountID, Equal<BAccount.bAccountID>>>, Where<Customer.bAccountID, IsNull, And<BAccount.type, NotEqual<BAccountType.customerType>, And<BAccount.type, NotEqual<BAccountType.vendorType>, And<BAccount.type, NotEqual<BAccountType.employeeType>, And<BAccount.type, NotEqual<BAccountType.combinedType>, And<BAccount.type