Solved

Is there an Authorization.net Credit Card integration with Acumatica ? 

How do you pay your credit card bill and link credit card purchases made and listed under other vendors?

Hi all, I am looking for a way to add the customer price class to the customer list view. I am trying to do this so I can sort the customers based on the price class and also to quickly see what customers have what price classes. I am trying to add fields to the generic inquiry, however I cannot seem to get it to work. Here is how I currently have the GI set up (I have tried all different join types)And here is the result I am gettingThose are all the same customer. As you can see, it is just repeating the price classes for each customer.I wouldn't mind using a report that would show this, however I cannot seem to find one. I do need to be able to export it to Excel.Any help is appreciated!  

Is there anybody out there that knows if this Problem field can be made NOT required:  

i Have encounter in oaouth2 configuration

Hi all, Anyone knows which access rights to control the Audit History under the TOOLS? I know there is a role named Field-Level Audit for it. But I want to know the access rights.   

My client manufactures stock items with different container sizes. They have stock items listed as shown below:WG36-BulkWG36-264GAWG36-317GAThere are times they need to do a repack from Bulk to 264GA and need to allocate labor and overhead costs. If we use the BOM for the stock items, it includes the component parts needed to produce the item. In this case, we will not need the standard components as we will issue WG36-Bulk as the component. Is there an easier way than deleting all the components and adding this one item with the labor and overhead added? Somone suggested an Inventory Kit Assembly but I really want to tie this to a production order from a sales order. Looking forward to the feedback,Thanks, Jim

I’m trying to run a basic import scenario that looks at specific opportunities and updates the owner. I know I’ve had issues before with updating an owner field on a business account, but not an opportunity. Any input? Sometimes it’s the simplest thing but I can’t figure out what would cause this...

Good day Team, I have a customatization that allows me to set the Bill Description from the new APPrintCheckDetailWithAdjdDoc.DocDesc, and is working as expetec, the issue, is that when there is no data the results is a zero, i have tried to use the iif statment when the Variable $DocDesc00 with valueExpr =IIF($LineNbr = 0, [APPrintCheckDetailWithAdjdDoc.DocDesc], $DocDesc00), will provide the correct value, but when the line is empty, the value is 0, if I do a IIF statement the report errors out, i have use this statement on the VisibleExpr field, but not working. Any ideas how to solved this?

In our receiving department we print out receiving labels for ingredients used in production. We normally receive Cases, Pallets, Bags….etc. and we generate an inventory bar coed label to apply to the container. On the Purchase Receipt I have 1 line item on the PO for 4.44 kg. The product is delivered in 5 separate containers 4 - 1 kg and 1 - .44 kg. I select the Line Detail in the Purchase Receipt and add my 5 containers with the lot code and quantity of each. The current bar code Inventory Label is printing from the PO Receipt Line quantity, (ex. 4.44 kg of product) How do I set this up to print a label for each line in the Line Details screen in Report Designer? See image. 

I a working on a Dashboard and one of the items the user want to see is a comparison of items sold, in a date range. The user wants to see the results in a doughnut chart. There are three items that will figure into this chart, the quantity sold of two of the items needs to be added together and displayed as one of the elements in the doughnut chart.As an example lets same the three items are Light Blue widget, Dark Blue widget, and Red Widget.We want to combine the quantity sold of the Light Blue and Dark Blue together and show that as one element of the doughnut chart, and the Red Widget total sold would be the second element of the doughnut chart.My question is, how do I total the two Blue widgets together in the Generic Inquiry  

How do we apply a payment, using payments and applications, for something that is not invoiced or does not require an invoice. For example, we may get a government tax refund and need to apply the check we receive. How do do so using payments and applications?

All of my menu items for CRM, parables, and Finance just vanished and I don’t know how. I have the 2021 r2. I checked if they were disabled and who has access and they all seem to be perfectly fine.Can someone help me recover these? 

​Hi all,I have this Sales Invoice print preview in Acumatica.when exporting it to excel while in ‘Auto’ excel model in report designer, it looks like this. These boxed amounts should have been in the lower right corner cos there should be a long gap between.I want to set a default format when exporting Sales Invoice to excel that will place the details exactly where their position in Acumatica preview is. I know that I can set the excel mode to ‘Manual’ to specify the column, row, height and width. But when putting excel height and width, I’m getting error. What is the correct way I can get the desired result?Thank you!

