Financials

Hello Guys, as always thanks in advance for any help provided here. My controller is asking if there is a way to look at a report that just show AR transactions, and NOT   “SO transactions”. He says that all orders originate from SO, then they go to AR, and from there they end up in GL. He wants to know a way to pull JUST transactions that were done in AR (modifications, dollars changes, etc) that were done specifically in AR.  He wants to be able to filter out by the Types or AR transactions done in AR, linked to the SO transaction.... so he can then compare, and match with GL. That shows the SO that originated from, but shows the changes made in AR.Does that makes sense? We have another Vendor we use for reporting called DataSelf that is only looking at the SO, not the AR. And they are ha

Hello All,I have been trying to display the email accounts of the users who have created a Journal Entry/Journal Transactions. I am not able to do. I tried to create joins between Batch & BAccount and then between BAccount & Contact and then making Contact.Email visible in the Gi but this displays the email id of the particular branches instead of the creators who created the record. How can I achieve this? Thanks in advance.

HI There, Does anyone use the UK VAT and be familiar with HMRC summit tax function.   The user is trying to submit January 2024 VAT return to HMRC.But it shows “Cannot submit VAT Return - Tax Period not found on HMRC side.”Users said that she logged into HMRC and don’t see anything different at HMRC platform end. Has any consultants or UK VAT export met this message before and what should we do in ERP Acumatica side?  Have a Nice Day. Regards,David Lee

Hi Everyone,We paid a vendor twice and the Vendor asked that we keep the credit in their account to apply to future invoices. The prepayment method doesn’t necessarily work for us as we don’t have any bills received just yet and future bills will not always be expensed to the same general account. Does anyone have an idea on how to record the overpayment but not associate it with a particular expense account?Thanks,

Is anyone using Acumatica AP with Chase bank’s Cashflow360 service?  The client is switching banks to Chase, and was told about Chase’s Cashflow360 features.  It seems to be a fairly robust online bank billpay system where you can maintain vendors, bills (including OCR capabilities),  payment methods, and internal approvals.  Although the attached Cashflow360 User Guide mentions that it’s meant to integrate with the client’s accounting system, there are no details of how the integration would work, or which systems they already integrate with.  The client was told by Chase that Cashflow360 works with Quickbooks, so it suggests to me that Cashflow360 is not designed for larger companies using more powerful Accounts Payable systems.  At first glance, it seems like it would either be almost completely duplicating Acumatica AP, or essentially replacing Acumatica AP.  The main thing that caught the client’s attention was that Chase would print and mail checks to their vendors.  Bu

I have a GI for drop shipped items that looks at the selling price on an SO and compares it with the cost on the associated PO. I have a calculated field for margin & margin %. I would like to add this to a chart that tracks the weighted average margin % but the chart will simply give the average of the averages and is not weighted. How can I make this a weighted average?

We use Incoming Documents extensively (6000-7000 docs/month) for creating AP Bills.  When a document is saved and processed into an AP Bill, that file attachment gets linked to the AP Bill as expected.  The problem we are encountering is that normally on file attachments to a document, if you try to REMOVE LINK from the files page, it will not let you if that entity is the one and only entity the file is linked to.  However, in the case of Incoming Documents → AP Bills, technically that file is linked to an Incoming Document Entity as well as the AP Bill entity.  Because of this the link to the file can be removed from the AP Bill.  Imagine scenario where maybe one user is processing Incoming Documents and then a team of AP staff do further processing of the AP Bill.  If a user inadvertently clicks REMOVE LINK, the file is gone (I know not really deleted) and they have no idea which file was related to that Bill.  Although this doesn’t happen much - this is sort of a potential probl

 Looking for a way to have a different check format by branch.  There is a field on the Payment Method that allows you to set the report template for that payment method, so I thought we could create multiple check type payment methods (each associated with the relevant cash account for the specific branch) and assign the check report to each payment method accordingly.In testing this, I’ve found that no matter what I do, it still prints the same check report regardless of the branch, or payment method used.Has anyone ever got this to work?  Or any suggestions on how to get a check format that is specific to each branch? Thanks!  

Hi May i know how many inventory method in acumatica system? As i know is FIFO rules, beside of this ,anything else rule? Hope to hear from you soonThank you

