Financials

Hi,i would like to check in below scenario, what is the best way to record the transaction. The original purchase cost for product A is $100, we purchased 50 pieces, did purchase receipt and posted vendor bill. and we sold 40 pieces by end of the month. On the last day of the month, vendor will review our sales and give us a rebate for Product A, lets say is $20 per piece for all 50 pieces. so our cost for product A become $80. The problem is we already posted the purchase receipt and the cost of $100 is used as COGS, our sales person commmission is calculated by profit, so is there a way to adjust the vendor bill and re-calculate the profit for sales transactions already posted. Thank you

I need to print Customer Statement on demand and want to create an import scenario for that.I created the one below (attached the xml) but it is not working. Our version is 2022 R1. 

Dear Team, I would like to know whether we can do multiple fund transfers in Acumatica. An example scenario is as follows. Source Account: HSBC 788Source Amount: USD 10,000 Destination Account 01: HSBC 544Destination Amount 01: USD 5,000 Destination Account 02: HSBC 533Destination Amount 02: USD 5,000

Hello,  we are new to Acumatica, & are trying to figure out how to add a miscellaneous cash receipt to a bank deposit. For example:  We periodically will receive a rebate check from a vendor, that I would need to record as rebate income. I want to add this to an existing bank deposit that contains payments on account from customers.

We just noticed that when creating AP Bills, you can enter the Qty and the Unit Cost, and Acumatica will calculate the Ext Cost.But, I can go to the Ext Cost and modify it and will allow it too even the qty*unit cost does not match the Ext Cost. I can move forward and release it. If this the expected behavior or is there any configuration I should do to prevent it?   

Hello,I can find no documentation on the sales profitability reports calculations.Is there any documentation on what costs are included in the calculations?This is specifically being asked in a manufacturing environment.This is the specific request “I really need to understand is the sources of inputs to equal the cost field when then determining the customer margin value in the system. ” 

Hello Acumatica community! :)Prior to Acumatica, we used Timberscan with Sage300 and could report out of Timberscan with various parameters to get a summary of invoices with all relevant attachments as one file - a pdf.  I have a need to do this in Acumatica and cannot figure out how.  Do any of you have suggestions? Thanks for you time.Kay HoweJackson, OH   

Hi,When we do group consolidation, can we perform unrealized profit eliminations, goods in transit entries, and intercompany eliminations in Acumatica?Thanks,Dulanjana 

Hi Team,I just want to ask if there is a control or set up for the minutes of automatic logout in Acumatica when it is not used? or should you give me an article about the behavior of the system regarding the automatica log out even the acumatica is still in used.? Thank you!

Hi Team, Currently, I am testing Projects with Revenue Recognition for Progress Billing. Created a Project and activated. It includes Revenue Budget and Cost Budget. For the Revenue side, I have created an AR invoice which gets posted in “unrecrev” Account group (Liability). Now I have run the “Run allocation by projects” to allocate the income to the project.I got the error - PM Warning: Transactions were not created during the allocation. When I click on the process button. Kindly suggest on the missing steps.  

How do I set one of my companies as a default? I don’t like toggling every time I log in.

Is it possible to pull existing customer profile IDs from Authorize.net into Acumatica? We have a large database of customer information already held on Authorize.net that we'd like to import into Acumatica, and we'd like to retain their existing profile IDs for continuity. Has anyone else done this before, and if so, what steps did you take to ensure a smooth transition?

I discovered that AP Document Recognition will do 3 way match if only a single line in the invoice, however it fails to match on additional lines with different POs.  For companies that receive invoices with many lines for many POs, this functionality is critical.Please vote for this product idea.Thanks,David Eichner, CPA

When will the new integration, announced with 2020 R2, be available?If it already is, where do we find related documentation?

Hello Experts,I have been trying to import the COA from Xero Accounting software to Acumatica ERP for learning purposes. In Xero software, they have a column for Tax Rates which the users can set for each Account ID, so how can we map this Tax Rate in Acumatica for each Account ID. Thank you in advance

We imported AR amounts in migration mode but with no balances. and it’s not showing in our aging schedules. The invoices show as closed. How do we correct? 

How do I find out the source of the system foreign exchange rates in Acumatica.  I have searched but are unable to locate.  I need to provide to our auditors. Any help much appreciated.

Hello, For our company, we have two employees with the same roles in Acumatica that need to be able to edit expense claims before they get approved. To do this, they put them on hold first, which I believe to be the correct process. However, one of the employees has the on Hold button available while the other does not. Does anyone know where/how to set up the users to have the same options available for expense claims?  Thank you!

Good day.I understand you can create order types. Is it possible to create invoice types in addition to Invoice, Credit Memo etc.Many thanks,EM.

Hello all,Looking to see if it is possible to change future financial periods. Currently our Financial year runs from April - March and that is how the system is configured. One small change we would like to make is the financial year naming. ie currently in the system we are financial year 2022 with monthly periods running from 4/1/2022 - 3/31/2023. For these periods we would actually say this would be financial year 2023. we use FYE (financial year ending) 2023 for the year we are currently in, but acumatica is set up as year 2022. Understanding I likely can’t do much for current and past periods I was wanting to start the new fin year off correctly.So starting 4/1/2023 I would like to create a calendar that lists that year as 2024 with the periods running from 4/1/2023 - 3/31/2024. I believe this means in the system there would be no 2023 fin year as I have been told we cannot rename the current year/periods.  Hope that made sense, in the end we really just want to change the Year l

Hi All,We are having this issue when updating the ClassID during event Location_CBranchID_fieldUpdated.Basically we are trying to update the ClassID value in the cache for BAccount.Code Snippet protected virtual void Location_CBranchID_FieldUpdated(PXCache sender, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler)        {            if (e.Row == null) return;               var classId = Base.BAccount.Current.ClassID;                       //Exception is thrown here..             Base.BAccount.Cache.SetValueExt<BAccount.classID>(Base.BAccount.Current, classId);           Base.BAccount.Cache.SetDefaultExt<MAKLBAccountExt.usrMAKLCuryID>(Base.BAccount.Current);        }        DAC        [PXSelector(typeof(CRCustomerClass.cRCustomerClassID), DescriptionField = typeof(CRCustomerClass.description), CacheGlobal = true)]        [PXUIField(DisplayName = "Class")]        public virtual string ClassID { get; set; }Stack Trace :PX.Data.PXSelectorAttribute.throwNoItem(String[

Hello experts,I would like to have guidance from you as whenever we are about to deploy a new instance, the first configuration to be done is from the financial module. But how shall we configure the financial module from start to last? I would like to know the steps. Thank you in advance.

Please could anyone confirm the behavior of the report AP Aging?Bills that are open but attached to a voided check disappear from the report.Example  and screenshots of a few bills - 000556, 000291 

What is the simplest way to enter a misc cash deposit? The credit would be a revenue account.

"An error occurred during processing of the field Depr. From Period: FA Error: The book calendar corresponding to the start date of the asset's uselife (2/7/2023) is missing in the POSTING book. Create calendar on the Generate Book Calendars “ Added Info: the life of the Asset Class selected was set to 2 years Here’s a screenshot of the error: Set-up for Calendars: