Financials

When I click ‘Add PO’ or ‘Add Receipt’ nothing shows up even when there are received POs for this Vendor and Stock Item.

My client would like to use Acumatica AR Invoices and Sales Orders and then have the tax calculated right in Acumatica. It would work just like to normal Acumatica / Avalara plug in but it would be for telecommunication tax not sales or use tax. I’ve checked with Vertex and Avalara and neither do telecom tax with their integration with Acumatica.   Also ideas?

Hello,Our controller asked me to post this question on the community. Can you please let me know what he is questioning? Why does Acumatica AP module put a BL as a prefix to the AP ref number?  This is a system generated number that is not manually entered.   

1. Truncated Module Menu DescriptionsSome of the module menu names are too long and get chopped off, making it hard to figure out where to go. Right now, you have to hover over them to see the full text, which is kind of annoying. It’d be so much better if the full names just showed up without needing extra clicks or hovering.2. Misleading Validation in Generic Inquiry FormulasWhen you’re setting up formulas in Generic Inquiry, the validation check isn’t always reliable. It might say everything’s fine, but then you run the inquiry and—bam—errors pop up. That’s frustrating because you think you’re good to go, but you’re not. Fixing this so the validation actually catches problems before saving would save a lot of time and headaches.3. Complex Procure-to-Pay Process and Billing InaccuraciesThe whole Purchase Requisition > Purchase Order > Receipt > Invoice > Payment flow can get confusing, especially with partial receipts and returns. The system lets you bill for the full amo

When our company was moving into ACU supposedly we were told that Acumatica could use per-determined rules to disperse specific expenses into each of our branches.For example:Any marketing expenses will be dispersed via the followingBranch A 29%Branch B 30%Branch C 41%I could not find a way to do this so I am assuming I may need to do this manually?

Hi there team, We have wondered why the Company Financial Calendar doesn't default to the same current open financial year? Rather annoying that we have to scroll to the actual year, rather then just open screen and the open/close periods.  

Hello All, Anyone have the basics for an Import Scenario to do a mass update to the Cash Account on the Default Vendor Location Record they would mind sharing?  Thanks in Advance.

I am having one heck of a time configuring a clearing accounts to use them for bank deposits. I’m using the guide from here: https://fedcoseeds.acumatica.com/(W(29))/Help?CompanyID=Test+March+2nd&ScreenId=ShowWiki&pageid=323644f1-ea34-4377-92bc-c1fcb4a86d05 But I must be misunderstanding something. I created the clearing account: I did not put any entry types.I made sure the clearing account could be use in the Payment Methods  I created a test sales order, made a prepayment using the clearing accountI go to the bank deposit screen and enter the following:  But when I click “Add Payment” I cannot get the clearing account to appear as an option: I’m sure I’m just missing a small connecting piece.Thanks!

Question from client:For the charges that are left after Auto-Match is complete under Process Bank Transactions, every single line will go to the Create Payment tab and I have to click on the Match to Payments tab and click on the Match to Multiple Payments and Match to Receipts and Disbursements options for the leftover charges to show up. Can we set this up to where it will stay on the Match to Payments tab? I will never use the Create Payment feature and when I’m clicking off 400+ charges manually, it gets really annoying that I have to click on so many things just to match the “bank” charge to the “payment”. I looked into this and could not find a way where unmatched transactions don’t default to the Create Payment tab. I looked at Bank Transactions Rules but that did not seem to help. Any suggestions? Thanks,Frances   

HI All, As per best practices  and its Normal and Simple  Process   as per my Knowledge across during the years the following is the Transaction entries which will clear the Purchase Receipt and return Purchase receipt Inventory Account  Dr.Purchase Accrual Account Cr. Return Before Invoice / Bill Created Purchase Accrual Account Dr.Inventory Account  CrBy this  both the account get cleared  and reconciled as well. if its Partial return Yes the balance remain  and  which can be cleared by Bill as its not retuned  As per the Functionality of Acumatica we need to create a AP Bill and a Debit adjustment for any return ?? though both PR and return has been Processed both Transaction remain uncleared in the accrual Account why this is required  and the logic behind this Functionality ?   

I have a PO that was setup with the wrong Vendor.  I received an invoice for the PO and created the PO Receipt before I realized that the Vendor was wrong. I did a Return of the PO Receipt (essentially nullifying the POR).  This Return actually created a second POR which reversed the first one, so all items on the PO are back to “un-receipted”. I want to correct the Vendor on the PO but since there is a link to to the “received” POR and the “returned” POR, the system won’t let me change the Vendor.  I get an error message saying - “You cannot change the vendor for this purchase order because it has purchased receipts linked.”Is there a way to remove the link to these two PORs to the PO?

Please kindly advise how can set up Tax type from VAT-to-VAT INPUT and GL Account Mapping has 2 Types to only Tax Claimable Account Requirement in System.Thanks for help and supporting. 

