Topics started by byates
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.
Hey all, I looked through the search but I could find a definitive answer. I would like to know if there is a stardard GI or report were I can find a PO that was deleted, more pointedly who deleted the PO. I have already enable the “show deleted records” in the Purchase Order GI but that does not produce any results. We have had this crop up a few times and I would like to find out why it is happening. Let me know if there is a way to do this. Thank you
Good afternoon,We are beginning to process AR in ACU. For our high volume customers I am thinking the best way to do this is via import scenarios. I know next to nothing on import scenarios but understand they can be a very powerful tool once understood. For context, one remittance may include hundreds, or even thousands of lines that are a combination of AR invoice amounts and deductions against those invoices and cash discounts. I am wondering if I will be able to create one upload that addresses each of these to net me the correct cash deposit amounts. Or am I going to have to process the payments in one screen and the Credit memos in another and then apply the two together?
Hello, apologies for the long question.I am working to setup Acumatica and noticed the handling of inventory for Sales Order shipments is different than every system I have worked on in the past. With our current configuration, when you create shipment for a Sales order you stop just short of Updating IN. This is because one you Update IN it creates the inventory COGS transaction on the PL. We do not invoice and recognize the revenue, until the product is delivered to our customers. So if you do Update IN this creates a disconnect between revenue and expense (not an option). However, if you do not Update IN the inventory remains “On Hand” at the warehouse and all reporting shows those quantities on hand. What I would prefer to see is that inventory moved to In Transit until the SO is invoices at which time the inventory is expenses and the Receivable is created. Due to the inventory remaining ON Hand I am having a difficult time reconciling physical counts at our sites and creates a hu
I would like to know if there is a way to show the total Order weight for all items on a Sales Order. I see that there is a section under Totals>Freight Info but Ideally I would like the weight to calculate prior to shipment being created and currently it is zero. Thoughts?
Good morning, I thought I would reach out to see if anyone is manually processing Amazon payments, and specifically how are you handling the Monthly Reserve withholding and subsequent release in the following month? Since each has an impact on the payment amount how are you applying those to payments?
Hi all,So I noticed that when creating a PO with multiple line items with the same inventory ID, when the PO is printed the system sums all of the lines together and only prints out one line item with the aggregated total qty. Our hope was to create a PO with multiple lines that correspond to requested on dates which you can change on the line level. We are trying to avoid having to cut a PO for each day and just have one PO with the different requested on dates at the line level. Wanted your thoughts on if this is possible. Thanks,
Hello all, I am beginning to research RFID Inventory Control systems for our company. I wanted to reach out if any users are currently using this inventory control technology and if so what is some feedback for someone starting at the beginning researching this. Also, if using are you integrated with Acumatica? Thanks
I am wondering how to revalue inventory in ACU. I know I need to use the IN Adjust but still not getting the results I want. I have some items that have correct qty and the incorrect valuation. For these It would just have to remove all of the inventory at system cost, and when I add it back to I use IN Adj or IN receipt? I believe the issue I was having with IN adjust is the costing is tied to the receipt that you choose.We have a few items that have a value by no quantity. I am unable to do a IN adjust with a Qty of zero. The system does not create any transaction. How would I correct these issues?Thanks as always to a great community!
Hi all,We are looking to use the shipment confirmation form as a pseudo Bill of Lading as a way to notify both parties of a transfer that has been created. Standard form has Ship To location but there is no ship from or Shipper address information. Since there is a from warehouse listed I am assuming I can edit the report (and tables) to query the ship from address off the warehouse location. But I don’t know what tables and relations I would need to create this. Any ideas?
Looking for info on how I can create a printed form for AP bills. Ultimately, we would like forms for all bill types but looking for immediate need for a Debit Adjustment printed for so we can send to a Vendor for a Debit Request (Credit Note to the Vendor). Has anyone had any success in creating these? I am a bit surprised these are not out of the box. Thanks all!
Is there an easy way to revalue inventory for a specific item/site? Best I have found is inventory adjustments, but then you cannot add inventory to the same receipt because the costing is tied to the receipt. We had a incorrectly costed move due to a incorrect AP entry for a sub component.
Hello,I am wanting to create a pdf form for AP Debit Adjustments. The business case is that when we have a Credit memo request from our Vendors, rather than waiting for the Vendor to create a Credit Memo on their end and send to us, I would like the ability to generate the a Debit Adjustment and print to PDF so I can send to the Vendor to initiate the request. I am told I have to create a form from scratch for this as out of the box there is not form for Debit Adjustments. How would I go about doing this and are there any best practices to help expedite the creating of this, ie copy AP Remit form etc… Thank you
Hello, I have a released AR invoice that had the incorrect date entered. I have tried to correct the invoice date, which moved from July into June period, and when trying to release the corrected invoice I get an error;“Inserting 'Applications' record raised at least one error. Please review the errors. Unable to apply the document because the application period precedes the financial period of the document.”So it appears it is due to crossing to a prior period. How can I correct this AR invoice and get it in the correct financial period?
Is there way to create a TB starting balance update? We have already uploaded a starting TB and need to change a few accounts. From what I see, even when I only populate the Trial Balance screen with my desired GLs once I release and the Journal Transaction is created it includes every GL and assumes the GLs I did not populate I want set to zero and the corresponding journal tran is populated with that assumption. I am unable to delete any of the lines for GL I do not want to touch. Other than just posing a manual journal can this be done through Trial Balance?
Hello,One of our people posted an AR payment in the wrong amount (I surprised the system didn’t give a warning that the payment amount entered did not match the AR invoices loaded). Then he did a payment void but did that to the wrong period. So I am looking on how I can fix that so the GL matches the subledger. I can’t reclasify the batch because that does not correct the AR subledger. I can reverse the Journal transaction but again that only address GL and does not correct the AR Subledger. This is the second type of mistake that has been made that I have essentially been told “sorry once its released it can’t be fixed” which does not seem correct. So thought I would reach out to the community. Thanks
Hello,Looking for information if it is possible to create user restrictions to only allow access to view certain Sites. As an example, we utilize a network of Contract Manufacturers, I would love to allow access to a user at the site to process production moves as the plants complete actual production. However, I would need to restrict that users access to only be able to process and see relevant information for their specific site. We don’t want access to other sites in the system. Is this possible?
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?
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?
Good Afternoon, I am looking for some assistance with creating a GI. I am using the Inventory “Issues” GI as the basis. I am trying to modify it to include information from the INTrans table. I would like to bring in the following Properties:INTrans.SiteIDINTrans.InventoryIDINTrans.QtyINTrans.TranCostThen add an additional condition to only show item that have INTran.ReasonCode of “Damaged” Essentially I am trying to create a GI that shows me the total cost/qty by site and Inventory ID of all “Damages”. Using this to begin tracking manufacturing shrink/waste. Currently I am getting error when trying to view the GI so I am sure I did something wrong with the tables and relations. Attached is the GI as it is now. Thank you for the assistance.
Hello, I am getting an error when trying to create a purchase order from my Production Order. The Purchase order contains two non-stock items and upon “Processing” the Purchase Order I get two errors, one for each item, and the PO is never created. This only appears to be issues with Non-Stock items. Thoughts?
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.