Solved

Hello, We are experiencing an issue when attempting to release an expense claim in the system. Everything to me appears to be filled out correctly, but we get the following error when trying to release the claim. Here is a screenshot of the Trace Log that basically just shows the same thing.  From the first screenshot, it looks like the Expense account and subaccount are filled in correctly. And I’ve compared this claim to others that have been able to release. Any ideas why this one won’t go through? 

My current client has many Earning Type codes and they are all included in OT calculations except one.  This miscellaneous Earning type is used when the company ‘gifts’ an employee a day off with pay.  A gifted day off, such as this, is not eligible to count towards OT pay for the week.  Has anyone ever run into a scenario like this? Thanks in advance for any input.   

I am looking for suggestions on how to prevent previous day postings.  I do daily reconciliations of sales and COGS accounts.  Everyday I am having to go back and do each day because there are changes and my numbers are no longer balanced.  This has become very cumbersome to manage.  Is there a setup that we are missing to stop the constant changes?

Hi Team, I would like to know how to record the over payments for utility bills ?For an example suppose my electricity payable account’s balance is $100. But the payment has done $110. How can we record this transaction ? Thanks & Regards,Yashodha

Has anyone encountered this before and if so what was the solution?

A client would like to use FIFO for their inventory valuation method.  They use Batch control and expiry.  I have ticked the “cost sep” on the Warehouse location (they only use one location).When entering a Sales Order however it is only taking the cost of the first receipted qty.Is this the way the system works? I am assuming yes bc at the Sales stage the inventory has not been allocated yet so there is no way of picking up the cost?Regards,Laura 

Hi Team, I would like to know how to record staff loans & advances in Acumatica if the payroll module is not available. Can anyone suggest a workaround for this? Thanks & RegardsYashodha  

Client sells to Distributors, Chains, Retail Outlets. They can ship the same item in a Pallet, Master Pack, Inner Pack or Each. For the purposes of compliance, they have to provide the weight and dimension of each of the shipping methods, although the UOM on the SALE is EACH. We have Acumatica and Pace Jet and are looking to see if someone has tackled this before and is there a way to best handle this other than attributes? 

There is a Sub report in my main report. When  I export the main report to Excel, the value from the sub report does not export. But sub report data also appear when the main report export as a PDF. So can I know how to overcome this and export the main report with sub report data to a excel? Thank you.

I created restriction groups based on item classes, and I see all prebuild reports follow the restriction rules and don’t show up the items for users outside the groups.However, I created some GI’s on the PO line table and SO line table and it does show up in these reports all items even outside of the users group.is there anything I'm doing wrong that the system doesn't follow the restrictions on my reports?

Hi,I have application which is implemented via html,css and javascriptThis application  allows to create a form that looks and feels exactly like any website,It opens this form in browser and calls one API for further workMy goal is to do same for AcumaticaIs it possible to insert this form to Acumatica window ?For this I need to understand if Acumatica API supports html page dispatch with which I could work.I mean now it opens just in new tab in browser, does it possible to pass this from to Acumatica window like this ?Is it possible to do that without work with screen graph by adding new element, adding new screen and writing new business logic in Acumatica ?I have ready API and I just need to call it in new Acumatica window not new browser tabThanks in Advance

Upgraded to 2022R2 last week.  I was attempting to remove material previously allocated to a production order incorrectly.  I was able to put in the negative quantity but the dollar amount is positive.  The unit cost selection is grayed out so I couldn’t change the value.  Once released, it was actually adding to the production order total rather than decreasing by the amount removed.  My example below shows how the amounts worked prior to upgrade.  Anyone else experience this?  

If you’ve done this upgrade…Does anything change about the underlying data structures, or does everything that is “native” continue to function properly? The upgrade itself seems quite simple, but I expect customizations to require updating/replacing or eliminating since some of our customizations are now native functionality. Do you have a general sense of how many of your customizations (by percentage) need to be updated/changed vs. any of them continue to work as they did previously? Just curious about your personal experience on this item #2.Thanks! 

