I’m working on a new project and I could use some help with the steps I need to complete. I’m trying to automate the importing of data from an external source on a nightly basis. Here is what I have:External system exports multiple files to an FTP location on a nightly basis. I configured a data provider to connect and sync to the remote FTP location. I wrote an import scenario to import the external file.Here is my problem. I can successfully run the import scenario with a single file, but how do I do it for multiple? When I perform the “File Synchronization", I end up as multiple versions (one for each new file). How do I configure Acumatica to execute my IS nightly and to import all the new files it finds?
I tried to create an attribute and then a UDF for a custom field I need to add to the Contact form. I created a custom project, I created the new field (as a string of length 10) and I added it to the Contacts form. By Default, everything works fine. It’s a string field and I am able to enter and save values. However, I want to change it to a combo box so I can restrict the user’s entries. In my custom project, I go to “customize” the attributes and I use the following:[PXDBString(10)][PXStringList(new string[] {"N", "P", "Y"}, new string[] {"No", "Pending", "Yes"})][PXUIField(DisplayName="Status")]It always gives me a TextEdit. Am I missing a line of code?In the past, I have created the new field as an Integer and used the following code:[PXDBInt][PXIntList(new int[] {1, 2, 3}, new string[] {"No", "Pending", "Yes"})][PXUIField(DisplayName="Status")]This works and I could do this but I’m trying to keep the values as string and not integers.
I started using user defined fields instead of creating data fields in my customization project. I created about 20 fields and added them to the Contacts form. I don’t want to see them on the UDF tab that gets automatically generated, so I made them all Hidden. Then, I went into my customization and added them to a new tab I created. Everything works so far. I also recently started working on creating Business Events. I want to be able to check for value changes in one of my UDFs. But I don’t see the fields on the Trigger Conditions options. Is there something I need to do so I can use those fields in my trigger logic?
I’m looking for some general direction. I need to create 3 or 4 forms to be embedded on our public website where users can submit and it goes directly into Acumatica (possibly kicking off a workflow). The form might also contain the fields to upload specific documents. Any suggestions?
I’m working on a migration project from Sage to Acumatica. I was asked to write an import scenario to load older AR Invoices. As I write the script, I manually walk through the steps to see how it interacts with the data entry form. When I get to the detail section and try to add an inventory item, I see that only non-stock items are displaying in my lookup. All my imported items are finished goods, so I’m getting errors for my import. I’m not familiar at all on how the inventory items were imported, but where/what would I look for to allow finished goods to show up?
Is there a way I can store a value in a variable while running an import scenario? I have a situation that would easily be solved if I could store a value temporarily and then use that value later in my steps to store in a field and/or to use it in a logic statement.
I am working on a custom project. I created a custom field using the “NameValuePair” storage type and added to the Customer data entry screen. I initially published the customization and wasn’t sure it was what I wanted, so I removed it from the project. I later realized that it is what i wanted, so I went to add it back in. However, I now get an error message and I cannot get past it. I also get an error when I try and open that screen in my project. The error is: “An item with the same key has already been added. The customization project must be published before the screen can be edited.” I have published it without error and I still cannot edit the screen anymore. I have to revert back to a VMWare snapshot to recover.Where does this this data get saved in the DB? Is there a table I need to access and manually clear out?
On the Lead profile screen (CR301000), I created a custom field to store a string values called UsrDepartment. I also created the same field on the Contact profile screen (CR302000). When the user chooses to “Create Contact” from the Lead profile, it correctly creates the contact. However, the data in the custom field I created doesn’t automatically carry over. How and where can I add logic to copy the value over from the lead to the contact?
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.