Replies posted by rosenjon
HI @MikeT -Great! Glad you got it working. Since you aren’t a customer of Acumatica, I think maybe you can’t blame them too much for not helping out. If they took support requests from non-paying people, it might degrade the quality of support for paying people. I think the community forums like these are the proper place for these kinds of requests, so glad we were able to get you going. Thanks,Jonathan
Click on Restore Snapshot, and it will restore U100… (see arrow in screenshot). That’s of course assuming you haven’t already done that.It looks like you already have Sql Server on this computer to run Sage, so it just installed your Acumatica database into that server, which is fine.
If you have not yet deployed an instance, you will have to choose “Deploy New Application Instance”. This is where you will setup the site (you will need to have Sql Server running on your machine). You will need to provide credentials for Sql Server so that Acumatica can create a database and populate it.Based on the conversation so far, I am going to assume you haven’t yet installed Sql Server. If this will be purely a development instance, where only you will be using it, then you should be fine with Sql Server Developer Edition, which is free: https://go.microsoft.com/fwlink/p/?linkid=866662Download fromt that link, then install Sql Server. Let us know when that’s done, and I can walk you through the next step.
It’s telling you that the snapshot you are trying to restore from is based on a different version than you are currently running.If you go to “Apply Updates” inside of Acumatica, you should see an option to upgrade to 22.202.0040, which will bring your Acumatica version in line with the package version. Use the “Download Package” option with that verion selected, and then you should be able to “Install Update”.Once your Acumatica version is the same as your snapshot version, you should be able to restore the snapshot.
@MikeT First question is do you want to run this locally or in the cloud? I can help you get setup if you like. Maybe we can use this forum post as a guide for others also. The links posted by @kbeatty21 are not bad, but there are some missing steps in each of those articles.
@robk20 The licensing guide contradicts what you are saying. Below is a screenshot from the guide. Acumatica carves out “System Recommendations” vs. “System Constraints”. Recommendations are the limits that Acumatica suggests in order to have optimal system performance. Constraints are hard limitations that are either strictly enforced, or generate warnings that may lead to strict enforcement.https://www.acumatica.com/media/2022/04/Acumatica-Licensing-Guide-2022-Apr.pdf#page=1&view=FitH,0&zoom=95,0,0&toolbar=1&navpanes=0 You can see that the constraints are all things like “Web Service API Users”, “Concurrent Web Service Requests”, “Web Service Requests Per Minute”, as well as database performance correlatives like “Lines per transaction” and “Serial Numbers per Document”.System Recommendations are things like “Concurrent Users”, “Daily Commerical Transaction Volume”, “Hourly Commercial Transaction Volume”, and “Daily ERP Transaction Volume”.I still think my request is
@robk20 I have read the Licensing Guide sections you reference. It seems that most of the “hard” limitations on system usage really relate to simultaneous web service calls, which are things that are generally happening outside of the core system... web services are generally used for synchronization to third party systems).However, there is no statement one way or the other on whether there is any performance limitation within the software, that is tied to license tier. If you license at the top tier, does ths software support additional CPU cores, or additional server resource that the lower level subscriptions do not? As I mentioned in my original post, the guide refers to the licensing tiers ”influencing the parameters that impact system performace”. This seems to be alluding to there being possible hard limitations inside the software, but without reference to any specific technical subject matter that would make it definitive one way or another.It would be nice to get a definitiv
Hi @Julia Lukina -Thanks for the further explanation. I think the idea of a linear “golden path” through a massive warehouse is kind of silly. In the future, you might want to consider allowing some kind of calculation function to be set based on some set of variables (current worker position, pick priority of the item, capacity of the picker [i.e. hand pick or forklife, etc]), in order to calculate the next best pick position. I think this would make this concept a lot more useful. Thanks, Jonathan
UDI is just a format for creating globally unique identifiers: https://www.gs1.org/industries/healthcare/udiThis would probably be a pretty straightforward use case for serial tracked items: https://help-2022r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=7d0568cc-3a1a-4e9c-a7ea-9df31601d445You will want to set it up to use your own identifiers, and then will need to make sure the field is configured so that it is long enough to accomodate the UDI. I believe that you can force the system to ask for the serial number when receiving/shipping product.
Seems like they have multiple warehouses on one campus. If you have a scenario with warehouse A, B, C all on the same campus, and all warehouses have similar internal locations (ie location 100,101,102,etc), then in order to not relabel all the warehouses you might opt for multiple warehouses in one campus/location.
@michael73 If you look at what the WMS scanner is actually doing during Pick, Pack and Ship, it’s really just entering data into the Shipments section of the Acumatica screen. So when you say there is no way to complete the item manually... just fill in the qty picked for each wave pick ticket...and then you’ve basically done what the handheld would have done (you will have to add any packaging info as relevant also).
@kbeatty21 Why are they doing so many inventory adjustments? I’m trying to understand what is driivng this issue.In Acumatica, if you return inventory, does it force you to choose a layer for adjustment? Or based on what you return, can it automatically put the inventory back to the correct cost layer, based on which layer it was taken out from originally?
I’m just going to assume you’re on 21.2.213.0038. I’m not sure what you mean that it is “rebranded” however.Do you have .Net Framework 4.8 installed as well as .NET Core 3.1?Male sure you enable all Windows Server services listed on page 19...http://acumatica-builds.s3.amazonaws.com/builds/21.2/PDF/AcumaticaERP_InstallationGuide.pdf
@Dmitrii Naumov I’ve figured most of this out now. I wlil post a formal how-to in the coming weeks as I get my own project into more solid form.I have some feedback for the development team, however. I think it was very smart to nuke the kvstore idea, and to go with these line split tables instead. For example, we now have POReceiptLineSplit instead of POReceiptLineKvExt. That’s all great.But the UI for working with Inventory Receipts and Sales Order Line allocations hasn’t adapted to this new approach. In the screenshot below, this is an example of an Inventory Receipt transaction, where we already entered the purchase receipt of 100 units of material as two, 50 and 50 lots with different lot numbers. When we go to enter the inventory receipt, the system auto-populates the correct lot/serial number entered into the Purchase Receipt, which is good. But it is placed into a selector field, where you can then choose some other lot/serial number if you want to. This is just non-sensical. Y
@jacobslotta06 FWIW, I have basically built something similar for our own internal transition from a legacy ERP system to Acumtica. I wrote scripts that takes the legacy data structure, exports individual data items as JSON objects, and then have scripts that load Acumatica from those exported data objects.The goal is to have a “continuous integration” style flow of data from the old to the new ERP, so that users can train on the new ERP but have all the same data that is in the old ERP.Where necessary, I reprocess the base data items into “intermediate” objects that make them easier to import into Acumatica. As long as the export format of your data from system A is predictable, then your scripts should run reliabily no matter what the actual data is. Some people think in terms of individual pieces of data to export, but I think that exporting data as “objects” that contain all the data in the system makes it way easier to add on to later when you need another piece of data that you h
Ok I see now. Basically you want to tap into the native UI for export mapping, so that end users can maintain the mappings using the already available tools.I mean, for starters, have you tried creating a customization project and creating an instance of SYMappingTools/SYImportProcessor? It’s possible you can just use them directly….I think you might have better luck writing a translation layer that is external to Acumatica, that pulls the data you want, translates it into the format for sending to the external system, and then mediates that interaction. There is the possibility that the import processor changes quite a bit between versions and then you are on a rollercoaster trying to chase its modifications. The REST API, on the other hand, is built to be relatively stable across upgrade cycles...
@jacobslotta06 I think it might be helpful if you describe this end-to-end process in more detail. Forget about mapping things. What are you trying to do, end-to-end.For example, “every time a user updates a sales order, I want Acumatica to send the contents of that sales order as a json encoded string to system x’s REST Api”.
@Andrew1986 Can you clarify what solution you are using exactly? Did you create this API integration yourself, or is it an out-of-the-box integration?The API is throwing an error that you are not populating the ReferenceNbr field correctly. Since you are updating the record, you need to provide a correct primary key field for the system to know what record to update. It looks like your Reference Number is literally: AR...…So maybe this was some stub code where the correct concatenation isn’t in there yet to properly populate the field?
hI @Dmitrii Naumov -Sure. I will just run you through what I’m working on right now, and hopefully that will illustrate where some of the questions are coming up.We are in the metals industry, which means for every receipt of material, we need to track certain things on a per lot basis. One of these would be a Lot Number (already built into Acumatica). But there is also something called a Heat Number (which is related to Lot Number but generally distinct from it). And then we usually have a document called a Test Report which gives specific details about that lot of material, and which needs to be tracked with each lot of material we receive.So, when we receive material, we need to record this information against each lot received. It also needs to be tracked in INTran, so that it is logged against the actual receipt of material. Likewise, this needs to be selectable in SOLineSplit, so that if a salesperson wants to sell a specific lot of that material, they can see what is available a
Also, if you have someone technical on your staff, get accustomed to setting up your own local instance of Acumatica and doing the upgrade on that instance first. If everything runs ok on the test, then you are probably ok to do the production upgrade. This isn’t a small lift, but will pay dividends if you have someone in your org learn how to do it.
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.