Financials

Customer wants to build a prototype product using Production Job. Once all the cost accumulated on the Job, what is the best way to transfer it to Fixed Asset? is there any way to transfer Inventory Items to asset register/module?any better way i.e using Project to build the Prototype and Moving to asset register?

We are using MYOB Advance (NZ and Australia version of Acumatica).  We are a B2B business so our customers pay us for dozens of invoices at one time.  This means matching to an invoice is not possible.In other systems you can create a matching rule based on the transaction description that appears on the bank statement.  We have asked our support company but they don’t know how to set this up. Does anybody know how you can create a customer receipt entry based on the bank statement transaction description match? thanks from NZ

I have set up row sets that work on standalone Income Statement, but not sure how to design the row set so it eliminates on consolidated statement. Maybe I need different GL accounts - see below. Entity A - CorrectSale to end customer - $25K COGS for order - $21K Entity B - CorrectInterco sale of $21KConsolidated - No EliminationThe intercompany Sales line should be zero and hidden. The COGS material line should be $13,827 ($34,889 - 21,062) The row sets are set up as follows:Intercompany sales being driven by GL account 40005 COGS Material being driven by COGS account class How do I go about eliminating the interco entries on consolidation. Open to changing row set/GL account/Account classes as necesary but wondering what the best practice is for structuring this.

Hi, We have  a client with Segment Keys setup as shows in the screenshot below where the Segment ID 3, 4 and 6 are non Validating segments.The client would like to disallow Blanks or 0’s in these Non Validating Segments. Any idea if this is possible?We cannot enable validation for these segments as the list grows every day. Thanks 

Hello-We are using Print Invoices and Memos (AR508000) screen to email out invoices to our customers - this results in some getting 50+ emails all at once, one per invoice. Many are complaining.Is there a way to email out a customer’s open invoices such that they are all sent in one single email, instead of a separate email for each invoice? Thank you!!

Hi,some of our customers pay several invoices and deduct a credit with the same transaction.There is no problem in matching several invoices but it seems the credits arent loading in the “Match to Invoices” window for receipts.Does anybody know a solution for this?Many thanks!!

Hi,I have customized Invoices and Memos GI. Now I wanted to show the Invoices’ dunning letter details as well.But once I connect the ARDunningLetter and ARDunningLetterDetails with ARInvoice table GI only shows the Invoices that has Dunning Letters.  But want to show all the invoices. Therefore, removed the invoice Refnbr connection. Then invoices duplicated and showing the incorrect dunning letter info (because removal of dunning letter detail and Invoice RefNbr connection)Is this can be fulfilled? 

Hello,      I have read the below post carefullyHow to delete a bill when it's already been released? | Community (acumatica.com)    But can I ask a specific case?   Supposing,  we have purchased 10 cases item A and 20 cases item B, all with $100 each case on original bill and released. Now we find the actual cost of item A is $120 per cases. So the bill is $200 under amount.    If we create another bill posting to “purchase accrual ” with $200 in total, it could make the AP amount correct. But the inventory cost of item A is not corrected. And the figure post to “purchase accrual” would not convert to “cost of good sold” automatically.  Return the receipt and reverse the bill seems a way to go, but it is a little bit complicated.Since we only need to correct 1 item’s cost and corret the AP and expense amount (the purchase accrual convert to inventory and would finally convert to cost of good sold), any suggestion?

I am trying to create an import scenario for writing off invoices and can not make it work.Below the data provider Below the Import Scenario: Below the import scenario after preparing the data:  It completes with no errors but do not do the write off for the invoice. Thanks for any hint on what I am doing wrong here!!

Hello Folks, wondering if anyone has experienced this issue and if it could possibly be just intended functionality.Our Sales Order with multiple lines has a total amount that initiates one of the discounts we’ve setup (i.e. >2500 = 20% discount).  The sales order resulted in a split shipment which resulted in multiple invoices. So when the invoices are created it no longer recognizes the 20% discount because the amount (on each invoice) is below the threshold of 2500. And the discount is incorrect. Thanks in advance!

Hi,  We have some customers that were charged sales tax by mistake, and we need to refund only the tax portion of an invoice. What is the best way to go about it? We want Avalara to recognize the tax refund so we don’t pay the sales tax on it. 

I’d like to delete a released bill, how can I manage it?Right now I could only see the “reverse” button, and when I clicked it the system just created a debit adjustment. I want to delete both of them. Please teach me how. Thanks in advance!

I have a prospective client that has a need for language and currency translation to Hungarian, for one of their sister companies.  Has this been done before?Appreciate the help in advance! 

I would like to know what level of customization we have for rounding profiles? For example for all SO related items I would like the pricing rounded to 2 decimal places. Customers, especially EDI transmitted, do not accept invoices with totals (or Cash discounts) that are beyond 2 decimal places. Conversely, on our purchasing module there we need costing to the 4-5 decimal places due to the piece prices.  AP Bills need to have unit costs to the 4-5 decimal but the Calculated Ext Cost only need to be rounded to 2 decimals.  Everything I have seen and/or read just have Price/Cost using the same rounding profile and no further customization beyond that. Any thoughts on what I am looking for?

Our client has a few cash receipts every month that need revenue deferred until the next month. Would the deferred revenue module be over kill for this? I looked into the module and it mainly deals with schedules so I am not sure if it would be the best solution for them. Example:They receive the payment is September for $10K. DR - CashCR - Deferred Revenue They receive the $10k invoice in October and apply the payment:DR - Accounts ReceivableCR - RevenueDR - Deferred RevenueCR - Accounts Receivable I was able to create a few work arounds for them but they haven’t been completely happy with them.The first was that they enter the receipt of cash through the banking module when they import the bank transactions. Then, the next month, they enter the invoice and reverse with a credit memo but change the revenue account when they create the CR. They didn’t care for this because it is not a true representation of what is being done which is paying it. The other resolution is to create a prep

Currently working on modifying the Row Set so we can capture intercompany Sales/COGS on standalone statements while having both sides net out on the consolidated statements.  How do orgs typically structure this on the Row Set? Would we just add one line for Intercompany Sales/COGS which adds both GL accounts - this seems to achieve what I’m looking for on the consolidated side - but when generating standalone statements this line item will need to be separated from Income or COGS subsections? Since for one branch this would be an income line and for the other branch a cost/expense line ..

How do I partially pay an AP vendor? 

Good day, can you assist with the global financials brochure or link  where i can download it. Cant seem to locate one.

Hi Acumatica,Is there a way to set up if the Customer or Vendors paid prior credit terms there is a automatic calculation of discounts?Thanks! 

Hi Team, We are implementing three different companies with different base currencies in a tenant. We have enabled “Multi base currencies” setup for this activity. Three companies will have three different Chart of accounts. Here, my question is how to set up the preferences form specific to the three companies. Awaiting for your valuable reply,Thanks,Nithya

Do Unposted  or Unrealeased trasactions cause a variance in the AR and GL control accounts?

it used to automatic release matched GL transaction in Process bank transactions Screenbut now its not working, any help!  

How can I group a p&L for individual branches?   

Hello Community,I have a requirement where a company has been selling their items to their customers.Here, they are recording the VAT for the sales as well as the income tax one the same record. So how shall I record the Income Tax on the same? Kindly guide me. Thanks in advance.

How do you confirm and be sure that AP balance is equals to GL balance and their is no variance?