Solved

Hi! I’m dealing with a requirement that needs some User Defined Fields to appear based o the value of another User Defined Field. The use case is as follows:In an opportunity, my customer must gather a set of documents, but this documents vary depending on if their customer is a person or a company. We’ve created a User Defined Fields (Customer Type) combo selector to chose between the customer being a person or a company. We’ve created the document list checkbox using user defined fields, but it would be great to be able to hide the ones that are not being used, depending on the value of the customer type.It would be great to be able to do it from a Low-Code/No-Code project.Thank you for your support. 

After the 24R2 upgrade, the billing postal code value cannot be entered in the Carrier Account section of the Customer screen for the "Billing Type: Receiver." However, this was possible in version 24R1.I am unable to find any changes in the Release notes, is it a bug?  

Hello Guys Can you help me with these issuesuddenly had rounding diff. the first picture is correct but the 2nd picture had rounding diff.     Thank you 

Hi, I would like to make the greeting in the email template for a sales order gender specific. Depending on the title it should be Mr oder Mrs for example. I tried to use it Document.ContactID.Title with if and then logic but somehow I failed.Has anybody done this before or an idea how the HTML code should like?Acutally I am not sure if Acumatica understands if and then in the HTML code for templates. Lars 

We are new to Acumatica and trying to wrap our heads around how branches and subaccounts work. Our use case is this:One company, one warehouse with inventory. We sell B2B, B2C - Shopify, B2C - Amazon. We would like the ability to run a P&L based on sales channel and by product line. For example: P&L for B2B channel for product line X. From what I understand, only one subaccount can be used per line so we would have to choose whether we want to classify the line as a channel or a product line. I think if we create combined subaccounts, where channel and product line are combined, it would create major difficulty in data entry, along with preventing us from running a P&L based on just product line or just channel. Would adding a branch for each sales channel make sense? Then each transaction would have a branch and then a subaccount for the product line? Again, we would only have 1 warehouse shared across the company, so I’m not sure if this method would work. Happy to hear s

Can anyone share how they get a zero dollar pro forma invoice on a project if it has an on demand billing period? And how you create your AIA invoice showing all retainage released on invoices? Thank you!! 

Hello - is there a way to prevent employees from being able to edit their time entries (by putting them back on hold) after they have been approved? We have employees who use time cards and time activities and would want to prevent this under both options. 

I was in the process of reconciling a Credit Card and the Reference Number generated matched, for some reason, a previous reconciliation statement for a different cash account.Now the process is locked into a cash account that is not correct, it will not let me delete the report, and if I create a new one it tells me that the previous statement was not reconciled. Also, the transactions disappeared for that time frame and I have tried everything to get rid of the incorrect reference number. Please help!

With regards to this topic top-selling-items-in-a-generic-inquiry-27114.We have followed this reply: SoLine TableSo far so good, except we would like to accurately display the quantity based on a given time period (specifically for the past year to date). If we just add OrderDate as a column it doesn’t display the correct quantity for that time period when filtered.What is the best way to accurately display the quantity for a certain time period (instead of just all time quantity totals)? 

Good day Community I have a client who has been calculating their depreciation on a spreadsheet for years and now want to use Acumatica. Here is my challenge - in 2021 they changed the useful life of the assets from 25 to 40 years. In 2023 they increased the value of the assets. I imported the assets in the current financial year in initialization mode, including the YTD Accumulated Depreciation. Most assets have been depreciating for about 5 years, 2 years @ 25 years and 3 @ 40 years. I am really struggling to assign them useful life years that would calculate at the correct rate.  If I use 40 years, it reverses a portion of the Accum. Depr so that the remaining amount is over 40 years from day 1. If I use 35 years and amend the start date to the current year, the calculation is correct by month going forward, but it amends the Accumulated Depreciation YTD that was imported.Any advice as to how I could get the system to calculate the correct amount going forward without changing the t

Hello, We’ve noticed when processing offline Shopify orders with cash that the log in Shopify shows the amount of cash paid and then the change given to the customer. When this order syncs into Acumatica, the payment total is the amount of cash the customer gave and doesn’t account for the change, leaving a balance on the payment. Is this a known bug, and is there a fix or workaround for this?   

