Financials

I would like to Automate Opening financial Periods, I have tried setting up a schedule but there is something I’m missing. My setup is as below,Can someone help😊

How can I use Customer Invoice to pay for a Vendor Bill?I saw the option to "Extend as Vendor"  on customer screen and "Extend as Customer" on vendor screen but I didn't find how do I apply a vendor bill to a customer invoice...I would appreciate any suggestion.Thanks

I am trying to create a report with a blank column to divide out actual vs budget columns.  When I run the report there are zeros on some rows but not others.  I can’t figure out why it is pulling the zeros.  Everything else looks correct for the actual columns.

Do the Generate intercompany document (AP503500) is supposed to generate AP/AR for a interbranch timecard ?Thanks

How can a mass update of Vendor payment type be done, if at all?  Import Scenario? Generic Inquiry?Several vendors were set up with this informaion missing and instead of opening and updating one by one hoping a mass update can be done.  I am new to working with mass updates in Acumatica so any and all help/instructions is greatly appreciated.

Hi,I created Sales Order 01 last month for a customer with the credit term A (the customer's default credit term is A). This month, I created another Sales Order 02 for the same customer with the credit term B (the customer's default credit term is now B). I created separate shipments for both sales orders. When creating an invoice that includes both sales orders, which credit term will be automatically selected by the system? I observed that the system prioritized the credit term from Sales Order 01 instead of the customer's default credit term. Is this correct?Regards/Prasad

When I click ‘Add PO’ or ‘Add Receipt’ nothing shows up even when there are received POs for this Vendor and Stock Item.

My client would like to use Acumatica AR Invoices and Sales Orders and then have the tax calculated right in Acumatica. It would work just like to normal Acumatica / Avalara plug in but it would be for telecommunication tax not sales or use tax. I’ve checked with Vertex and Avalara and neither do telecom tax with their integration with Acumatica.   Also ideas?

Hello,Our controller asked me to post this question on the community. Can you please let me know what he is questioning? Why does Acumatica AP module put a BL as a prefix to the AP ref number?  This is a system generated number that is not manually entered.   

1. Truncated Module Menu DescriptionsSome of the module menu names are too long and get chopped off, making it hard to figure out where to go. Right now, you have to hover over them to see the full text, which is kind of annoying. It’d be so much better if the full names just showed up without needing extra clicks or hovering.2. Misleading Validation in Generic Inquiry FormulasWhen you’re setting up formulas in Generic Inquiry, the validation check isn’t always reliable. It might say everything’s fine, but then you run the inquiry and—bam—errors pop up. That’s frustrating because you think you’re good to go, but you’re not. Fixing this so the validation actually catches problems before saving would save a lot of time and headaches.3. Complex Procure-to-Pay Process and Billing InaccuraciesThe whole Purchase Requisition > Purchase Order > Receipt > Invoice > Payment flow can get confusing, especially with partial receipts and returns. The system lets you bill for the full amo

When our company was moving into ACU supposedly we were told that Acumatica could use per-determined rules to disperse specific expenses into each of our branches.For example:Any marketing expenses will be dispersed via the followingBranch A 29%Branch B 30%Branch C 41%I could not find a way to do this so I am assuming I may need to do this manually?

Hi there team, We have wondered why the Company Financial Calendar doesn't default to the same current open financial year? Rather annoying that we have to scroll to the actual year, rather then just open screen and the open/close periods.  

Hello All, Anyone have the basics for an Import Scenario to do a mass update to the Cash Account on the Default Vendor Location Record they would mind sharing?  Thanks in Advance.

I am having one heck of a time configuring a clearing accounts to use them for bank deposits. I’m using the guide from here: https://fedcoseeds.acumatica.com/(W(29))/Help?CompanyID=Test+March+2nd&ScreenId=ShowWiki&pageid=323644f1-ea34-4377-92bc-c1fcb4a86d05 But I must be misunderstanding something. I created the clearing account: I did not put any entry types.I made sure the clearing account could be use in the Payment Methods  I created a test sales order, made a prepayment using the clearing accountI go to the bank deposit screen and enter the following:  But when I click “Add Payment” I cannot get the clearing account to appear as an option: I’m sure I’m just missing a small connecting piece.Thanks!

