Financials

I am having a hard time understanding exactly where these costs are coming from and how to adjust.Standard cost sectionPending costs - ???Last cost - ???Current cost????? - where can I update this?? Cost Statistics SectionLast cost - this is the last cost that it was moved into inventory at (looks to be actual cost of materials issued against production order)average Cost - this is the number that I just entered under Item warehouse Details, then rant updated standard costsmin/ max - looks to be actual cost from production orders my questions are 1. - how come EVERY time I update cost on the warehouse details, it automatically goes back to what I just updated it from?  7.67. updated to 8.30 and now it looks to be going back to 7.67 tomorrow- where and how do I update current Cost.  what is this number and where is it used? when I update standard costs, why does it go to the average cost, vs the standard cost last cost?am I missing something??? thank you!  

I can see transactions in my cash account and have the total I expect in the TB, but when I go to reconcile the same cash account I see transactions that I don’t see in the cash account detail and don’t see transactions that I do see in the cash account detail. When I run the reconciliation statement report, the transactions I’m missing show in the uncleared sections. But when I go to continue reconciling I can’t find them. Not a date issue, I’ve cleared all date filters and checked posting and cleared dates. I’ve trashed and restarted this recon a few times, thinking it might be a fluke. Same issue. We’re also on an older version of Acumatica, 2021 I think, with plans to update soon. Could that be causing this issue? 

Hello All,I have been trying to display the Segment values in the Gl Accounts Access screen. But the tab doesn’t display the data in it:I have activated the segment as: And then the tab gets displayed: But none of the Segment values are getting displayed. How can I resolve this?  

Hi,we would like to show in the details of a sales quote the margin of a product (only for internal use)As have ave not bought the product before the last cost is empty. So the cost is zero. So is it possible to use the vendor price instead for the item cost? And if so, how?    

Where an invoice has attached files, is there a way in which we can add these attachments to the invoice form in report designer? I see from previous discussions that the use of a sub report might work, but where does one find the schema for the attached files and how does the linking work?

Hello, I try to make a process payment and it look like show only documents to pay at Debit Adj only. Reference in picture.Can someone help me with this one ?Thanks  

Our salespeople quite often print a copy of an invoice to hand to the customer as they leave with their product.  This seems to create an issue where that invoice will not show up to print for mailing to the customer’s accounts payable dept for payment in the Print Invoices and Memos process.Has anyone come up with a solution to this?  It seems to relate to the checkbox that the invoice has been printed.Thank you!

Below there is a article on how to remove the 1099 boc on a released BillIs there are article on how to add 1099 box for vendor that was not marked as 1099 vendor but should have been ?   

Hi,  I release a vendor invoice but later discover that the post period is wrong. Is there a function in Acumatica which allow me to “unpost” or reverse the release of the vendor invoice? Thank you. REgards,Raymond

I am trying to run recurring transactions and getting an error message that states “the financial period after 12-2023 is not defined in the system.  To proceed generate the necessary periods on the financial periods form.  What does this mean?  Thank you!! 

How can I make partial payments on a bill entered in Acumatica.  Prepaid Insurance is annual lump sum and I need to make weekly partial payments from that bill. 

Hi,I had passed credit memo and matched with invoice and then it turned to closed status.After that I had realised that I had made mistakes and I want to reverse the credit memo and adjust with debit memo, but I am not able to do that. When I reverse Credit memo, I am getting Debit memo, but I am not able to see the invoices in open status.I want to see invoices in open status, can any one give some solutions? 

Hello All,I have a business event that should trigger a report. Below are the parameters filled up into the email template for the business event: The Gi that is created for this business event has the Primary table of APPayment. But when the notification gets triggered it attaches a blank report:​​​​​​​Whereas when I try to run the report manually by filling in the parameters it displays the correct info:​​​​​​​What is it that I shall modify in the Email notification → Attached Reports tab??​​​​​​​Thanks in advance.

Hi, we are trying to release a bill and this error come up. For my understanding, it need a separate account to pay for US vendor ?How we can solve this one ?Thanks 

Hi,In practice our customer post some payment entries to GL in bulk. The bank shows these payment transaction one by one in the bank statement. In this scenario, what is the possibility of matching one cash book entry to several bank statement transactions when doing bank Reconciliation. Please refer below example,Company records transaction as below,Bank Charges A/c  Dr    100Salaries & Wages   Dr   1000Cash Account           Cr    1100in the above example Bank statement shows the transactions as below.Bank Charges      (Disbursement)  100 Payment               (Disbursement)  1000In this case how can I match cash book transaction of 1100 to 100 and 1000 bank statement transactions.  Thanks,Dulanjana 

I would like to create a few Account Classes that have an “Equity” account type associated to them. (for example, “Common Stock” and “Paid In Equity”).  But that “type” of account type does not exist and there is no way to add a new type.Why was this excluded?  Is there a work-around for that?Thank you,

We went live recently and are trying to brainstorm a more efficient method of expensing Purchase Order vs. A/P Bill variances.  Ideally, any variance below a defined threshold (like 5% for example) would be ignored and inherit the original PO account coding, with those items exceeding the threshold submitted for additional review and approval.Has anyone been able to implement anything similar to this?  If not, I’m curious to hear how other Accounting departments are processing these variances.

Hi All,I’d like to store vendor bank account numbers under a configured payment method. I’ve checked the former questions and found useful information on this one:and still have 2 main question:Sometimes a vendor have multiple bank accounts. How to store all its bank account numbers under one payment method? On the page of each AP bills, we decide for this bill a specific vendor bank account to make payment to. But I couldn’t find this information anywhere inside an AP bill. Is it possible to show it?Thanks!

Our customer has an executive team that wants to have 2 people approve checks.  When they cut checks they want the executive team to approval checks then have another member of the executive team go in and approve checks gain.Is there any way to set this up so that the same person can’t approve checks both times?

Hello!How do I set up my employees Access Rights by Role to include having the ability to create new Bank Reconciliations Statements? Currently, they can only View the statements.  Thank you!

Hi,May I know the process on how to input the current cost of a stock item? I am using standard valuation method. Or is there other process outside the stock item fields to have the current cost.Thanks.  

Hello All,I wanted to know if we can conclude Voided Payment & Reversed Payment as customer Refund?Thanks in advance.

Hello, is it possible to have a Restriction Group on Sub Accounts? Regards,Laura

I try to create a journal entry for conversion of some money in CAD into USD. The journal currency is in CAD. When I pick the USD account as in CAD equivalent, a error message said “ Denominated GL account currency is different from transaction currency”. Please advise how I can resolve the issue. Thank you.

Hello, One of our clients has imported and then posted several hundred bank transactions (they imported twice). As far as I know, the best way to void them out would be to create an import that reverses the transactions. If anyone knows a better way, please let me know. I have created the integration but keep getting an error that it cannot save or release the transaction. I have followed the steps exactly in Acumatica and I can manually perform them, but the integration seems to be having an issue. All I am trying to do is import a list of the transactions that need voided and tell the system to reverse them. Maybe because it is creating a new transaction by reversing?Any thoughts or ideas would be help. Thank you!