Financials

Is it possible to set the business date in an automation schedule? Invoices are prepared using the process at month end because consolidation of sales orders is necessary. The volumes are high and when users run the process it may fail when it gets over 1 hour, resulting in no consolidation. So running the prepare in an automation should take care care of this. However invoicing does not start until day1 of the new period. Users set their business date back to ensure correct invoice date/period, hence the request. 

Good morning,I am curious if there is already a report in Acumatica available that would show me an accurate AR aging for customers.I currently utilize the AR Aging Period - Sensitive report...but that will give me customers that still have open orders on their account, thus creating a “credit” on their accounts on the report. I would like to see a report that just shows invoiced customers basically...is there already a report available or have you found that you need to customize a report? 

I am just learning Acumaitca Payments and trying to document the process for our customerAt the very beginning of the documentation it says  “contact the Acumatica Payments sales team”Here the link where that is found…https://help.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=7f8613be-52c8-444a-9048-dcaece4aaad3How do I “contact the Acumatica Payments sales team”  or does the end customer do this ?  

Hi All, I have an ARM P&L report that is using unit sets that allows selections by Company and branches.  The report is structured to enable the selection of accounts by sub accounts. However, the headings are only printing the sub account code (which is meaningless to the recipient| and the site have 90 sub accounts used for reporting). Is there a way that I can get the actual sub account description to print  in the heading as shown below (where administration is sub account 09) and North Shore, Warkworth etc is the branch name.Below is what is actually printing.Any advice would be much appreciated.thanking youSally

We make use of a few branches, and our setup is done on several subaccount levels, I want to find out if it’s possible to set up rules that will accommodate an employee of a branch, to book transactions or time on the same branch but a different subaccount and then allowing the cost the be transferred to the subaccount used. 

Hello!Is there a reason there would be a balance left in my deposit clearing cash account after i have already done all the deposits and “cleared” the cash out?Any help would be appreciated! :)Thank you!

Hi,Do you know how transactions are picked into the “Reconciled Documents Dated After < Reconciliation Date> “ . And how can we fixes the difference? Appreciate your help. Thank You,Dulanjana

I want to use the Unit Rate to allocate billable expenses to a COGS account but the Unit Rate does not get pushed to the Project Transaction. I can’t find a “Known Issue”.  Is this standard Acumatica?  

When you export reports from Acumatica to excel, the headers of the report are repeated at every screen break.  How do you stop these headers from repeating in excel?  There are no page breaks in the column sets or row sets.  This is something that annoys many clients, as they have to manually remove the headers from the excel file every time they export a report.

Hello all,I am wondering how we can configure the system Purchase Order/Receiving/AP Bills to conditionally calculate tax or make exception based on the Company/Branch buying from a vendor? Vendors profiles are shared between all companies but some of our companies have tax exemptions, and some don’t. So, when we purchase stock/nonstock items using PO to AP or direct AP Bill, depending on what company/branch is the buyer, taxes should be added to the items or be exempted. How can we do this?

Could someone please advise how to update the default Vendor GL information in the location table?I have 650 records that need updating!Thank you.

Hi!  I just took over AR and can’t seem to find an “easy” Excel report for my AR Aging.The ones I have pulled don’t have the Vendor Name on the same line as the invoice detail.  Does anyone have an easy solution?Thank you so much!

Hi Team,Is there any report which can be used as GST return and schedules within Acumatica? One of our client’s need to get the GST returns and the relevant formats from Acumatica. Is is possible? Where to get? Thank You Yashodha

Hi All,This may be something I am just missing or having a moment, but when I am trying to show an Account on a Balance Sheet and I put just Description, it is still giving me the Code. Does anyone have a way to get the code off the reporting, I want to show only the description? 

