Inventory, Orders Management, Warehouse Operations
- 578 Topics
- 1,928 Replies
Hello, I know we are having “Inventory Balance” report (IN615000) and “Historical Inventory Balance” report (IN616000). However, Inventory balance report is something like real-time balance, it displays the balance at the time of the report running. History inventory balance can only display the beginning and ending balance of selected periods. If my requirement is to record and display the entire warehouse’s inventory balance of each day for the coming week, like from Monday to Sunday. What is the quickest/simplest way to do it. All I can think out of is to set a schedule that run “Inventory Balance” on 00:01 every day, and sent this record out as email. And in the final day, I merge them into one excel. This is a workable way, but could it be better?
Hi,On this marketplace page for EasyPost: https://www.acumatica.com/acumatica-marketplace/easypost-shipping-integration/There is an image with the PX.EasyPostCarrier.EasyPost Plug-In. I was wondering if this is available somewhere. I did reach out to EasyPost support and the support person was not familiar with integration. https://cdn.acumatica.com/content/plugins/ac-marketplace/uploads/EASYPOST/ISV-Solutions-796-1Manage-ISV-Solutions-for-ISV727-1ScreenShot1.PNGIs that available for testing in 2020 R1?Thank you
HELP!! Error An error occurred during processing of the field PaymentMethodID: Error: An error occurred during processing of the field Last Modified On: Specified cast is not valid...
Any help would be greatly appreciated!I cannot prepare invoices AT ALL! I am not sure what changed but if anyone has any idea how to get this fixed i would really appreciate it, need this fixed asap :( Thanks!
Error: The entry form (ID: SO301000, title: Sales Orders) cannot be automated. Object reference not set to an instance of an object.
Please help! We are down!Has anyone ever seen this happen before? I cant access my sales orders, this is the error message that pops up:Error: The entry form (ID: SO301000, title: Sales Orders) cannot be automated. Object reference not set to an instance of an object.
Hello I'm attempting to create a single import scenario on InventoryItem attributes to update any item attributes without overriding the existing data. When running an import scenario with item InventoryItem attributes, if a field is empty on the import source sheet, then on import, it will override the data in the destination in that field and make it blank. I tested in the mapping sections using ISNULL([WILDLIFE],[Answers.Value]) in the Source field/Value, and had success. The issue I face is attributes that are checkboxes. The date gets imported as "False". I tried various IIF statements, with and without converting the data to different data types, and still no success.
Hello , I am using 2020 R1. Correct me if I am wrong, it seems to me the “Invoice cancellation ” function is duplicated with “Invoice correction” function. Or even worse, it is not very straight forward or some how confusing. According to the help doc, the credit memo only off set the Invoice total, it did not return/add inventory back. And it makes the shipment back to “confirmed” status. however, User can NOT correct this shipment or delete this shipment.Yes， It might be the IN issue is released. But in most cases, it is released at that time.So in this case, what can I do with this “confirmed” shipment.It seems to me I can only proceed it to another invoice, then what is the difference with “correct invoice” function? Moreover, if User looking for a “”REAL” cancellation, which offset the AR and put all inventory back, what is the quickest way for user to do? Please Advise. Thank you.
Shipment status broken again, confirmed status shipment can neither be prepared invoice nor correct shipment.
Hello, We are using 2020R2 103 version. We encountered another shipment status issue. We are having shipment as status “confirmed”.However, the user can not “prepare invoice” based on it. It will show error: And, the user can not “correct shipment” . It will show error: I checked the Database, it looks like for some unknown reason , the “confirmed” column has not been set to 1. This is the second time, our user met the status mess up issue. Unfortunately, we do not know how to reproduce it.Can Acumatica developers do an in-depth research to solve the root cause?
Hello, we are using 2020R2, Build 20.203.0028. Our operation stuff report an issue, that 1 shipment is still confirmed status while the invoice and IN issue doc already been generated and released. I don’t know the user’s steps and he could not remember. And this issue happens to only 1 shipment not all. And previously in 2020r1, we didn’t encounter this kind of issue. So my large guess it is causing by our recent upgrading from 2020r1 to 2020r2. see below: Since this issue happened only once, the root cause might not be easily found.Can anyone firstly give me some directions to quickly fix it, I mean, might correct the shipment status to right.If I simply update it in DB to status completed? Is it a good way to go?And if the root cause could be guessed out, it would be very helpful for us to prevent this same kind of issue in the future.Thank you.
Hello EveryoneWe have a problem with the size of the database due to the emails and attachements.Is there something we can do in order not to save these emails with their attachements ? a setting we missed? If not a possibility of a purge of the data we don’t need ?Any ideas Thnx;
I was able to set up 7 email accounts successfully.. but have 4 more to do and this is the error i keep getting: The mail send has failed.535 5.7.3 Authentication unsuccessful [BL0PR0102CA0020.prod.exchangelabs.com]I use the same exact settings as the ones that did work but it still fails. HELP! I am so lost as to why this wont work.
We are trying to work out how to automate the allocation of stock to orders which cannot be fully completed.There is no process to automatically “allocate” stock to orders. It would be great if there was.Due to stock shortages and the need to keep customers happy our client has to manually allocate stock to orders which is very time consuming. Some customers end up getting 10% of the order, some all of it if it is a very large order; there are many factors that come into play. Thanks
Hi,is it possible to take existing item codes and add attributes. E.g. An existing Inventory item = W-01. I want to use the Matrix Items to add combinations of this item. So …. W-01-BLK-2.8; W-01-RED-2.8 etc…Can I do this? I have tried to add the Inventory item as an attribute but had no luck. I don’t want to have to manually enter 200 templates with the Inventory ID. Any help appreciated.Cheers,Laura
We have a customer that requires the use of data matrix barcodes containing multiple pieces of data (Item barcode and serial number). The Acumatica WMS will read this type of 2D barcode, but we are not able to print them in order to label items.What solutions or ISVs are available to allow us to print the product labels?
Hello,I have made some researches but cannot find anything with similar functionality to Blanket Purchase Order for Outbound - Sales Order & Customers. I know there is also Customer Contract but it seems to be only for non-stock items.What I need exactly it is a kind of frame agreement with Customer with fixed quantity to be purchased in fixed period of time. Then in relation to that frame, call offs order will be pre-set and periodically adjusted and proceeded. Then later all have to be link to MRP.I would be grateful if somebody had some suggestions or share with experience how to proceed this process or similar one in Acumatica.Thank you in advance.
Hi all,I have searched high and low for this but cant seem to find an answer.Is it possible for a direct vendor return without the item returning back into our warehouseHere is the scenarioCustomer orders item, item is fault, vendor says they will pick it up from the customer, I will credit the customer and the vendor will credit meIt appears to me that I can only create a customer return to bring it back into stock and then a purchase return to send it back to the vendor so the item does look like it was returned to my warehouse at some point when it was not
Hi all, I’m looking to add UPS Ground Freight to our list of carriers/shipvia’s using the Acumatica UPS Plugin. The wiki notes carriers have various service types and lists ‘UPS Ground with Freight Pricing’ as one of the examples, leading me to believe this should be possible. Since UPS Ground freight uses a different endpoint URL for pricing and shipping, I’ve copied our existing UPS carrier that is currently working and added the freight URLs: Endpoint: https://wwwcie.ups.com/webservices/FreightRateShip Endpoint: https://wwwcie.ups.com/webservices/FreightShip I have also granted freight pricing, shipping, and pickup on our UPS account for production and have also tried this with the production URL’s. However, I keep receiving this error when doing a rate lookup: Carrier Service returned error. 9371000:Invalid Freight Shipping Request Document Does anyone know how to correct this issue?
Acumatica is working on expanding this area of the product and we are looking for customers whom are interested in working with us and piloting such functionality in their environment. The goal is to include advanced capabilities that go well beyond simple predefined set of substitutions and upsell/cross sell possibilities for a given item. We are looking to incorporate smart substitutions based on substitution history, cost considerations, inventory levels, user selections in prior order entry/checkout sessions, using ML technologies. If you are interested, please post here and one of our team members will get in touch with you to discuss this further.
About: We would like to gather your feedback regarding our credit card authorization and re-authorization process. This is important for commerce and distribution companies which process special orders or take orders with a long lead time before the order is shipped.In this focus group we will:Providing a short demo of credit card authorizations and how it works today Discuss how to manage expiring authorizationsAudience: Customers and partners who need this feature or have knowledge of workflows and how it can be delivered.Date/Time: Dec 16 @ 8:00 a.m. PDT / 11:00 a.m. EDTRegistration: https://webinar.ringcentral.com/webinar/register/WN_ExcQopQXSO6qE_bAsksWQg
We have a client that would like the ability to have file attachments (PDFs) automatically attached to customer opportunity files in Acumatica. We were thinking this might be triggered by a string in the subject line of the email that identifies the opportunity or customer.Has anyone done this, or is it doable? Thanks,Scott
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.