Question from client:For the charges that are left after Auto-Match is complete under Process Bank Transactions, every single line will go to the Create Payment tab and I have to click on the Match to Payments tab and click on the Match to Multiple Payments and Match to Receipts and Disbursements options for the leftover charges to show up. Can we set this up to where it will stay on the Match to Payments tab? I will never use the Create Payment feature and when I’m clicking off 400+ charges manually, it gets really annoying that I have to click on so many things just to match the “bank” charge to the “payment”. I looked into this and could not find a way where unmatched transactions don’t default to the Create Payment tab. I looked at Bank Transactions Rules but that did not seem to help. Any suggestions? Thanks,Frances   

HI All, As per best practices  and its Normal and Simple  Process   as per my Knowledge across during the years the following is the Transaction entries which will clear the Purchase Receipt and return Purchase receipt Inventory Account  Dr.Purchase Accrual Account Cr. Return Before Invoice / Bill Created Purchase Accrual Account Dr.Inventory Account  CrBy this  both the account get cleared  and reconciled as well. if its Partial return Yes the balance remain  and  which can be cleared by Bill as its not retuned  As per the Functionality of Acumatica we need to create a AP Bill and a Debit adjustment for any return ?? though both PR and return has been Processed both Transaction remain uncleared in the accrual Account why this is required  and the logic behind this Functionality ?   

I have a PO that was setup with the wrong Vendor.  I received an invoice for the PO and created the PO Receipt before I realized that the Vendor was wrong. I did a Return of the PO Receipt (essentially nullifying the POR).  This Return actually created a second POR which reversed the first one, so all items on the PO are back to “un-receipted”. I want to correct the Vendor on the PO but since there is a link to to the “received” POR and the “returned” POR, the system won’t let me change the Vendor.  I get an error message saying - “You cannot change the vendor for this purchase order because it has purchased receipts linked.”Is there a way to remove the link to these two PORs to the PO?

Please kindly advise how can set up Tax type from VAT-to-VAT INPUT and GL Account Mapping has 2 Types to only Tax Claimable Account Requirement in System.Thanks for help and supporting. 

Is there an issue with copying fields over to an asset when converting from a purchase? The only information that gets pulled over is the receipt number which is not even going into the correct field. Do end users have to go into every single asset to manually enter the receipt type, PO number even if they create the asset through the Convert Purchases to Assets process?   Your input is greatly appreciated. Thank!

Does anyone have experience integrating Procore Pay with Acumatica?  I’m interested in hearing other people’s experience with the implementation.

Please kindly give me the sample to customize the Report P&L Actual VS Budget has add more Variance Amount. Thanks for your support and sharing 

Hi,I've created a custom export scenario for BNZ Bank in New Zealand and mapped it to the payment method NZBNZDD. This setup is configured for exporting batch payment files from the AR module for direct debit processing.The setup appears to be correct, but for some reason, I'm encountering the following error:"An error occurred while trying to retrieve 'Unique' part from specified."I'm unable to identify the cause of this issue.  Does anyone have any insights? I've attached the export scenario and error log(SQL Profiler) for reference. 

Good day,  I have question.  Basically it is confirmation.  We have set up the Worksheet ID with all accounts either set up as YTD/PTD.  When we run the translation the 35000 accounts comes out as a GAIN/LOSS.  35000 is the account on the currency as the translation  Gain and Loss Account.Is this the reason why the translation changes the Translation Method? I have to explain this to the CFO.  Or there a set up issue?  I believe it overrides the translation method on the worksheet because it on the currency GL Accounts.Thoughts?  Confirmation.  I can’t fine anything in the documentation about this.Thank you  

HelloFirst, I’m sorry if someone else asked this before, but I didn’t find my answer.My company has an excel file where we do this for all plant and 3 separate branches:Orders $ Sales $ Scheduled sales $ Total backlog $ Total past due $ # Employees Weight shipped The file has other columns as well, but this is enough for an example.There is some math behind those columns, taking the total from a week or the total from a report, for each branch.Is there a way of creating this in Acumatica? What I do today is filling the excel with the results I take from Acumatica. Thanks in advance, have a good day.

Hello Guys Can you help me with these issuesuddenly had rounding diff. the first picture is correct but the 2nd picture had rounding diff.     Thank you