Financials

Hi all!For some reason, we have a warning on the timesheet for certain employees :Do you know where this warning comes from? I would like to correct it, it’s not needed in this caseThe employees use a labor item which is “Labor Item” type in Labor Rate Form PM209900, and aren’t set as “Employee” type in Labor Rate Form(So no hour quantity in the column “Regular hour by week”. The “Regular hour validation” is set to “Warning” in Employee form EP203000, but i dont understand where it takes the 57.5h?   Thanks  

Is there a way to easily CORRECT the Vendor Reference Number (ie. invoice #) of a Bill after it has been released and before it has been paid?  Currently the only way I see how to do this is to reverse the whole Bill.  This seems extremely unnecessary when what is needed is just an invoice # CORRECTION.  This is no different than changing the Due Date which, correctly so, is allowed.

I’m working with a partner, and were attempting to reconcile many months of inventory history to the Trial Balance Summary. We’re attempting to build generic inquiries to do this using the INTran and INTranSplit tables, extracting rows, grouping by our materials / lots / warehouses / locations to find that last transaction and filtering by Financial Period.  Our comparison results are sometimes close, but never tying out. The back story is that a number of inventory receipts and adjustment were done during various go-lives and onboarding events, and now the Finance department is concerned about being able to audit the the history, essentiallly using details to prove out the Trial Balance Summary report.Has anyone out there encountered this circumstance? Perhaps someone might shed some light on how the Trial Balance Report (especially Inventory Accounts) is calculated and relates to the transaction history?  Many thanks!

Upon Adding of New Restriction Groups,The system gave me this error.Would you help me to solve this issue? 

Client bought 8 (qty) fixed asset amounting to 8,221.71. When converted to fixed asset, the fixed asset transaction generated 9 asset IDs one of which amounts to only .03. So i tried to recalculate it manually.8221.71 total for 8 assets / 8 = 1027.71 each1027.71*8 = 8221.68.03 = value of 9th asset recordedIs my observation right?Is this really possible?how are we going to explain this to the client?

Hi Acumatica Team,I want to transfer a particular item from one Project to another Project but Acumatica gave me this error message. This is my project set upBalances :Purchase ReceiptsWould you help me to trace this error?Thank you! 

Good morning, while on the Credit Memo and Debit Memo screen in AR, when we add a row, the row automatically adds account 3030. How can we change this to be an account other than 3030? Note: we know how to change it after the row is added, we need to change it so when we add a row it automatically goes to another account other than 3030. See attached below for reference:Thanks!

Hi,What happens when landed cost is added to an item after the the inventory issuance? For example, our manufacture sends us an invoice for the landed costs associated with a PO after its been received. In some instances the landed cost has been received even after we’ve invoiced and sent those items  out to our customers. I’m curious as to what happens in Acumatica once I add the Landed Costs to those items after its been invoiced and shipped out. How are the landed costs expensed as COGS. -Edwin

Does anyone know why journal transactions from the AR Module wouldn’t automatically post to the GL if it’s set up to do so?  We have noticed that 3,666 transactions from a one week period in December have not posted to the GL. I’m relatively new to the position and at a loss as to why this would have happened.  Any help is greatly appreciated!  

We created a new subaccount to have sales orders split out into a new bucket for additional analysis.  Everything is flowing correctly going forward, but I would like to go back and reclass existing transactions (sales and materials) to get to the proper subaccount for historical comparison.  I can get to the sales numbers by running the sales order report and filtering to what is needed.  The part I am struggling with is how do I get to the materials cost to complete my bulk reclass entry?  I am not finding a way the 2 are connected by a reference number or some way I can get the data into a spreadsheet to identify the entry needed.  I would love if anyone has an idea of how I can make this happen!

Can someone help me to restrict the access of user to see only debit memos / debit memo but not to see payments under bills and adjustment??

Does anyone know of a way to extend a customer to a vendor if that vendor already exists? I know you can do it if they do not, but what if the vendor exists? Same for vendors to customers? 

Hi,I need to void a customer payment received back in few months ago. There is a field “Card/Account Nbr” which is empty and the system said it can not be blank. I try to enter something into it but can’t. Not sure what to do. Please help. Thank you. Raymond

I have a user uploading an Excel file into the journal transaction screen. If a subaccount in the file is inactive in Acumatica, it automatically changes to the subaccount of previous line. No warning or anything.  I tried recreating in my local test environment, and instead I get an error that subaccount is inactive. I don’t see any relevant differences in the settings. Anyone seen this or have an idea how to solve? Unfortunately upgrade was delayed so I can’t submit case with Acumatica. 

Hi Team,Good Day!As a practice our company used to print the payment voucher from the checks print process. (Kindly refer the following image 01)Image 01In that process one check is only allowed to print at only once. So if we have any issues with the print we are not able to reprint it also we are unable to track the issues.So my concern is, is there any other way to get the print of the payment voucher from the system ? (Without using the check printing process) Thanks & Regards / Yashodha

Our customer would like to apply payments by using a process for pay/release A/R invoices.For credit card there is “auto-apply payments” but this is not available for any other payment method.What do you suggest?

I have the expense claim below in the screenshot.  There is MAJOR issue here where I cannot figure out why the Expense Claim Total equals 1,043.86 but when I add up the line item totals it ONLY amounts to 929.56!  Why is there a 114.30 difference??  Note that 114.30 is exactly the same amount if you add line items of 24.30 and 90.00 together.  It looks like Acumatica is DOUBLING those two line items.  But why??   

I have a client that wants their report titles to include the following verbiage:“For the X Months Ending DATE”Where X equals the number of months (in words, not number) the report represents, and DATE is the period end date (in standard MMMM d, YYYY format). What is the best formula/format to attain this outcome?Thank you in advance.

Hello - We have a pretty basic PO Approval process set up. Anything over $XXXXXX. This works well. I would like to add a step that sends a notification to the PO Creator that it was approved. Below is our rule as it sits today.   

Hello, is there a way to create a cost centre? for example creating “workshop centre” where all related sales and expenses are tracked etc? 

How to generate a GL detail report for a range of GL accounts? Can the report sorted by GL accounts instead of batch numbers?

Hi,If I want to create an invoice for a customer, what is the different between the two methods below? Receivables/ Invoices and Memos/ New record Projects/ Run project billingThank you. Raymond

Please see the screenshot below of what we see when we try to login to Acumatica.  Please note that the browser in the screenshot above is not Chrome, but Mozilla Firefox. The same error shows up in both Chrome and Microsoft Edge. Because of this issue, when we log in, we are unable to access any part of the system as the icon keeps rolling but never opens up a page.

I am aware that Acumatica allows 1099 reporting.  Is there a particular 1099 form number that is best formatted to work with Acumatica?

Hello Everyone, Recently we have upgraded to 22 R1 version but General Ledger Details report is crashed.When we are trying to navigate the report from Profit & Loss report to General Ledger getting this error.Can anyone help me on this?CC: @Irina