Financials

Hi, We have changed the Invoice Number sequence start as follows. we have attached it in AR Preference.  But Some time Invoice Numbers are not coming as sequence.Need to sort it out.   

Hi, where do i remove “balancing entry” in the bank aba file in AP please? CheersLaura

Checking to see if there is a fix being done on a present situation in Acumatica involving updating Customer payment information.  Here is the issue: A customer started out originally being a "Check" customer meaning they get paper checks.  The customer now wants to do ACH payments.  When we update the payment information for the customer, any invoice that is already entered to the customer when they were a "Check" payment will not be converted over to ACH payments.  It will only go by check because when it was entered, "Check" was the payment option.  The only way to make it go ACH is to reverse all of the invoices and re-enter AFTER the ACH information is updated in the Customer File.  BUT if you re-enter the invoice under the ACH payment information but you attach the invoice to a purchase order that was entered BEFORE the payment information was updated, the invoice will not show up on EITHER Prepare Payments reports.  Just had another one where the invoice was entered after the AC

We have a business use case that we are trying to figure out.  We would like to take multiple T&M projects and roll the invoicing for each one of those into one invoice?  I was playing around with the idea of Parent Child Customers with the Child customer associated with he Parent with the Consolidate Balance, Consolidate Statements, and Share credit Policy set.  I’m just not seeing any way to roll billing up into one invoice however.  Any tips you can provide would be most appreciated. Eric BelshamGaleforce Consulting Partners, LLC.

Good day,We are figuring out a process to apply payments and discounts to invoices. ACM has been processing orders and invoicing them since the beginning of the year. The company financial operation has not be used (long story) but been an ordering processing system.First, we decided to manually apply payments to the invoices in ACM.  I tested the process with payments and adding a cash discount to the invoice.  The customer makes a payment less the discount.  The problem is that credit terms (in past) were not set-up correctly or we are over the period so I get the below error when applying the discount.  The message “The amount entered exceeds the remaining cash discount balance 0”.  I know this is related to the credit terms on the invoice.You have any ideas. The only thing that I could think of was to enter the paid amount and then do a credit for the discount with a GL on the customer account but that would leave a balance on the invoices.  Or another way would be to pay the invoi

On Company A check number 123 should have been my next check number but the system skipped to check 124 for Company A.  When I looked in the Accounts Payable Module for check 123 up it should up under Company B.  Company A’s checks should not look for duplication in Company B.  Is there a setting in the Accounts Payable Module that allows duplicate checks across different Companies?  Or a setting in Acumatica somewhere that tells the system that duplicate checks are by company?

I’ve been working on initializing the Fixed Assets module for a client which has assets dating back to 1991.  The assets are to be imported using the “posting” ledger (BOOK).  Recognizing that these assets pre-date the first financial period as configured in Acumatica, we shifted the first financial period back to 1991 (from 2019) and made sure that all periods have been re-opened.  The FA module is in “initialization mode” as the Update GL option is cleared.Yet when importing the assets the system generates an error stating that the financial period doesn’t exist for the FA Book to which the assets are being imported.  The system is directing us to “generate the book calendar”, which, as I understand it, can only be used for “non-posting” books.What are we doing wrong?  Has anyone else encountered this issue?   A case will be opened...

Howdy y’all!I am trying to find a way to create tasks that would be linked to certain reports (ARM and Standard reports), like a month end checklist for finance users.  However, I see that Tasks can only be set for leads, contacts, opportunities, business accounts, cases, employees and projects.  I also researched Business Events but those seem to only be linked to Generic Inquiries.  There are no Activity tabs on the reports so I can’t use that option either. Am I perhaps missing something super obvious? Thanks!   

I discovered an open invoice that needs to be reversed due to an error, but under the applications tab it has a debit adjustment applied to it. Can I still reverse? If so, what happens to the debit adjustment? Thanks!

I have trouble accepting that an Invoice can simply be deleted in AR Acumatica, in order to reopen a proforma Project Accounting Invoice. The audit purpose of Invoice numbering is the numbering sequence to ensure "completeness", and by simply allowing the deletion of an Invoice breaking the numbering sequence as far as I'm concerned is unacceptable. I would rather that the Invoice be left in display on the system but its status changed to "Deleted and Not Posted" (or something similar).

Hello everyone, I am wondering how to handle the following problem:Let's say I produce some finished products in a given month. After producing them, I immediately sell them.After selling some of them, I receive an invoice for the electricity (just an example) that I want to classify as a production cost and I want to include it in my Income Statement by Function of Expense under COGSI should allocate this costs (after the sale of some or all finished products) to sold finished products and to finished products that are not sold yet.In my opinion, it is not possible to allocate costs to products that have already been sold. But I have to include these costs in Cost of Goods Sold.How do I handle this?Thank you in advance.

Hello Acumatica Team I was wondering if it’s possible to change (with code of course) the event that launch the workflow approval : Say it’s the release of the invoice instead of the save ? Thank You !

I discovered an underpayment on a prepayment which is leaving an open balance. There is also a unapplied credit memo for the amount of the underpayment. When I try to apply the CM, I go Document Details → Document type and the only options are invoice, debit memo and overdue charge. What should I do to close both the CM and prepayment? Thanks.

We are receiving an error message that a payment document entered and voided has unreleased transactions. The document does not show anything open on it and nothing is unreleased. How can we find invoices that they system thinks are on this unreleased document and release them? Prepayment Record Voided Payment Record Does anyone know what criteria table/columns/fields determines whether invoices are displayed/available to select from when entering new payments? Something about the above is restricting these invoices from being available to be added to new payments. If we knew what the criteria was, we would be able to try and troubleshoot resolve.

Hi,When my customer uses the Reprint with New Number option on the Release Payments Form the original check drops into a Balanced Status.  Shouldn't the check be voided?  The check shows on the Check Register Inquiry in the Balanced status.  Is this a bug or is there a process that I am missing?Thanks for the help!Coleen.

Hi,I need to know how can we automate our vendor payments in Acumatica by using third party gateways? I heard about Plaid but interested in comparing it with other gateways too? if anybody is doing that please help.

Hello everybody,We have many orders that come across as pre-paid and invoices are not created until shipment.  Can anybody tell me if there is a way to apply a bank transaction to an order instead of an invoice? Thanks,Sandy

Yes.  That is the statement.  Open debit and credit adjustments on a multi currency vendor account are not revalued.Why?I know that prepayments are not revalued which are slightly different but again why? ThanksJAmes 

What is the process to void an ACH payment?  We voided in the system, but it was not “exported” to the bank. 

Dear AllI am new for Project module and have 2 question regarding Billing rules & InvoicingIs it possible to include Sales Prices form Sales Price Screen in Cost Budget for Stock Items? Unit Price column takes Default field from Stock Item and I cannot seen any other possibility to put any Sales Price on the layout and also later for Invoicing(Sales Price Screen is not an object for Billing rules calculation logic) If Kit functionality is used - is it possible to put on Invoice Finished Good instead of its components from Cost Budget that are purchased for that Kit to be created?I would be grateful for any tips. Thank you in advance.

How to change the date on the Document recognition service to use local date and not American date format

I need a Column Set that includes the last quarter of Fiscal 1 and first 9 periods of FY 2.How should the context of the Visible Formula be structured to return that data?

I noticed an open credit adjustment in the system and no bill to apply it to. How do I close?This is off topic . . . does anyone know how to create a weekly transaction report in Stripe? I find it tiring to scroll through all the payments/refunds when all I need is the last 7 days. Thanks for your help!

Hi Sir We would like to add in column D in column set. Anyone can guide me how to add in?  

how do i extract customers master file in a CSV format