Financials

Good morning, i’ve recently started playing with Acumatica, and I’m trying to figure out the (sales) taxes for Quebec.Normally, for the rest of Canada I assume, you’d use two fiscal agencies, one for the federal tax and one for the provincial tax. In Quebec, both are handled by the provincial government, so two taxes added at the same time, handled by one agency, which also handles the federal part (and HST) for the rest of the country for Quebec companies. How would I set that up? It can be done using two different agencies both named the same thing, almost, but that’s not the most efficient way to go.I’ve managed to put them under the same agency, but then the taxes amounts are combined in the report, and we have to report the numbers separately, so that doesn’t help either. I’ve only previewed the report however, so they might be separated in the final complete report, but I haven’t made it this far yet. Both taxes need to be in the same zone, and often the same category, but need t

Hi, We just went live to Acumatica, and we accidentally deleted the cash transaction entry type that we had already got some transactions. Now in the list of cash transactions, under the column “Entry Type”, there are “yellow warnings” for these transactions, saying “the record has been deleted”, probably the record on the “entry type” being deleted. We checked the GL side, seems like everything looks good. Can someone please advise whether there will have any significant impact? Thank you.

Hi, When entering a direct sale through invoice I need to take the sales account from the posting class or from the warehouse (other than a stock item)I've tried changing ‘use sales account from the field’ of posting class but it has not worked for me. Is there any possible way to get this done?Regards Amanda 

Hello,I am trying to figure out how to handle a rejection in the Approval map process where it would send an email back to the AP processor notifying them of this rejection.  Also, the AP processor could be one of two people (email addresses). Is it possible to control whom the rejection email gets sent to as well?  Mike

While Posting Debit Adjustment  , multiple transaction entries Showing in Vendor Account , kindly advise where i went wrong 

Hi,I want to calculate the payment/Credit terms based only on the working days. Better if it is based on the work calendar we define.  Is it possible?Best Regards,Dulanjana

Good day. Is it possible to do customer journal from one customer in branch A to a customer in branch B like we do with journal transactions? So far all i can see is that you will have to do 2 separate transactions.I have tried to document the issue in the attached file, hope it’s clear.Thanks!

We are on Acumatica 2022 R2 and use EBizCharge for credit card processing. We have multiple warehouses that may be shipping from the same sales order.When a shipment is completed, we have an end-of-day process that will prepare the invoice for each shipment that was completed and capture the credit card transaction for the amount that was completed (possibly multiple invoices applied to this payment). Our warehouses are 98% able to fulfil shipments same-day unless something is backordered so this works for most orders. Shipments that span over several days, such as backorders, will NOT be able to authorize charges to that same card transaction - the process that runs on that first day will consume that transaction. This will result in the backorder getting stuck in “Awaiting Payment” until the card is reauthorized. During this time, the order is also not considered for fulfillment because it’s Awaiting Payment.If a card is reauthorized too quickly, the bank may not release funds for th

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