I think I’m not understanding the logic of the Process Invoices and Memos screen (SO505000) First - From the wiki, the only prerequisites mentioned for using this screen are:Email Invoice: Sends the selected invoices via email. The document selected for processing will be emailed only if the following conditions are met: This document has not been emailed before (the Emailed check box is cleared on the Invoices form). The customer account has the Send Invoices by Email check box selected. The Credit Hold check box is not selected for this document.  However - we are seeing that only invoices in a Balanced Status can be emailed from this screen. Once the invoices has been released, your only option to email the invoice using a process screen is from AR508000 This appears to be intentional, although not documented well in the Wiki. I have a hard time understanding why we could only send unreleased SO Invoices or released AR invoices Our issue - we would like to email the SO invoices da

Hello all,I have been looking out for ways to find out the list of the transactions/master data where a specific subaccount has been used. How can I get the list?Any suggestions?Thanks.

I think I need to create a new column set but don’t know how to set up the formula so that in one single report I can view an actual vs budget. Also, not sure if I am able to do this in the ARM reports?

Hello,We are trying to set up a process in Acumatica to send our customers a Courtesy Reminder 7 days before the due date. Initially, we considered creating a Dunning Level with a negative Due Date value, such as “-7,” but it defaults to 30 days, and it seems that the Dunning Level feature does not work with less than 1 day.We understand that another approach could be creating generic inquiries and using business events, but we want to confirm whether the Dunning Letter feature is intended only for overdue documents and not for those approaching the due date.I would appreciate any insights you can provide regarding this procedure.Thank you! 

Our clients use segments for a variety of things, customers, projects, product etc,When they add a new value to the segment they have to go into the segment value screen and make the entry.This is dangerous as all segments are available and they could make accidental changes.Moreover there is a great efficiency to be had by declaring that at segment refers to say projects or a customer class or a product code for example, and then have the system insert the segment whenever a new project./  customer class / product is created.Thanks 

Hello, We’ve recently moved to Shopify for POS and ecommerce. We’ve created discounts in Shopify which gets discounted at the line level.   However, we have the connection set to Order level discounts when syncing into Acumatica because the Line Level discounts do not link back to the Inventory ID’s when discounting at the GL level.   The issue now is when we have an order come through with a discount AND an item that is taxable. Acumatica order discounts don’t reduce the taxable amount of the item fully, but in Shopify the taxable item was discounted correctly so the taxable amount was less.  Any recommendations on how to resolve these discrepancies? Thanks!

Hi All,Is there a way to add AlternateID column to the  "Add PO Receipt Lines" Dialog in AP Bills? The screen looks like a GI, but probably not.  I am a beginner with customizations.  I located the screen and dialog box in customization and it looks like AlternateID is not one of the fields available.  It appears that a view is being used to populate this.  We are a SaaS customer, so I do not have direct access to it.  Any ideas on how to proceed?Thanks in advance. 

Hello all,I have been working on process bank trxn and bank transaction rules and have been trying to create a rule.I have 2 transaction descriptions:ABC TestABC 123So now I have created a rule for ABC Test description and when I clicked on apply to all, the rule is getting applies to ABC 123. Now when I try to create a new rule for ABC 123 then also the rule created for ABC Test is getting applied.How can I resolve this?

Every month expenses are accumulated in an account/subaccount combination that identify an expense account and cost center in which equipment repairs have been performed. At the end of each month these equipment repairs are to be reallocated, to a fixed set of 5 account/subaccount combinations. The allocation percentages will depend on the source cost center and will be on a different percentage basis, depending on the percentage of time spent working on the equipment for respective departments. The desire is to build a history of allocation rules, ideally by using a statistical ledger with the different allocation percentages.I can't figure out how to have a different set of percentages apply to the allocation from each source unique cost center when the destination accounts/subaccounts are constant without building a different allocation for each source/cost center;  that could number in the dozens or more VERY quickly    

Our company uses the RR order type for RMA’s. We create the Receipt line item and the Issue line item.Sometimes the issue line is sent before receiving. This makes it unknown if the repair is covered under warranty until after we receive the equipment back. There should always be an option to create an invoice after the evaluation is complete. However, when its covered under warranty, no invoice is needed.The question is that all shipments are left open and waiting for the next step of prepare invoice. How do I select that no invoice is needed and close the RR order? 

Hi All,Is there any way we can update or change the salesperson of a released invoice without cancelling that invoice and re-issuing a new one?