I’m currently modifying this report. Regarding to this report there is a custom table called APPromaItemList in my instance which contains the sales order details along with the proforma invoice details. Bellow screenshot depicts the modifying invoice report.Modifying Invoice Report000010 is the corresponding sales order number for the above invoice report number 000004. Please check the below screenshot.By this sales order number 000010 I'm generating a sub report of this APProformaItemList table to obtain the ProForma Invoice number. But when generating this the same Proforma Invoice Number is printing 4 times as shown in the above screenshot. It is not what I expected. I need only to print it once. So to overcome this issue ,I grouped by using the Reference Number in the APProforma as shown in the below screenshot.Screenshot of group byBut it was not success. So, to overcome this issue please give me some guidance. Thank you.     

I am trying to setup Device hub on our server, but am getting a permissions error with theconnection to ERP...[Error] There was an error opening the connection: StatusCode: 403, ReasonPhrase: 'Forbidden', Version: 1.1, Content: System.Net.Http.StreamContent, Headers: So this results in Acumatica (MYOB Advanced in Australia) not seeing the printers that are setup in DeviceHub, but if I add the printers manually in the ERP then the DeviceHub recognizes them as setup… but still nothing is found in Acumatica. 

Hello, I am currently putting together a GI that will provide inventory on hand values on a specific date. With this, I had added the InTran table to acquire the InTran.TranDate values for the Parameters tab. With the addition of the InTran table, I am now getting a large number of duplicate values from the GI. I assume the reason is join related, but I am having trouble getting these duplicates removed. Any assistance would be appreciated! Results Joins 

Hello, does anyone have an inquiry that lists bills and the payments applied to the bills? I am having trouble with my inquiry. The joins seem find but not all results are populating.   

Hi Team,Below is the screen shot of my question. I clicked “Load Documents” to show all the open invoices for my transaction period, customer and location. 1) it shows 13,646.73 Applied to Documents after unselecting all invoices. Should it be $0.00 if I unselected all invoices? Why does it show $13K invoices selected? 2) It does not show all open invoices. It only shows 19 invoices when there are 59 open invoices. The next arrow is greyed out. How can I show all open invoices for my criteria?   

A client of mine requires restricting access to projects for their project managers. They do have around 15 Project managers. Their access needs to be restricted for projects, Purchase orders and Purchase receipts.I’m just struggling to think of the best way to handle this. I thought of restriction groups however not sure how to do that for 15 different people who require access to a single project or two, purchase orders raised for that project and can do purchase receipts for the project.In the instance, a procurement manager raised a bulk purchase order for different projects at the line level these managers need to be able to pick up the relevant entry for their projects.Any ideas ?

We have a GI with a calculated date field that returns no results when we apply a quick date filter to it.   Any suggestions on how to get the filter to work? Thank you! 

I am trying build a conditional switch if the status of the project-task is not ‘Active’ then Activate it via <Action: Transition>.However, my I cannot seems to get the right value for [Task.Status]. I tried using ‘A’ and ‘Active’ but neither seems to be working. any suggestion would be greatly appreciated! thank you!    Possible Value for Project-Task Status:D = In PlanningA = ActiveC = CanceledF = Completed  

Hi, thanks for any help - rather new to integrating against the Acumatica API and to date have done so only against existing endpoint to create, retrieve and update invoice line details.  This is a first attempt to use a Generic Inquiry and expand the web service endpoint.I have followed the same steps outlined in Accessing Data in Generic Inquiries using Contract Based API’s - Acumatica Cloud ERP to expand the Rest API endpoint with a generic inquiry that provides employee leave balance.The inquiry has no required parameters so simply have {} in the body.The API PUT call fails with  "exceptionMessage": " The given key was not present in the dictionary."I am not very sure where to start to address the error.Note the inquiry uses payroll related and other tables that are not exposed anywhere else in the rest api - if any fields listed in the inquiry mean extending further the web service endpoint to add the objects, please help explain how to know what to add.Please see the screen captu

Hi, i am trying to delete the customers by using import scenario. Screenshots are attached of the error and import scenario mapping. Can somebody help me with this? thanks

Good morning!When i convert a sales quote int he CRM to a sales order, it assigns the wrong branch. Is there a setting somewhere that i can manage this through? the sales quote in the CRM does not have the option to choose a branch so when it is converted i guess it just automatically defaults to our ABC branch? I feel like i am just missing a setting somewhere but i have looked and can not figure out where it would be. Any help is much appreciated :) Thanks in advance!