I am posting this to see if there is any consensus about how other companies are handling the following circumstance.  Welcoming all ideas. We frequently see a situation where AP invoices flow into a company with dates from the prior period after the prior period was closed.Example:  November Closed:  Vendor’s bill arrives by mail on 12/03 with an invoice date of 11/29.I believe there are two options here:   Date the invoice differently (like 12/03 (representing the time it was received) and post it into the 12-2023 period. This will keep your GL account and your Aged Period Sensitive Report in balance. Date the invoice with 11/29 and change the posting period to the OPEN 12-2023 period. I believe this will automatically create a difference between your Aged Period Sensitive Report and your GL balance in November.  Making it impossible to balance AP vs. the GL at EOM.Many compa

We have a critical need to get the actual dollar amount that the customer has paid to date on a project so that we can display that value on a project summary report.  We’ve tried to figure this out but whatever formula or string we need to develop in order to come to the number has proven to be elusive.  Anyone have a way to get this paid-to-date number?

Hello Everyone, We are currently looking for a solution/rule/ condition that will allows us to have the invoices created from a project overwrite the default customer payment method to one our choosing.  For example, CUSTOMER RECORD will have DEFAULT PAYMENT METHOD of either ACUPAYCC or ACUPAYACHWhen we create the invoice from Project A, we will need the BANKTRANSF payment method to be automatically assigned on the PROJECT invoices.Does anyone have any ideas how we can accomplish this requirement?  Thank you in advance!

Hi Team,We are thinking of to utilize the “Ext Ref Nbr:” in the Screen Id:AR303000 to store the old customer id, however unable to meet a requirement of to be able to lookup for a customer using the old customer id as an option. I appreciate any suggestions on the approach of possible solutions from the community.Thanks,H

Hi!I recognized a Vendor invoice in the Incoming Documents and the system didn't map the alternate ID at the first time, so I have to do it manually (select the field alternate id and select the correspoding number in the pdf), then, I saved the document. I did this process +25 times using the same format and the system didn't learn the mapping and every time I have to do the mapping manually.I also Rebuild the text index but it didn’t work.How many times the system has to recognize the same format of invoices to learn a manually mapping? p.s. I have a 2021 R2 version in SaaS.Thanks!

When a customer has an overpayment on account can that overpayment be turned into a credit memo?  I need an action to  show the customer the credit on account and remove the payment sitting open.

Error:We are working on importing AP Payments using the import by scenario in the migration mode. However, on releasing the imported payments the system throws the following error: SO Error: Document balance will become negative. The document will not be released. Please find the screenshot attached. A bit of a back story:We are implementing Acumatica software for this client and need to transfer all the data from their software to Acumatica. We have already imported the GL history and thus need to work in the migration mode.  Explanation and Screenshots:Please find the word document attached - Note: There are 5 screenshots linked in the word document. Can anyone please help us with resolving this error?

Hi,I am trying to import GL transactions via import scenarios, but I am getting the following error message: This import is for 08-2023. I was able to successfully import transaction from 01-2020 to 07-2023 a few weeks ago. I haven’t changed my import scenario since then. My import files are consistent with the earlier ones. I am not sure why I am getting this error. Please find the trace attached as well: My import scenario:

We have two warehouses that we buy material directly to. Occasionally, there are cases where we want to transfer items from one warehouse to another to fulfill the demand. Can you set up MRP so it flags you to transfer from warehouse A to warehouse B to satisfy the demand? Currently our system will always tell us to buy additional units for Warehouse B despite having available stock in other warehouse?  

How do I get a report for detailed AR transaction application history by customer? 

Client sells and receives tons of waste products.  We’ve setup a GL account for Tons-In (95010) and Tons-Out (95020) and are wondering how to update these accounts from a release of a sales invoice.  The sales invoice and payables invoices have a value on them relating to the number of tons.  QTY 10 / UOM TON / $20.00 ton = $200.00 invoice.How can we get an automated process to update the statistical ledger based on an AR invoice or from a Sales Order Invoice.  The only solution I can think of is a Business Event that is triggered by the release of a sales invoice and have it create a Statistical JE to Debit 95010 for XX tons that are on the sales invoice.  There is likely more than one line on a sales invoice as well to add to the complication.Looking for ideas.Thank you,Mike

Hi,Our client has duplicate line items on their budget that have been released. I’m unable to delete one/both of the lines (or the budget) since they have non-zero released amounts. I’m also unable to zero out the amounts and release since I can’t save the budget with duplicate lines. Thus, the client is unable to update the budget.

I am having trouble identifying the issue on a Funds Transfer transaction. We are unable to release the GL transaction after balancing because the Account ‘Cannot be empty’ and the ‘Subaccount Cannot be empty’ The Funds transfer has accounts listed.  

Is it possible to sum a range of rows in a Row Set by conditioning on the printing control column?  I would like to sum a range of rows that aren’t Hidden in the printing control column.

For employees who submit a completed cpt30 form during the year, electing to stop contributing to cppsubmit a completed cpt30 form during the year, revoking their previous election to stop contributing to cppFor this two employees what to enter on T4 slips in box 16,26,28Please clarify my doubt 

We have multiple companies set up in Acumatica that shares same vendors. One of the company is sales tax exempt company. Is there a way to exempt tax for the entire company. So we don’t accidently enter the sales tax for the tax exempt company? Thank you.