Financials

Hi, we are adding a new subsidiary in the system and need to upload the open GL balance of both income statement and balance sheet. Is there any step by step guide that we can follow? Is there a template we can use? Any specific GLs that we cannot upload directly? Thank you for your assistance.Regards,Aaren

Need to any sample pivot or matrix reports.

Hello everyone! I have a client who’s primarily service oriented, and on certain service orders likes to collect payment at the following steps: prepayment of 50%, 25% at job start, 25% upon completion. This can be done in project accounting I believe, but seems excessive for their needs. When I looked at credit terms that you can tie to service order types, the installments were based upon days.  Is there any way to accomplish this without having to create a project to handle the service order? 

Has anyone been able to get Divvy to work with Bank Feeds?  Our client purchased Bank Feeds and they use Divvy, but Divvy is not an option under Plaid or MX.  I researched and found that Divvy uses Cross River Bank, but the client was unable to setup using Cross River Bank.  Is there a way to get Divvy to work with Bank Feeds?

Hi, I created a 12 month Financial using a formula to print only the date ranges selected. Here is an example. However, I need to format the totaling column so it only pulls totals for the date range selected and not for all the columns. Second screenshot shows what I have setup in the column set and it’s a static formula. Can anyone let me know the formula to use to pull totals for the date ranges selected. Note: I do have a IIF statement so I can run the report by a certain date range. Thank you,Frances Pantelidakis    

Has anyone been able to setup Divvy in Bank Feeds?  It is not an option whether choosing Plaid or MX.  I researched and found that Divvy uses Cross River Bank, which IS an option, but we have been unable to setup Cross River Bank using their login info.  Thank you in advance for your input and suggestions.

Does anyone know of a plugin/bundle that enables Acuamtica to provide financial reporting the likes of which you see by default in programs like Quickbooks, PeachTree, MS90, etc?  

It looks like they are set to print with the Acumatica Ref # order.

When I run customer balance report and my invoice show in that report and I check this invoice never ever payment apply to this invoice. But when I call this to apply with payment, I don’t see it in payment and application. Do you know what’s the root cause of this problem.

hello,Curious if anyone has had a unruly customer that demands an invoice be delivered in a certain manner?!We have a scenario where we have a stock item (ST100) that needs custom design.  for that we use a non-stock item (CD101) as a separate line on the SO because we do not print in-house and have to push this line to a PO. When we send the invoice to the customer, they want 1 line that aggregates the pricing for both of these.   our challenge is that it’s not always clean as a 2 line SO. Sometimes we have multiple Stock items (ST100, ST200, ST300) and 1 non-stock print item (CD101) where the 3 stock items are being printed with the same design.  OR we could have the opposite where 1 stock item will be divided among multiple print options (CD101, CD102). Is there a simple way to associate a stock item on a SO with the Non-Stock items below it?!  For easy aggregation in the invoice?!Cheers,k2

Hi Acumatica Community,Good Evening!How can I convert this values from -126,622,189.58 to (126,622,189.58 ) in ARM Reports (Column Sets).Please see attached photo for your referenceFormula :June Budget Ledger - June Actual Ledger- = Amount                         Actual                                    Budget                                   VarianceThank you !!    

We are migration from QuickBooks to Acumatica. We were able to migrate almost all information already (customers, items, vendors, invoices, etc.). The issue is extracting the Credit Card information linked to customers from QuickBooks.We have talked with QuickBooks and said this can’t be doing a manual entry is the only solution. For us that have thousands of customers with credit card on file is not a viable option.Do you know if Acumatica have a tool for extracting the credit card information from QuickBooks? Any other option that can recommend for doing this? 

Hi,May I ask how to write off a small difference amount from the Vendor PO with the actual amount we paid.For Example, the Vendor PO is $1000.93, and the amount we paid is $1000.95. I know that for customer we can enable the write off function and set a write off limit, how about vendor?

When I reclassify the journal transaction, the line with zero cost did not appear. Can I confirm that for zero cost item, we are not able to reclassify to another account? Or what can I do instead? thank you 

on acumatica 2020 R2, is there a sales price module?

Hi all,Is it possible to only allow AP entries having transaction date/posting date within the same period? How can we achieve it? Please advise. Thank you for your assistance. Regards,Aaren

 if accidently generate wrong commission sales rep in a bill, how to reverse back and re-generate again? I haven’t face this issue before Could some one advise on this?  

Dear ALL,In AR Module. How to do multiple payments for Invoices of multiple customers in 1 journal ? (for example receiving money for multiple customers)Thanks,NNT 

Hi Everyone, My client requested to create a financial statement that can be converted in different currencies. Is it possible and how? Thank you !!

Hello,    For ARBalance, we have a table/DAC named “ARBalance”, it already sum the result group by customer and branch.     However, for APbalance, it seems we don’t have a talbe/DAC like that.  We have a DAC called “VendorSumary”, but it sum the vendor balance up regardless the branches.     Do we have a DAC like “ARBalance” which I can use directly. Or I have to count per every open AP doc?

Why does the Invoice for the 100pcs on IN0563852 shows a sell price of $271.23, but when you print the invoice the price comes in at $135.62? It is cutting the price in half. Does anyone know why? 

Hi Team, Recently, I tried to bill a customer invoice for the time card hours spent by the employees who are working on the specific project. Once the employees released the time card after approval, I could able to see the activities in the “activities” tab in the project but in the “cost budget” tab i couldn’t able to see the actual hours and amount. As per the help document, it shows once the time card gets released, the actual hours and amount will be updated.  If I click on “Run project billing”, I could able to see the proforma invoice creation. My concern here is about the “cost budget” tab. And also in the “Balances” tab, the project labor balances are not getting updated. After the invoice is released, I could able to see the details in the “Revenue Budget” tab but no balances gets updated in the “Cost Budget”. Is anything missing in the settings? Awaiting for your support on this. Thanks,Nithya

how does Accumatica apply a fuel surcharge based upon distance traveled

Hi,does anybody know whether there is a setting to ignore rounding differences such as 1 or 2 cent ?Or a workaround to match these anyways.Somehow our shop system (shopware - germany) is calculating different than acumatica so we often have these rounding differences and can’t match the bank transactions.Thank you so much

Good day, I am trying to depreciate a fixed asset per calendar days per period. For example, if an asset has an original acquisition cost of $365 (useful life 1 year, straight-line), the depreciation schedule should look as follows:Jan: $31, Feb: $28, Mar: $31, …… , Dec: $31.I have created depreciation methods using the full day averaging convention but this feature seems to prorate the depreciation when placed in service during a period, for example if an asset is acquired half way through the period - only 50% of the depreciation will be posted to that period. Example of Depreciation Method setup: Example of Calculating Depreciation for Fixed Asset:May you assist?Kind regards,Nicolas