I am at my wits end and need another set of eyes.  I have a PO Receipt subreport that prints exactly as I need it, but when I add it to the main report the values are not printing.  I have tried every conceivable combination of PRINT=ALWAYS / WHEN READ and moved the subreport up and down sections  I know it is picking up the subreport because I am getting a textbox value.  I have changed the grouping and sections and am missing something so simple, I know, but I just can’t seem to find it.  Attached are the reports if anyone can help.  Thanks.    

I have a bunch of Android Tablet users who would like to print .ZPL files from a Zebra Label Printer. Usually I use DeviceHub or a .bat file to get this moving, but Android doesn’t support .bat and it looks like DeviceHub isn’t supported either.How do we print .ZPL files to a label printer in the Android OS?

Hello Everyone,Kindly assist in making AFE Number field enabled once the requisition is approved.And also is there a way to make Files field mandatory/Required once a requisition is approved?see below Kindly assistURGENT!Any kind of response will be highly appreciated.

Our base currency is ZAR, and so our inventory costs are calculated in ZAR.When doing a service order for a foreign customer (USD), the costs are coming through incorrectly.  As an example, this item has a cost of ZAR 106.3938.  We are selling it for USD 9.59.The since the service order is in USD, Acumatica should be taking the ZAR cost and converting it into USD, to compare apples with apples for profitability :-)  But it takes the nominal value of 106.3938 and uses that for the USD cost. Now when I use the toggle button to view the base currency (ZAR) a fictional cost is displayed (the actual cost multiplied by the currency rate):As a result the profitability is incorrect.  How do I log this as a bug?

Just updated to version 2022 R2.  Previously inventory was automatically updated at time of invoice.  Since the update, IN updates at shipment confirmation.  Where is this change coming from?  And how do I change it back?  Thanks in advance.

Does anyone have a good video/link they can share for customing workflows in acumatica? I am trying to customize our billing process so everything is laid our in easy steps! 

is there a way to have certain screens automatically open upon signing into Acumatica?  Same situation as if you are logging into your computer, and automatically have teams, or another program open without actually having to manually open it.

Hi, when posting any Adjustment to the Stock Item with Lot/Serial Number and Expiry date, if a user accidently enters a different Expiry date,  the system updates the Expiry date on all the stock for that item and set this new expiry date. can this be prevented or tracked so the client can see the old and new dates? Many Thanks 

When I applying the invoice to debit adj it showing the following error. Error: Inserting  'AP Address' record raised at least one error. Please review the errors. Error: 'Country' cannot be empty.I checked the vendor has set up the country and the transaction  remittance has the country. Not sure what else has been missing.transaction error message transaction remittanceThank you.  

Hi! We are in the process of setting up our Acumatica account and are stumped with payment processing.We have some customers on 30-60 day terms, and our preference is that they pay at that time with ACH. Avoiding cc fees after floating the money for their company for a few months is ideal for our small biz. In QuickBooks, we can toggle payment preference of ACH or CC at either the customer OR the invoice level.We talked to one provider today and they basically told us that we can’t separate payment preferences by Customer Class (we have one for day-to-day customers and another for those in terms). Is anyone aware of an Acumatica-friendly payment processing service that will allow us this kind of flexibility?   

Hi,How to call multiple value on Barcode? Currently, I have configured the report to print barcodes for each value. I have try using concat» CONCAT([ARInvoice.CustomerID],[ARInvoice.CustomerID_BAccountR_acctName]) and set variable to call multiple value however not successful.Is it possible to setup report designer to call multiple value on barcode? Thank you

Trying to import sales orders but some of the lines have invalid inventory ID’s that do not exist in Acumatica. I still need to import the lines that do but they all fail because of the inventory items that don’t exist. How can I skip invalid inventory line and get the rest of the file to import.The import works if I only import inventory ID’s that are in Acumatica.