We need some clarification for Minimum Order Quantity and EOQ (we think this mean Economic Order Quantity).  We think Minimum Order Quantity for an Item / SKU is the minimum amount that must be ordered to order the Item / SKU from the supplier.  So, if I have a Max Replenishment of 20, and a reorder point of 10, (and I have 10 instock) and a Minimum Order Quantity of 50, when I run replenisment the amount to order will not be 10 (20 - 10 = 10) but will be 40 (50 - 10 = 40).  Is this correct?   How does EOQ figure into this math?  I do not know what EOQ does.  Any help is greatly appreciated. Thank you

I just learned that shopify for some reason does not support multi select dropdown out of the box.I’m interested in using the commerce connector to map Text, Combo and Multi Select Combo product attributes to Shopify metafields.I was recommended https://apps.shopify.com/metafields-editor-2. The Metafield Guru supposedly supports multi-select metafields.Does anyone recommendations/experience for syncing single and multi select stock item attributes in acumatica with shopify using the commerce connector?

Hello - is it possible to change the default set up of the time card screen to default to the Details tab instead of the summary tab?  

Has anyone run into issues with serial lot numbers that contain an underscore in 2024 R2? When creating an inventory adjustment, the lot that has the underscore can be selected but as soon as any field (e.g. quantity) is updated the underscore is replaced by a space and the transaction cannot be saved. For new receipts we will use a dash instead of underscore, but it’s causing problems with existing inventory. We have a support case open with Acumatica but would appreciate advice from anyone who may have already seen this issue.Thanks in advance!

Hello,Our company has been using Acumatica for three months after transitioning from Sage 100. I'm reaching out to see if anyone has experience with AP automation for both standard purchase orders (POs) and dropship POs. We handle a large volume of both types, and the majority of our AP bills are generated from POs.For those using AP automation with standard POs, how do you manage the delay between receiving the AP bill and the PO receipt?Similarly, for AP automation with dropship POs, we usually create the PO receipt upon receiving the AP bill and then invoice the customer immediately afterward. How do you manage this process?Our AP department does not feel AP Automation is helping as we hoped . . . Any insights from the group would be greatly appreciated!Thank you,Andrew Paquette

Hello Everyone,I am trying to make a  customer contact as primary through API call. But it is working for the first entered contact. Unable to set another contact. Could you please review and share your feedback?  

I set the inventoryid to required on the inventory screen. I want to still get the error message of “inventoryid cannot be found” if someone does fill in the incorrect inventory id.So basically if the inventory id is blank I should get this error: “inventory id is required.If inventory id is entered but does not exist in the system: “Iventoryid does not exist” Before making the inventoryid required, the “Iventoryid does not exist” error came through when trying to save. Now it is overiiden by the “inventoryid cannot be found”. I don't want this to happenPS I used PXDefault attribute to make the field required

Top Selling Items In a Generic Inquiry? Looking for your suggestions

hello, i want  make the filed  decimal places like thisi used the Floor() formula it rounded up to a whole ing. i used the Math.Round() and Round () formula and its still give me the same issue this is the function i have in my data fieldIIF([ARInvoice.DocType]='CRM', [ARTran.ExtPrice]*-1,  [ARTran.ExtPrice]) 

Can you increase the segment value of the Posting Class like you can for Item Classes

Client wants to require that a copy of the AP Bill is attached before allowing payment to be processed.  What would be the best way to accomplish this?

Hi! When I use an employee user in the customer portal, I am not able to view the item details, catalog, or checkout screens without associating the user with a business account. Do all users (even employees) need to be associated with a business account to view this in the portal? These users have the portal admin and system administrator user roles assigned.The user also doesn’t have access to view Sales Order or invoice printed form even given access and has report designer role. I couldn’t find any documentation that specifies this, is there a configuration I missed?Thanks!

All,I would like the GIs to come over in descending order as the GI does.  Is this a customization? Thanks,Melissa

Can you provide basic step how to acumatica integrate with magento 2.