Financials

Good day,I have multi branch/company environment.  I have a new Canada Company starting shortly.  Based on what I read so far is the CA Company needs a based currency of CAD and a separate ledger.  All the CA company transactions will be done in our CA Company, separate customers, vendors, etc.  Also a new cash accounts.Ledgers:  Do I need two CA Ledgers:  One for Actual and One for Reporting? Translations:  I need to be able to report in CAD and consolidate/translate into USD for consolidated reporting.My overall needs are to have CAD reports for taxes and Consolidated reports for Overall company financials by branch.Thank you in advance for your assistance.Evan

Is there a way to remove the page break on the Trial Balance Summary?  Ours currently prints on 3 half pages.  That is a lot of wasted space and paper.

One of our customers had 2 invoices for the same customer that had the same cash discount date. A payment was created to completely pay both of these invoices.The payment was within the due date but outside of the Cash Discount Date. The payment still applied the cash discount.I have tried to recreate this issue with the same vendor but cannot. It calculates the total correctly even when I change the payment date. I went through their old payments and the majority are correct but I did find one other that had the same issue.Any idea what circumstances could be causing this?

Please kindly advise about Approval Map that Entity Type has only 2 types. Thanks so much  

Hello,  This is a general FYI. I have found that the SOInvoice.PaymentAmt field is calculating the total balance of the SO Invoice, rather than the Payment Total applied to the invoice.  I created a scenario in my local environment shown below.  The SOInvoice.PaymentAmt and SOInvoice.CuryPaymentAmt should both be 100.00 to reflect the payment amount applied.   

Has anyone had experience in adding a discount on an invoice when using Avatax to calculate taxes?  We are testing and the discount is showing in Acumatica but it is not passing to Avatax.Has someone been successful in using discounts?Thanks

Hello,I have an AP Bill which pay by line is ticked. The Bill has been reversed and the debit adjustment is created.Then I’m trying to apply it against the bill by the payments and applications from. Since it needs to be applied with the type payment, The payment type is selected and the Debit Adjustment is loaded in the line. But The bill does not show any available balances to apply. But the bill is still open, the lines show the balance to zero. There are no any other applications as well.I tried to recreate this but I could not recreate this as well. is there any specific reason for this behavior. Thank you

Hello all,I have a list of bills that have been imported into migration mode, as I dont want the GL to be impacted upon release of bills but I want the payments to be recorded against these bills and that the payments should be impacted in the ledger. How to do so? Thanks.

Hello all,I have been trying to import or create first AP bill with a negative balance in MIGRATION mode. But when I try to either import or try to create manually, it triggers the following error: What are all my options to get this done?

HelloWhat operation should be created to reflect the following:- I have a prepayment for 200- The employee deposited the refund for 250.- I can create a vendor refund for 200How can I register the balance of 50?

Good afternoon,If I were to cancel an item on the order or zero it out to update the order total...is there a way to have the “Applied to Order” on the Payments tab auto update to the new unpaid balance or order total without manually having to adjust?  Thus creating a “Balance” as well on the payment tab.

The reconciliation is balanced and ready to complete but the Release option is disabled.  There are closed reconciliation statements for this cash account dating back to 2023 and this is the first time we have encountered this problem.  Any thoughts on how to move forward?

Hello!I am required to identify Whether the Invoice has been Reversed from the Invoice itself. The created Credit Memo has the connection saying that this is based on the Invoice but there is no visible information from the Invoice mentioning that this has been reversed. Is there any way that I can take this information from?Amanda 

Hi Acumatica Community, I have a COGS versus revenue gl/subaccount problem.We want to have one branch. Think of our finished good product mix as follows:We sell road bikes (some battery powered) with a various set of product lines. We sell off-road bikes (some battery powered) with a various set of product lines. Many of the component parts and some of the finished goods are interchangeable for the road bikes and the off-road bikes and we have them all in one warehouse.Of course we would like to measure COGS versus revenue.We have decided to have our order entry staff select a customer location which will then identify the subaccount for revenue associated with the product line.From an inventory posting class perspective, we are not sure how to set-up the posting class so that for a given sales order line, the inventory transactions and the light manufacturing are associated with the same subaccount.Thanks, Patrick

Is an item number required for all Deferred Revenue?  We are testing using the Deferral Codes on intercompany rent AR invoice where we are billing the next month’s rent in the current month, but ACM is requiring an item number for that.  We would prefer that we just be able to enter the Revenue Account we want it to go to without having to create an item number for it.  Is that possible?

AP Doc Rec...incoming document recognized...non-inventory lines added to the detail with only a line description and an Ext Cost...upon “Save and Continue” the detail lines do not carry over to the bill and have to be reentered.Question...should the detail lines be carrying over? Am I missing something required in the lines?

How can a mass update of Vendor payment type be done, if at all?  Import Scenario? Generic Inquiry?Several vendors were set up with this informaion missing and instead of opening and updating one by one hoping a mass update can be done.  I am new to working with mass updates in Acumatica so any and all help/instructions is greatly appreciated.

I am trying to Update the below columns using Import scenario. Unable to find the correct mapping.  

How to prepare Generic Inquiry Cash Flow Statement by Month?

Hi thereMy company is looking into offering payment plans for large sales to our customers. For example, a customer may wish to pay off a $10,000 sale over twelves months.Is there a way to set this up so they are invoiced $833.33 each month for 12 months? Preferably under the same invoice number. Any help would be greatly appreciated.Kind regards,Bradley

I’ve found several entries here for this, but haven’t found a solution yet.Requirement:Enter Start and End Period (can be anything up to 12 periods and can cross fiscal years/calendars) The data in each period’s column display just the turnover for that period (not the ending balance at that period)I have found good formulas to suppress printing periods not in the parameter selection. However, I cannot figure out how to get just the turnover for that period when I use a start and ending period in the parameter. Thank you in advance!

I’ve gotten feedback that percentage complete revenue recognition functionality imbedded in the Acumatica Project Accounting module defaults to calculating revenue at the project task level. I have always seen those calculations done at the total project level, in large part because project billing milestones don’t line up neatly with budgeted cost line items. As such, I am surprised that Acumatica defaults the calculation to the project task level. I’m wondering if I’m missing something. For anyone who has implemented percentage complete revenue recognition automation in Acumatica, are you doing it at the project task level, or the total project level? 

Hello community, We would like to know why our YTD Net Income Account does not move to Retained Earnings for the start of the new year?  See below, this is from the Acumatica website, on what is supposed to happen at year end and the start of the new year.  Ours is not doing this, how do we make this happen as the system is designed to work? Based on this article... Thanks in advance.

-I am trying to do as the book guild and video. I am testing it many times but it still the same error. why in the video and book, it shows can import. Please advise why I am can't do. -If all of have the excel file sample about AR, Customer, Vendor that can import successful in system May I, have it? because I have customers that need to import excel file to show them for demo in the next week. Thanks so much

We just upgraded to 2024 R2 last night.  We drag invoices into the Incoming Documents screen.  In the upgraded version, we can’t drag in the invoice.  Nothing happens.  Has anyone else experience this or have a fix?I tried disable / enable AP Document Recognition Services and that didn’t fix the issue.