Is there an issue with copying fields over to an asset when converting from a purchase? The only information that gets pulled over is the receipt number which is not even going into the correct field. Do end users have to go into every single asset to manually enter the receipt type, PO number even if they create the asset through the Convert Purchases to Assets process?   Your input is greatly appreciated. Thank!

Does anyone have experience integrating Procore Pay with Acumatica?  I’m interested in hearing other people’s experience with the implementation.

Please kindly give me the sample to customize the Report P&L Actual VS Budget has add more Variance Amount. Thanks for your support and sharing 

Hi,I've created a custom export scenario for BNZ Bank in New Zealand and mapped it to the payment method NZBNZDD. This setup is configured for exporting batch payment files from the AR module for direct debit processing.The setup appears to be correct, but for some reason, I'm encountering the following error:"An error occurred while trying to retrieve 'Unique' part from specified."I'm unable to identify the cause of this issue.  Does anyone have any insights? I've attached the export scenario and error log(SQL Profiler) for reference. 

Good day,  I have question.  Basically it is confirmation.  We have set up the Worksheet ID with all accounts either set up as YTD/PTD.  When we run the translation the 35000 accounts comes out as a GAIN/LOSS.  35000 is the account on the currency as the translation  Gain and Loss Account.Is this the reason why the translation changes the Translation Method? I have to explain this to the CFO.  Or there a set up issue?  I believe it overrides the translation method on the worksheet because it on the currency GL Accounts.Thoughts?  Confirmation.  I can’t fine anything in the documentation about this.Thank you  

HelloFirst, I’m sorry if someone else asked this before, but I didn’t find my answer.My company has an excel file where we do this for all plant and 3 separate branches:Orders $ Sales $ Scheduled sales $ Total backlog $ Total past due $ # Employees Weight shipped The file has other columns as well, but this is enough for an example.There is some math behind those columns, taking the total from a week or the total from a report, for each branch.Is there a way of creating this in Acumatica? What I do today is filling the excel with the results I take from Acumatica. Thanks in advance, have a good day.

Hello Guys Can you help me with these issuesuddenly had rounding diff. the first picture is correct but the 2nd picture had rounding diff.     Thank you 

We are new to Acumatica and trying to wrap our heads around how branches and subaccounts work. Our use case is this:One company, one warehouse with inventory. We sell B2B, B2C - Shopify, B2C - Amazon. We would like the ability to run a P&L based on sales channel and by product line. For example: P&L for B2B channel for product line X. From what I understand, only one subaccount can be used per line so we would have to choose whether we want to classify the line as a channel or a product line. I think if we create combined subaccounts, where channel and product line are combined, it would create major difficulty in data entry, along with preventing us from running a P&L based on just product line or just channel. Would adding a branch for each sales channel make sense? Then each transaction would have a branch and then a subaccount for the product line? Again, we would only have 1 warehouse shared across the company, so I’m not sure if this method would work. Happy to hear s

I was in the process of reconciling a Credit Card and the Reference Number generated matched, for some reason, a previous reconciliation statement for a different cash account.Now the process is locked into a cash account that is not correct, it will not let me delete the report, and if I create a new one it tells me that the previous statement was not reconciled. Also, the transactions disappeared for that time frame and I have tried everything to get rid of the incorrect reference number. Please help!

Good day Community I have a client who has been calculating their depreciation on a spreadsheet for years and now want to use Acumatica. Here is my challenge - in 2021 they changed the useful life of the assets from 25 to 40 years. In 2023 they increased the value of the assets. I imported the assets in the current financial year in initialization mode, including the YTD Accumulated Depreciation. Most assets have been depreciating for about 5 years, 2 years @ 25 years and 3 @ 40 years. I am really struggling to assign them useful life years that would calculate at the correct rate.  If I use 40 years, it reverses a portion of the Accum. Depr so that the remaining amount is over 40 years from day 1. If I use 35 years and amend the start date to the current year, the calculation is correct by month going forward, but it amends the Accumulated Depreciation YTD that was imported.Any advice as to how I could get the system to calculate the correct amount going forward without changing the t

Is there a way to produce statements by customer locations and also being able to send them via email based on the email field within the customer location? 

Best regardsI have currently set up the Integration between Acumatica and Salesforces. Importing the information from Salesforce to Acumatica is not a problem for me but when I want to export the information, I have in Acumatica for Salesforces I continue to get the following error: INVALID_FIELD: There is no such column 'Acumatica_NoteID__c' in the Account object in Salesforces that column is already configured, any idea of what it can be?? 

I am on 2024 R 1. I am trying to correct invoices that were created with he incorrect tax amounts. I have created a Credit memo but receivng error message  “ Error: 'TaxBucketID' cannot be empty.” when I try to release.  Where is this Tax Bucket ID located ? The trace only states “