Discussion Forums

Hello Everyone,We have one of our client working with 24R2 (24.212.0010) Shopify Connector and observed a discrepancy during Refund sync due to that the behavior is not consistent across RC orders created manually and synced through connector and this is specific for a serialized product associated with Lot/Serial number. Can you please review the scenario and help us with root cause identification and possible fix.Acumatica RC Order Reflection for a Serialized Product:• Created receipt with serial nbr 101. • Created order and selected serial. • Created & confirmed Shipment and released Invoice.• Created RC, selected this Invoice, Line Details pop-up updated with that serial. • Create Receipt, Confirm Shipment, and Released Invoice.Acumatica Connector RC Order Reflection for a Serialized Product is Not same as of Manual RC creation:• Created receipt with serial nbr 102.  • Created order in Shopify and synced to Acumatica. • Created shipment but on confirm Shipment got error for ser

Hi,We upgraded to Acumatica Cloud ERP 2022 R2 Build 22.212.0046, and since  then we are getting this error every now and then. Our users are getting tired of this already.Any one experiencing the same issue? 

I’m currently testing the ability to find out what lot codes of consumables (like glue, RTV, fujipoly) or serialized parts were used in a serialized product. When I use the As Built Configuration and type in the serial number of the product, I am only shown the details of the parent production order. I’ve set the “Levels to Display” to a higher number than 1, which should have expanded the view to include child production orders, but nothing changed. My company is currently on version 25R1. Would appreciate any assistance getting the As Built Configurator working! Thanks!

How can I customize the system to not allow a user to change the Branch if certain conditions are met?

Hello, Acumatica Team.I want to highlight an issue that I'm facing on Screen IN303000, Adjustments. I have imported an excel file of list of items that require adjustments.I have observed two issues that I'm facing - 1. When I Import list of inventory products on Adjustments screen, new random 15 - 20 entries with quantity zero are added which are not in the sheet.2. When I delete those items and then save the items already there; when I click 'Save', new random 15 - 20 entries are again added. Is this issue only on my side or is it prevalent across all acumatica users. Furthermore, this issue is observed in another user with Inventory Managment rights as well. This issue is preventing me from Releasing the Adjustments. Can anyone please help me with this issue?​@Chris Hackett 

Sorry if this is a dupe. I'm sure it's come up before, but I wanted to see if anyone has actually got it working lately. I’ve seen a few posts, but they are older versions and I haven’t found any with it actually implemented, just general ideas.Basically, when we email an invoice using an email template, we'd also like the files attached to that invoice record to go out with it.If you've got it running, I'd love to hear how you did it and roughly which version you're on.Thanks in advance!

Do my best to explain the issue. See bullet points below.Have project with more than three invoice milestones (main reason for using project is that these are change orders which we want to see the profitability on) Have to manufacture finished good which will not realize revenue for until shipped through sales order (unless there is another way to do this inside project) Need to automatically debit unearned revenue once finished goods shippedI think the difficult part is that I have a project which I’m invoicing out of, dr. a/r and cr. unearned revenue is what sounds correct at that point. But not sure how to make it auto realize revenue and dr. unearned revenue once finished good is shipped. Any thoughts on how to do that or if you have a better way given the milestones, I’d appreciate input. 

Hello, Has anyone had issues with this? Acumatica is not importing all types of transactions from the BAI2 file. Specifically transactions coded to 495 but we are now going through and double checking to see if there are others.

Looking for ways to import from acumatica the template id media url and the matrix item medial url.  The idea is that if one of the matrix items is not available to sell in shopify then Acumatica will mark that variant as not sellable and shopify does not show that specific image of that matrix item in the shopify listing page.   Any suggestions? Thanks!

What is the FSSODet.SiteLocationID default logic? Can this only default from the Inventory Item or can there be a customer or warehouse default?When I add an Inventory Item to a Service Order the warehouse populated from Branch Location Default (i think) FSBranchLocation.DftSiteID but the SiteLocationID never defaults.This isnt an issue for manual entry of Service Orders, I can just set the value. Adding stock items to Service Contracts...im running into issues generating the schedule.Any guidance would be appreciated!

Does anyone know why the Cost Code is not defaulting when I assign Staff Members in Appointments, even though I'm using the Default Cost Code on the Default Project Task?This is preventing us from using the Calendar Board to have our scheduler assign technicians to unassigned appointment while scheduling. We receive the following error…“Error: 'Cost Code' cannot be empty. Please specify the default cost code for the related service order type.” 

