Inventory, Orders Management, Warehouse Operations
- 1,423 Topics
- 5,512 Replies
Hi All,Does anyone know how to put a freight charge on a shipment but not invoice the customer for it? They want it to be deducted on projects so that they can track the costs of shipping.For example, if the freight is $100, it would show on the shipment and the invoice but not charge to the invoice. It would deduct from the budget on the project.
Hi Community, please assist. I have setup an Import scenario to import vendor payment details into the system, However upon import, it imports the first Record and gives me an error for all other records. I have checked the formatting on my file and i think its ok. There is no difference between the first record and all other records. PLease assit. What is it that i am missing
Hi All,We have some weird behavior currently.We are trying to adjust out expired Inventory. Receipt states QTY on Hand is Zero, yet the Lot is stating a different story:We are currently not able to released this Adjustment due to the following error which is caused by the QTY On hand on the Receipt equaling 0Any ideas if what is going on and how to resolve this?
We are trying to schedule (automate) our Request to Requisition to PO process. However, we think the process will need manual intervention to change the Requisition status from On Hold to Open before creating POs. Is there an option to turn off the status of the Requisition automatically being created as On Hold? I can see an option to do this for the creation of the PO, in the Purchase Requisition Preferences screen (checkbox called Create Purchase Order on Hold), but nothing for the Requisitions.Thanks.
Wondering if anyone else encountered the error “Data is absent” during the Sales Order Line upload function? 2022R2The client provided an excel workbook, and I added an upload tab as the first tab in the workbook for the upload data.If I copy that upload data to an empty new workbook, it will upload, so I know my data is clean.What settings on the excel workbook might be causing this error? I have verified that the sheet and workbook is not protected. What else could it be? Any idea would be appreciated. We have not seen this error before.
I have created a generic enquiry to show the latest invoice age per customer but the ARInoice.DocDate seems to have a problem because my date values are all negative. My formula is =DATEDIFF('d',TODAY(),[ARInvoice.DocDate]). Could this be also because I’m grouping my data This also impact my options to filter because I would like to only get invoices older than 90 days
Hi We have 9 warehouses and use average cost. We want the same stock item to have the same average cost across all warehouses. Unfortunately, this isn’t working for us, and each warehouse has its own average cost. This makes sales margin reporting a nightmare. Our auditors are also questioning our inventory costing method.Can Acumatica do the same average cost for an item across all warehouses? The help manual says “yes”,If the Average valuation method (also known as average moving cost) is assigned to the stock item, the unit cost will be calculated as the average weighted cost of all items at the warehouses—that is, the total costs of all quantities of the inventory items at the warehouses divided by the total quantity.but our support company says “no”. thanks
How do I add a Discount to a document (or line) that removes 15 cents per UNIT sold if the quantity sold is greater than 500 units? Essentially, this discount will decrease the UNIT PRICE by 15 cents on every line for this customer. I can’t use percentage because the unit prices vary. Any help is greatly appreciated.
Hello,is there a way to automatically check the “mark for PO” checkbox in a sales order if the entered quantity will result in a negative stock qty? The sales staff tends to forget to check the box every now and then. I am looking for a way to make sure no items from SOs are missing in our POs. thanks for your help.
Hello linkies,I would like to have a clarification on the Complete Order option which under More Menu of the Sales Orders(SO301000) screen. I have been trying to modify the status of an order from Open to Completed without creating any shipments.Even when the Completed checkbox is active at the line level, the status of the Sales Order still remains to be Open as shown below: Kindly let me know the use of Complete Order option for the same. Thank you in advance.
Good day,We are trying to adjust out inventory that no longer exist or has been used in an old warehouse that is no longer going to be used. We want to reduce to the On Hand to zero and the close/deactivate the warehouse to avoid any new sales/purchases to this warehouse.IN Error: The multiplier must be equal to 0 or 1. I can’t fine a fix to this error to allow us to release the adjustment. Any suggestions would be helpfulThank you.@Evan G
Hello. I am seeking configuration templates that can be imported for various modules such as Finance, Distribution, Field Service, and CRM, specifically for the versions 2022 R2 or 2023 R1. If anyone possesses such templates and is willing to share them with me, I would be extremely grateful for your assistance. Thank you in advance!
Hello,We have a non-stock item.PO receipts is updating the “last vendor price” as expected.However, when we add this as material on a production order, it does not use this cost. It uses the cost from the price cost tab. Am I missing something. The expectation is that PO receipts will update costs on the non-stock items so when they are placed on the production order they have the proper cost from the PO receipt.Right now it appears that the costs have to be manually entered.Any guidance is appreciated.
SO Error: Carrier Service returned error. 120502:InvoiceLineTotal MonetaryValue must be greater than 0
Unable to confirm the shipmentShip via: UPS (Next Day Air)Country & Postal PR - Puerto Rico 00646Error: SO Error: Carrier Service returned error. 120502:InvoiceLineTotal MonetaryValue must be greater than 0 Send Raised At: 9/22/2023 11:49:20 AM Screen: SO.30.20.00 Details: 9/22/2023 11:49:20 AM Error: SO Error: Carrier Service returned error. 120502:InvoiceLineTotal MonetaryValue must be greater than 0 at PX.Objects.SO.SOShipmentEntry.ShipPackages(SOShipment shiporder) at PX.Objects.SO.SOShipmentEntry.PackageDetail.ShipPackages(SOShipment shiporder, Action`1 baseMethod) at PX.Objects.SO.SOShipmentEntry.<>c__DisplayClass57_0.b__0() at PX.Data.PXLongOperation.<>c__DisplayClass18_0.b__0()
Hi community. Please assist, I have. An import scenario that is triggered by a business event. The Business event completes but with an error for the import scenario. however, when i resume processing of the event from the BE History screen, it runs. Please assist , what am i missing.?
Hello,We use Pick, Pack, and Ship in our warehouse to process packages which ship via UPS.Recently we noticed the declared value on these packages is $0.0.Where does the system look for the value? (It would make sense for it to default from the MSRP field in the stock item.)I cannot find a setting/documentation that helps; Can’t imagine that the system expects it to be entered manually every time. Thanks for your help.
Hi everyone,I was wondering if anyone knows of a way to keep the Sales Order status ‘Open’ after creating shipment?We use either create shipment, or quick process, to create shipment, confirm shipment, and print shipping confirmation - But want to go back and update details on the SO such as price and CustomerOrderNbr after the order has shipped.TY in advance!
Good Morning All, How can i run a report on materials (excel) for Inactive, No Purchase, Marked for Deletion and No vendor materials. I am new to this platform still, please intricate detail instructions. Thank you.
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.