General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,479 Topics
- 4,908 Replies
We are using Velixo to create a report showing current percent complete and forecasting the percent complete per month till the end of the project. The problem I have is when pulling the Budget Forecast into the spreadsheet I need the RevisionID of last update. I have pulled that field into the GI but it wont show up. It doesnt even show up, but its on the results grid. Any idea how I could get this number to show?
in segmented keys I would like the system to pickup the BAccountID and fill this in as the 1st part of the subaccount being used So for example I have set subaccount up as such in the CS202000 screenAnd I would like the system to look at the customer or (vendor if applicable) and fill the 1st segment of the subaccount with the BAccount code So if I was entering a AR Invoice I would like the first segment of the subaccount to pickup the current BAccountID and autofill with thatthe only way i can think of doing this is using custom workflows but wanted to check that I’m not missing something
Within the AR Invoice process screen (Print Invoices and Memos), there is an option to MARK AS DO NOT EMAIL. We automate this function for $0 invoices through an automation schedule. However this same functionality does not exist in the Sales Order Invoice Process screen (Process Invoices and Memos).Until this functionality is added, any ideas on how to automate this? My first instinct would be an import /export scenario to check the DON’T EMAIL box inside the Sales Order Invoice Screen.Ideas?
Hello, we are not using the time and expenses module but I would like to upload a journal file for CC expenses. Ideally I would like to book the liability by employee so we can see who has balances when reconciling. It does not appear the system will let you add a Customer/Vendor on the GL journal. Without having access to time and expenses is there a way to achieve this?
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
Does any one know how to reverse a Landed Cost? We had an entry with a clerical error and the amount was incorrect. Now inventory is overvalued and we have the amount sitting in the accrual account. The AP bill should address the accrual balance but will create a credit on the P&L variance account. Not sure how you address the inventory valuation. So looking for ways to edit, delete or otherwise correct the LC transaction.
Working on cleaning out historical transaction that had receipts but never billed since we were running congruent systems and the bills were handled in our previous ERP. As such I have a very high number of both PO and Landed Costs receipts that I need to bill in order to get the balances off the accrual accounts. Is there a way to mass bill Landed Cost receipts so I can then start clearing from AP?
I have a situation where our company has 4 different Cash Accounts of 2 different backs for 2 branches. GL account AAAA, we have 2 cash accounts AA and aa also GL account BBBB, we have 2 cash accounts BB and bb both have the same Account Class. When I imported the Trial Balance Cash Accounts AA and aa showed the right amount, but Cash account BB an bb shows the beginning balance as 0. Does anyone know how I can make account BB and bb show the beginning balance?
Has anyone been successful in implementing AP Document Recognition in a Production Environment on Premise or on Microsoft Azure?What about on AWS?In an On Premise instance the Incoming Documents screen is not “remembering” the user mapping for detail lines and in order for the Vendor to be “remembered” the vendor record must be manually edited. (2020 R2 Build 20.204.0031) In a Microsoft Azure instance the Incoming Documents screen is not “remembering” the Vendor or user mapping for detail lines. (2021 R1 Build 21.102.0070)
Hello, When I study the table, I see a lot of columns start with Fin or Tran.I konw Fin means the Finanical Period, How about Tran?I know YTD is year to date, PTD is period to Date.But what are tranPTD and TranYTD?For me, it looks like the same with FinPTD and FinYTD
Hi all...perhaps someone can share some ideas on following TAX (VAT) issues.To be able to create a meaningful tax report i have created 3 different tax zones and tax categoriesTax zone 01 / category 01 = local purchase and sales on 15% VAT. All stock items are set to this category, all good in this scenario.Tax zone 02 / category 02 = all foreign customers (exports) set to tax zone 02 / category 02, this category is set to 0% VATTax zone 03 / category 03 = all foreign vendors (imports) set to tax zone 03 / category 03, this category is set to 0% VATThe VAT for imports is paid by the customs clearing agency and invoiced as 'Custom VAT" together with other charges to us. In our tax report we need to show the total value of imports and total value of exports for the tax period.In my opinion the tax setting of the foreign customer and vendor should have priority over the tax setting of the stock item.Currently you have to go to each line item and manually change the category to 02 or 03 t
Hello, I’ve met a case, to make it easier to understand, below are the simple example:Item A has 2 UOMs, which is 1 Case = 50 lb, lb is the base uom and case is the sales and purchase uom.We purchased ItemA at $50 per case, however , at that time someone forgot to put the conversion rate on item, so the IN Receipt records the item was receipted at $50 per lb. Which is wrong, should be $1 per lb. We paid vendor at $1 per lb (cost on bill) and sold to customer at $2 per lb, which are both correct. However, as the internal profit analysis, this item shows highly negative profit, It shows every case we sold ($100), we are loosing (100-50*50) $2400, which is not true. I already did IN Adjustment to correct the average cost of the item, from $50 to $1 per lb. The afterwards sales would get correct profit. However, we have already sold a lot of the items on a lot of invoices, and these invoices have been closed. We do not care too much on the profit analysis on single
Im looking to set up a Business Event to send an Email reminder if the AP Bill → Approver hasn't approved the bill within 2 days. I'm not sure if this is possible through a business event and how to join APInvoice to EPApproval. Has anyone ever done anything like this?
When a GL account is assigned to an account group, the GL account will be required to have a project associated with it. Some forms do not allow for project number input which prevents use of that form. For instance, attempting to utilize the create adjustment tab in the reconciliation statements is not possible because the quick transaction screen does not allow the user to input a project number (there is no project field available.) Other areas where this is a problem for companies that utilize projects is in the fixed assets module and in the allocator process.
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.