Consider the following scenario that based on my understanding will work as described.  EMail comes into an Outlook Inbox.  From this message the user uses the Acumatica Outlook Add-In to CREATE CASE.  The case is created and the email is listed in the ACTIVITIES of the case.  From this point forward for the case, the user wants to handle all communication from inside the case.  If the user replies to the initial email from within the case screen ACTIVITIES, that email reply does not get tagged with the [Case ########]?  If the person who gets that email replies, even though we have Incoming EMail Processing turned on for that email account, since there is no tag of [Case #######] in the subject, it will not automatically get linked to that case?  Am I understanding this correctly?  If so, how do others handle this?  Do you just manually add [Case #######] to the initial reply so that all future emails in this chain are processed and linked correctly?  Did you create a customization to

We are consistently being reached for declarations and certifications for our products mostly via third party platforms on all regulatory compliance: Prop65, RoHS, REACH, Conflict Minerals, PFAS, POPs, and TSCA. When my searches for Acumatica - Manufacturing capabilities aren’t yielding Construction and Financial compliance I’ve been directed towards the Certifications tab under an inventory item, or directed towards the Quality Management.Looking to further explore the management Acumatica provides and am curious how others may be managing suppler declarations for components and raw material in Acumatica. 

I am currently encountering a specific case regarding the Purchase Price Variance (PPV) logic on the system and would appreciate your insights on it.Here is the exact sequence of documents: Purchase Order: Unit Cost = Y Purchase Receipt 1: Unit Cost = X Purchase Receipt 2: Unit Cost = Y AP Bill: Unit Cost = Y (applied to Purchase Receipt 1) When I Save the Bill, Estimated PPV Amount = 0, I Release the Bill, the system automatically generates and recognizes a PPV Adjustment.Could you please help me understand under what specific scenarios or configurations the system behaves this way? 

we are looking to a pricing type based on Project Price Class vs Customer Price Class.  Has anyone been able to accomplish this in the system.  We were exploring a customization for this but the price is coming back at $18,000.  i am looking to see if anyone else has come up with a solution for this.  We have 5 products with 6 different prices.   Thanks in advance for any ideas.  

This is the2nd or 3rd time it has happened to us that we have seen a change in permissions or other misc weird issues after a patch was installed.  Prior to the patch install last week PM role was able to create a task on the activities tab of a project.  We use it to manage/request a permit for a project.  After the patch it was greyed out so they no longer had permission to access it. I fixed it but I am frustrated because it not always easy to find the permission since the permissions are so granular its a time burden. I am trying to get all depts to do everything inside Acumatica rather than using Word/excel but it doesn’t help my case when I have users complaining because now they can’t get in. 

On Process Shipments page, can you only process shipments for that current date (or prior?)  Not any shipments in the future?   We will be closed for a couple weeks and would like to process shipments early  (That will be picked up by UPS while we’re closed)  we would like to keep the scheduled shipment date as actual date UPS picks it up..  For invoice, billing, etc.I see how when creating a shipment you can create for scheduled shipment date.   Also, invoicing.  Prior to releasing you can change the ship date that automatically  adjusts the net30 and posting period.It’s seems like the only hiccup is printing the labels.    

Hello, wondering if anyone is or has had the same issue when updating the current movement class for an item-warehouse using the Update Movement Class screen (IN506100) I’ve tried the following:Select Warehouse and Period, then Click “PROCESS ALL” Projected Movement Class would populate on some items I’ve tried selecting an item with a projected movement class and then click “PROCESS” Current movement class for that item would not get populated on (IN506100). I checked warehouse details for that item-warehouse and there is no value on the movement class.I’d appreciate if anyone has any suggestion or knows what I’m doing wrong to let me know. Thank you!!    

I have created a restriction group to restrict Balance Sheet GL accounts to be accessed only in one branch, this works as expected, but can we exclude one user from this group, so that the user can access all GL Accounts from all branches

hello everyone,I'm trying to give access to an employee so they can create new purchase receipt,ive tried access rights by screen, user etc but I can't seem to find that tabcan anyone assist me 

Hello, We’re in a unique situation where we’ve been live on Acumatica for about six weeks and are rapidly acquiring companies. To summarize, we currently have a single instance, multi-tenant strategy but are unsure how to limit the impact of unsimilar business processes and (especially) customizations to entities in other tenants.For example, we don’t want certain customizations to in one tenant to negatively impact an entity in another tenant. We’re also leery of the financial impact of acquiring another instance. My question, has anyone encountered a similar scenario, and if so, how did they manage it? 

Does anyone know how to create an import scenario for a company tree structure? I'm looking to understand the best practices for setting up and managing hierarchical import data for a company's organizational structure. Any tips or examples would be greatly appreciated.

Hello Community!!In classic UI, We used to have an attribute (InventoryItem.PAM0000151_Attributes) as a parameter, so that user would be able to filter the results in the report by this parameter. In classic UI the user could view the parameter as a drop down field:Now with modern UI, the parameter won’t show up.This is how the parameter is set in the report designer:Any help is really appreciated.

hello all,I have been trying to find a report Qty On Hand traceability report. So the report should display the Qty On Hand for a specific period. For instance, if my qty = 10 for June and I made a sale of 5 in July, so irrespective whenever I would the report if I enter my period of June in filter it should show me that in June month I had a qty of 10 units, expanded by Lot/Serial number & warehouse/Loc. Where can I find such or any references?

Where does Acumatica intend for you to save EIN? Initially I thought it was in the Shipping>Tax Settings section>Tax Registration ID. However, I think that is intended for the Ship-To state. For instance, I input for California the permit number for California, not EIN. I don’t see any box/field designated for EIN in any of the customer profile tabs. The reason I want to have this is so that the team can easily tie a customer back to this number instead of a bill-to if needed; in case there is ambiguity.