Learn
Learn
Support
Support
Product
Community
Partners
MAP
- Marketing Automation Platform

Community
Discussion Forums
Financials

Financials

General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management

2,165 Topics
7,234 Replies

When you subscribe we will email you when there is a new topic in this category

2165 Topics

MReillyFreshman I

Negative values on a PO line? Rewokrs

We are working on a process where we are seeking to take a part already in inventory in Acumatica and move it out of the system to ship to a vendor for rework. Upon the rework the part will be modified by the vendor and assume alternate part number nomenclature. We are attempting to move move for instance part 12345 out of inventory to the vendor and receive part 678910 back as the new modified part. We can easily enter a PO line referencing the new inventory ID which will be received in upon modification but are struggling with withdrawing the current part from inventory. I attempted entering a PO for qty. "negative value" to show the withdrawal of the part but the system is not allowing me to do so. What is the Acumatica advised practice for sending parts out to rework which are already in inventory and need to be withdrawn?

2064

1 year ago

parveza33Jr Varsity III

asked in Financials

How to restrict partial Payments, so that Invoices must be paid in full

Hi, Is there an option or setting to restrict partial payments on invoices and only accept the full amount? Thank you!

1154

1 year ago

rosenjonSemi-Pro III

posted in Financials

LIFO Inventory valuation module - any interest?

Our company uses LIFO accounting, which is generally only used in the United States, however it is GAAP compliant.I am just curious if there is any interest out there for a LIFO accounting module in Acumatica? We will probably write some software to calculate the LIFO reserve for our own purposes. We use dollar value LIFO. Thanks, Jonathan

1869

1 year ago

EvanGVarsity I

asked in Financials

Error: An error occurred during processing of the field Account value 1005 GL Error: Denominated GL Account currency is different from transaction currency.

Good day,The AR Team needed to correct an invoice in our Brazil tenant; All the currency is BRL; transactions, sales orders/invoices. When they tried use the “Correct Invoice” function the below message appeared.It was second occurrence; last time they just created a Debt for the correction. Not sure I can correct it for this invoice but need to correct the “correct invoice” function going forward. 1005 is the Cash Account,Any assistance will be appreciated.Evan Error: An error occurred during processing of the field Account value 1005 GL Error: Denominated GL Account currency is different from transaction currency.

2754

1 year ago

seedcomsupportFreshman I

asked in Financials

Slowly Load Bills and Adjustments in On hold status of a vendor

Dear all,I meet a strange case.Bill is only 1 or some lines and in On hold status. It takes about 20-30s to open detail. And it’s slow for bills of one Vendor, the others is normal.And Also when release it also takes longer than the othersPlease help! Thanks alot!

Hello all, I was wondering if any in the community is using the Shipped not invoiced functionality in Acumatica and if so what their feedback is on the functionality. I am currently exploring switching to this functionality as I do not like the way the system handles SO Order shipments from an inventory perspective. My issue is that we do not invoice an SO until it is delivered to the customer. Which at that point we are invoicing and posting the IN so that the revenue and the expense are posted at the same time. However, with the OTB configuration this process leaves the inventory in the system at the site until it is invoiced when, in my opinion, it should move the inventory from the site to an In-transit account until and invoice is created and the COGS are expensed. So I have been looking into the shipped not invoiced which placed the inventory cost into a Accrual account until the invoice is posted. However, OTB it appears that this Shipped Not Invoiced account does not show up

kstockmanFreshman I

Trying to import AR Invoices from old system using out of the box import scenario. When running the import, the first line of the spreadsheet imports and then I get an error on the rest. Screenshot of the error below. Any ideas?

1126

1 year ago

erinJr Varsity II

posted in Financials

How to system auto send customer statement to individual customer on every month

Hi May i know if anyone know how the acumatica system auto send customer statement to individual customer on every month?Can share with the step of this automation?

104211

1 year ago

jpalyan1981Freshman II

asked in Financials

Corporate Credit Card

How to remove employee credit cards from the bank feed? We have several credit cards that have been disabled and do not have transactions for at least 45 days because employee no longer works for us. Our bank does not have it listed as an account either because as soon as employee leaves the company, we disable and delete that corporate card. Thanks in advance.

1064

1 year ago

atobeFreshman I

posted in Financials

Any Expense Management Alternatives to Advanced Expense Management?

Does Acumatica offer a basic Expense Management Module instead of the Advanced Expense Management? We are looking to implement a third party Expense Software and would like to simply import the transactions into Acumatica. Our current understanding is we need to use AP Bills but we would prefer to have a way to capture/track employee expense transactions separately from our vendor transactions.

1592

1 year ago

afranklinJr Varsity II

asked in Financials

Credit Terms - Second month

Hi everyone,Several of our main large volume invoice vendors are paid once a month (i.e. 10th of month, 15th of month, end of month). The problem is, they are all paid on the second following month (i.e. Any invoice in January is due March 10th, March 15th, March 31). Any suggestions on how to best handle this in Acumatica which only has options for day of next month but nothing for second month.

1164

1 year ago

srengdahlJr Varsity III

asked in Financials

Donut widget colors don't align

I created 4 donut widgets showing sales mix between locations. However, some locations dont have all the types of sales that other locations do so the colors don’t align between the widgets. How do I have each donut widget show all the sales types so that the colors align? Thank you!!

604

1 year ago

jparvezFreshman I

asked in Financials

AR Invoice Due-10 days late reminder

Hello Community, We want to setup some reminder email to customer when AR invoice due date passed 10 days. Can anyone guide me how to achieve this? Or Have anyone setup similar kind of business event? Regards,Jewel ParvezLead ERP ConsultantAlliant Rigserv LLC

2182

1 year ago

charliefitzgerald13Freshman I

posted in Financials

Financial Planning in Acumatica

Are you using Acumatica to perform financial planning for upcoming projects?Do you find Acumatica has sufficient tools to adequately perform scenario planning? Do the existing forecasting tools need additional functionality to fulfill these use cases?Our team is interested in learning how other partners perform financial and scenario planning in the Acumatica environment, and whether the existing functionality is generally considered sufficient.

Account Migration Sage 300 to Acumatica

Hi! We are currently migrating form Sage 300 CRE to Acumatica. We are wondering how can we best translate to Acumatica our Sage 300 CRE Account definition. In Sage 300 CRE, we use a suffix for example: 31000.001 The first 5 digits (31000) - Account The last 3 digits (001) - is our suffix (department, company, project, etc)

642

1 year ago