Financials

Hello,I am in the process of setting up several new companies for demos. We would like to set up an undeposited clearing account for AR payments. I am not clear on how this works in Acumatica. I found documentation on how to set up the accounts, but what is the actual processing to resolve the undeposited funds account?1.How are the funds moved out of the undeposited funds and where to? 2. Is it before or after the bank reconciliation? 3. How are check batches deposited? 4. Which account is actually reconciled with the bank reconciliation?  Please help me get a clear picture of this process. Thank you,Barbie Jeter

Hi all, I need your help.Our Finance Manager has provided her digital signature to be used on A/P checks.  The signature does not appear on the checks.  Any and all help would be appreciated.  Thanks.Bill  

Looking to build a trial balance report that shows month by month balances for each account. Anyone know how I can create this? Ex.  

Morning All, This transaction was allocated to the wrong account. How do I rectify it to be allocated to the correct account. 

If I have only one line item on a sales order, can I have two salespeople on the sales order?

Hello,Looking to create report similar to the Vendor transaction summary, However i need for Customers.With Invoice dates, paid dates & Amount.

Hello,We have a new employee that started.  They entered an AP bills that was suppose to be on a recurring schedule.  The invoices slipped through, approved and paid.  Now that the recurring invoice is off schedule, whats the best way to get it back on schedule, and is there a way to tie the accidental invoice back to the recurring to get it back on schedule? As you can see the dates are also greyed out and unable to be changed.  I assume i can run the schedule and just delete the invoice, but that still leaves a whole in the generated documents list. Thanks,Jeremy     

How can expense claims be enabled on our platform? I read that we will need to enable Expense Management from the “Enable/Disable Features” screen, however this option is not available.  Similarly, the “Time and Expenses” page has very limited options.    

Were exploring using the employee time card function so we can get our labor costs to hit our projects on a timely basis. Can someone please advise how we they have been doing it?

I am setting up a new tenant on my production system but when I went in to create the Master Financial Calendar, it set the “Start Date” to April 2nd, instead of April 1st and now the ENTIRE financial year is off by a day.  (see screenshot)How do I correct this so that all of the periods match the months correctly??  (I HAVE to correct this before I can activate any of the periods.)As you can see from the screen shot the Start Date is greyed out and I am not able to manually change that.  

Hi, I’m wondering why I’m getting an saying SO Error: The document is out of the balance in the Bills and Adjustments screen. I’m not sure on what to do to fix this error.   

I need a margin report (like the sales profitability report) that includes our freight/delivery costs.Our sales prices are delivered prices and don’t include the delivery price charged to the customer.At present, I am using a generic enquiry linked to excel, and then manually allocating the freight/delivery cost manually.What’s the best way for me to automate this process??I was thinking of using a custom field during the A/P entry for sales order, and then somehow linking this to a new generic enquiry.Wanted to check that Acumatica doesn’t do something like this out of the box…..I have attached my excel report headings...

We are scheduled to go live with Acumatica in the next few weeks. We have been working in a sandbox tenant of the software and want to make sure all our settings are correct before fully switching over. In our Warehouses in the sandbox, certain GL Accounts settings are mandatory, but in the live tenant they aren’t (both screenshots below). Any ideas what settings/data/other would be forcing the sandbox tenant to make these settings mandatory when they aren’t in the live tenant?Thanks 

HI, All my contracts are created hat when I run the contract invoicing, I get billed at the end of the month. We want to change and charge at the beginning of the month. How do I make this change?Thanks to help me. Melanie

Hello! So I understand Acumatica can send out AR Invs/CMs in mass, by email, which sends 1 email per every 1 document. I also know if we multi-select and then go to Print, we can send out multiple documents combined into 1 pdf, with 1 email. These options are great, however there are certain clients who would instead prefer to see multiple documents split up into 1 email. Do anyone know if there is a way to do this?

Hi,Is it possible to show the details of the note in the “Bills and Adjustments” summary screen as a separate column? At the moment, I have to click on the Note icon to see the details.Thank you.Regards,Raymond

Good dayI am trying to add additional filters to an AR Aging Report Template that is specifically for certain Customer Classes. It also adds and excludes certain customers from a different class.It worked before I tried to add additional customers, but no longer does.Is there a specific order that these filters must be added? Or are there too many criteria?Customer (alias).Customer ID EqualsCustomer (alias).Customer ID Does not EqualCustomer (alias).Customer Class EqualsCustomer (alias).Customer Name Does not ContainMany thanks in Advance 

Hi,Could please let us know that how add “Re open” and “Unlock” option to the manage financial periods form. Currently those mentioned options are not available.Thank you 

Hi. I have an issue in my report(Non PDF version) when converting into PDF version. Here i’m getting a value for the part number which has a quite long value. When i convert this into the PDF version, the full value doesn’t display as shown below. Is there any solution for this? I have set CanGrow to ‘True’ as well in the report designer.PDF versionNon PDF Version 

Client is running Device Hub to print checks on 22.212.0046. Recently (and intermittently) when printing checks by company (has ~130 companies in one tenant), the checks will print for 2 separate cash accounts in the same run. i.e. client prepares checks Company A for cash accounts CA-1 and CA-2 . Switches to Prepare/Print for CA-1 and clicks Process, the checks for both CA-1 and CA-2 print with the number sequencing from CA-1. They’ve been live for a year and this started 3-4 weeks ago, but frequency appears to be accelerating and affecting different companies. There is a customization, and I intend to restore a snapshot locally, unpublish and test, but wanted to see if anyone had seen something like this before.Thanks.

We noticed that when a payment is being created and the payment method needs to be changed, the next payment to use the Check payment has moved forward to the next check number despite not using it on the previous payment. Screenshots start with payment to vendor and check 3339, changed to fedwire. The next vendor is set up to be paid and the check has skipped the unused 3339 and moved forward to 3340.Has anyone seen anything like this?

Hi All,Kindly assist, every time when the customer uses the write off function, they get the below error, GL error: the transaction can not be released because the currency of the ledger differs from the transaction base currencythxDries

Ever since we upgraded our Acumatica to Acumatica Cloud ERP 2023 R2 Build 23.205.0011, We have been unable to convert requisitions to POs. How can you help us?

Hi There,Is there anyway that MYOB can show the actual Batch Payment as a one line in the bank reconciliation screen as opposed to it showing individual invoices that we have to match against every time?It used to do this and it doesn’t seem to anymore?ThanksSara

When you have one corporate credit statement, but each salesperson has a card under this umbrella, e.g., the last four digits of the card are different, do you still create one corporate credit card and add each user to this master card?Or do you make a separate corp card for each user? Then by pointing to the same cash account, will all cards end up pulling into the one credit card statement for reconciliation?Thank you.